August 12, 2008 at 10:22 pm
Hi
I have UAT sql instance (stand by/read only) which is beign refreshed from the production server databse. Now if am trying to create new user on this UAt instance it is not allowing to select that database for access.
Can any one please confirm cant we create new user on stand by or if it's possible how can i create new user for this database.
Thanks in advance
August 12, 2008 at 10:40 pm
Transfer the login according to the following:
How to transfer the logins and the passwords between instances of SQL Server 2005
This will ensure that the SIDs match up. The login will automatically have access to the log shipped database.
K. Brian Kelley
@kbriankelley
August 12, 2008 at 10:44 pm
thanks for the reply Brian....here i dont want users present in the source instance(production) while i need to create new user id on the UAT instance only.
August 12, 2008 at 11:04 pm
That approach won't work because at the root of it all you're doing a backup from one server and restoring to another in a continuous fashion. If you want the login in UAT it's going to have to be in production while the database is being log shipped. However, remember that logins are in the master database. That means you can create the login on the production server and disable it. You can take that same login and recreate it in UAT but keep it enabled. That should get you the login with access in UAT but blocked in production.
K. Brian Kelley
@kbriankelley
August 13, 2008 at 12:50 am
thanks much for the workaround..let me try that way:)
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply