February 13, 2008 at 10:06 am
I have log shipping setup with my destination database in standby/read-only mode. I can only access this database with users that have the sysadmin database role. I would like other users to be able to access this database. Since it is in read-only I cannot add read access to any logins. I also cannot associate logins with existing users in the read-only database.
Can anyone help in being able to give users access to the standby/read-only database?
February 13, 2008 at 1:36 pm
I found a solution. I used sp_help_revlogin SP to create script of login on primary server which includes SID, which was the piece i was missing to associate the login on secondary box the the user in the log shipped database.
February 14, 2008 at 8:44 am
Create the logins in the primary and grant them access to the log shipped db. On the secondary, you have to add the logins using the same SID.
_____________
Donn Policarpio
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply