September 10, 2008 at 10:55 am
Your assistance is greatly appreciated.
SQL 2005 sp2
Windows 2003 Server
How do you handle the following scenario:
Primary:
ServerName - Server 1
Database - ABC
Security User - Server1\user
Secondary:
ServerName - Server 2
Database - ABC
Security User - Server2\user
ABC database is backed up on server 1, the database is backed up, shipped and restored using log shipping to Server 2 but the security user account(s) contain server1\user therefore rendering the ABC database on the secondary server unaccessible. How can you change the accounts to server2\user?
Again, thank you for input.
September 10, 2008 at 2:18 pm
generate a script with the commands to add the Server2\user to ABC database and grant the user the necessary permissions.
You could script that user and his roles & permissions on Server1, then edit the script then run it on Server2.
The probability of survival is inversely proportional to the angle of arrival.
September 10, 2008 at 5:23 pm
We'll give it a shot. One piece of the puzzle I forgot to mention is that once the databases arrive on Server 2 they remain in a warm standby mode until a login is attempted from the web interface.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply