Home Forums SQL Server 2005 Administering Mirroring and SQL logins... RE: Mirroring and SQL logins...
Lynn Pettis
SSC Guru
Points: 442467
More actions
August 21, 2012 at 8:02 am
#1528136
The key for the SQL Logins is the SID, and since they are the same, there should be no problems. As far as the default database changing on a failover, I'm not sure. The best way to find out is test it a test environment and see what happens.