SQL Database User
Home > IT Answers > Development > SQL Database User
RickMartinez
85 pts.
0
Q:
SQL Database User
SQL, SQL Server, SQL Server security, SQL Server 2005, SQL Server backup
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: Sep 14 2009  9:22 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Sep 14 2009  11:58 PM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

RickMartinez   85 pts.  |   Sep 15 2009  1:54PM GMT

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

 
0