Issue
- The network administrator requires that the SQL Andover97 password be changed every three months.
- How will this affect the Continuum System?
- Is it necessary to do a Database Initialization each time the password is changed?
Product Line
Andover Continuum
Environment
- Andover97
- SQL
- Database Initialization
Cause
Once the Andover97 password has been changed, the workstations will lose their connection with their access to the database until the workstation (not the database) can be initialized with the new password. This will be indicated by a Database Fault error at the workstations.
Resolution
The proper way to change to transition to the new password is to:
- Shut down all cyberstations.
- Change the Andover97 password in SQL.
- Launch Continuum Database Initialization.
- Select Workstation and enter the new password on the Database page, then select OK.
- Relaunch all cyberstations.
Once the password is changed, it is only necessary to do perform a workstation initialization (not a database initialization), but this must be done on each workstation.
Refer also to the following article that discusses how Continuum uses the sa password: When is the SQL System Admin (sa) password required?
