Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 

Changing the Andover97 password in SQL.

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?

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 you will have to do this on each workstation.

You may also be interested in the following article that discusses how Continuum uses the sa password.
http://buildingskb.schneider-electric.com/view.php?AID=12665
 

Tags (1)
Labels (1)
Version history
Revision #:
1 of 1
Last update:
a week ago
Updated by: