1

When attempting to failover many logins fail due to nonmatching passwords on both instances. Is there a way for me to replicate passwords to other servers for all logins which passwords do not match.

3

Logins are stored in master database. Since system databases cannot be part of AG (before sql server 2019 - From PASS summit 2018, MS announced that system dbs can be part of AG), they are not replicated by default.

The only way to do is to sync logins using sp_help_revlogin or use Late Robert Davis's script - Transferring Logins or use dbatools - Copy-DbaLogin (You can use -Force option, so that it will sync (drop and create) all the logins from source server to your destination server).

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.