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>


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


Modify DSM server database’s sa password, mirror database failed

Publication Date:  2012-11-09 Views:  75 Downloads:  0
Issue Description
In Maintenance process has modified DSM server database’s sa password, lead to mirror database failed.
Alarm Information
Handling Process
Step one: modify the three database server’s password in MSSQL.
Step two: in DSM server (load sharing machine also need to change) end reconfigure the configuration file which connected with database, restart DSM server.
Root Cause
The problem is strongly related with the operation of the database, there is requirement in operating and configuring the database and mirror database of the server, if not according to the requirement operating, it will appear mirror database failure phenomenon; the following is some simple summary:
1 database and mirror database fit MS SQL Server.
2 use mirror way do database hot backup, primary, the communication password among the primary, backup and witness these three database instances is set according to the way provided by Microsoft, our product is just integrated a interface, then performed some scripts in accordance with the requirements of the Microsoft to realize the function of the mirror.
3 Microsoft don't recommend modify the user name and password among the three instances. If must modify, need to modify the three server end’s password in MS SQL Server. At the same time also need in DSMServer modify the configured account name and password. Restart dsmserver service at last.
After configured the sa password in the first installing, suggest not modify the sa password in the subsequent.