Home > IT Answers > Development > SQL Database User
Rick Martinez
585 pts.
 SQL Database User
SQL, SQL Server, SQL Server 2005, SQL Server backup, SQL Server security
Hello, I have 3 servers running sql server 2005 server1, server2, and server3 with database1 and database2 respectively. I backup database1 on server1 and backup database2 on server2 then I restore database1 and database2 on server3 as read-only on a daily basis. I only want to use one sql login (user1). Can I create the sql login on server3 and copy the UID to server1 and server2 so when I restore the databases on server3 the sql login will work? Or what would be the best way to handle this?

Software/Hardware used:
SQL Server 2005
ASKED: September 14, 2009  9:22 PM
UPDATED: September 15, 2009  1:54 PM
RELATED QUESTIONS
Answer Wiki:
Sort of. You'll create the login on one server. Then when you create the login on the other two servers you'll want to specify the SID, so that when the databases are restored the SIDs match.
Last Wiki Answer Submitted:  September 14, 2009  11:58 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Thanks again Mr.Denny that was the answer to my question.

Rick Martinez
 585 pts.