The network connection among Primary, Backup and Witness three database Servers is normal, but database mirror function become invalid.
1. Modify the three Servers password at which configure mirror in Microsoft SQL Server.
2. Modify the account name password in DSM Server database configuration and restart DSM Server service.
Maybe the password of a database mirror server communication account sa is changed.
when Primary, Backup and Witness three database is in initial configuration, has writte the fixed sa password, if change password, will lead to a database can't communicate with other database, and mirror is destroyed.
After use mirror way to make database Backup, the communication password among Primary ,Backup and Witness three database instance is according to Microsoft provides way to configure. Our product is just integrated into an interface, then according to the Microsoft requirements to execute some scripts to realize the mirror.
Microsoft do not recommend change any password of the three frequently, it is easy to cause the mirror failure.