LogShipping-logins | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


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
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.