April 3, 2008 at 3:25 pm
Hi,
How can I add logins to a Logshipping secondary database. It's in Standby / Read - Only mode. I'm running on SQL 2005 Standard Edition.
Is this possible? I've seen some info on this but nothing definitive.
Has anyone found a good document on how to do this?
Thanks,
Greg
April 3, 2008 at 7:35 pm
Create new login and user in Source DB with readonly access to DB.
Use SP_help_Revlogin SP on primary server and from the output
copy your newly created login details, execute that on destination.
so you get same login on destination without orphan user if it is sql login.
DB user will get prapogated with next log restore on destination server.
Provide user details of destination server only with login pw details.
Other than that I think Read_Only DB is for the purpose of reading only and better keep it that way.
Kindest Regards,
Sameer Raval [Sql Server DBA]
Geico Insurance
RavalSameer@hotmail.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply