Skip to content

Instantly share code, notes, and snippets.

@stevenh77

stevenh77/fixorphanedsqlusers

Created October 26, 2014 13:22
Show Gist options
  • Save stevenh77/adea1c01e2e143746412 to your computer and use it in GitHub Desktop.
Save stevenh77/adea1c01e2e143746412 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
fixorphanedsqlusers
-- tells you the orphaned users
EXEC sp_change_users_login 'report'
-- to fix if you already have the server login:
EXEC sp_change_users_login 'Auto_Fix', 'enter your username here'
-- to fix if you don't already have the server login:
EXEC sp_change_users_login 'Auto_Fix', 'user', 'enter your login here', 'enter your password here'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment