Fixing Orphaned users of mssql database
by rajesh[ Edit ] 2012-03-16 00:54:38
You should have SQL server management studio installed..
Start > All Programs > Microsoft SQL Server 2008 R2 > SQL Server
Management Studio.
To find any orphaned users on the SQL service run the following query in
Management Studio...
EXEC sp_change_users_login 'Report'
To fix any users that the above query identifies use the command...
EXEC sp_change_users_login 'Auto_Fix','<insert_username_here>'
