How to create logins on Mirror server

Question

 

Hi

 

we have setup the mirroring on production databases. Last night I failed over the databases first time and created the users there in the mirror server (which is primary after failover). But we are not able to login the server, getting the error"can not connect to the server, login failure". Could some one tell me how can I get rid of this error. Thanks!

 

Answer 1

The proper way to transfer logins between SQL Server instance is not to create the same users with the same passwords and given the same permissions as the SID values for these accounts from the primary and the standby are different.  Follow the instructions defined in this KB article on how to transfer logins between SQL Server instances

http://support.microsoft.com/kb/246133

http://support.microsoft.com/kb/918992/

Answer 2

You can use Transfer login task to transfer the logins from the principal server to the mirror server. Check the article written by Deepak @ http://sql-articles.com/index.php?page=articles/ssis_transfer_logins.html.