Hi, If I run "select * from sys.sql_logins" on my principal and mirrored servers it gives me the exact same results in terms of names, SID, created dates etc. The only discrepancies are with these:
Default database - on the principal it has the user database as the default for the logins, but on the mirrored server the logins list master as default. presumably that is because the mirrored version has a 'Restoring...' status. If there was a failover, would the default database change to be the user DB automatically?
Principal ID - these numbers are slighty out of sync between both servers. Can that be ignored?
I want to know that if mirrored failover occurs, will all SQL logins be fully functioning??