SQL Server Performance Forum – Threads Archive
LogShipping-logins
I have created my LS standby db in a secondary server. But, I have not transferred all my logins. I was accessing the standby db using the ‘sa’ account to query the tables (in between restores ofcourse). <br />Now I need to activate one of the login/user in the standby. I tried deleting this userlogin in the standby db — couldn’t delete. Tried creating a new user — failed.<br />Tried sp_change_users_login — failed. That user already exists in the db. So, I created a login in the standby server, and tried giving access — could’nt do it.[<img src=’/community/emoticons/emotion-6.gif’ alt=’
‘ />!]<br /><br />Is there any other way of accessing this read-only-standby db apart from ‘sa’ login.<br />Any help appreciated.<br /><br />bj
Review contents from this KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;314515 about Log shipping FAQ about resolving logins part. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>