LinkedIn

Thursday, 11 November 2010

Re-map an SQL server login to a database login

Hello,


Sometimes users get un-mapped from the server to database login after a database restore.


Here is the command to fix it:
EXEC sp_change_users_login 'Auto_Fix', 'SRSUser'


RuSs