Fixing Orphaned users of mssql database

by rajesh 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>'
1085
like
0
dislike
0
mail
flag

You must LOGIN to add comments