No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

The network connection is normal, but database mirror function become invalid.

Publication Date:  2012-10-31 Views:  61 Downloads:  0
Issue Description
The network connection among Primary, Backup and Witness three database Servers is normal, but database mirror function become invalid.
Alarm Information
none
Handling Process
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.
Root Cause
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.
Suggestions
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.

END