Issue
When installing or upgrading Cyberstation, is the SQL sa password required?
Product Line
Andover Continuum
Environment
- Cyberstation and Web Client installation or upgrades
- Database Initialization application
- SQL 2005 and 2008 versions as per the compatibility matrix for the version being installed
- V1.9x
Cause
Sometimes the database initialization asks for a "sa" password, other times not, what determines this?
Resolution
During first installation of SQL it will ask for a new System Administrator (sa) password to be created.
When creating a new Continuum database the SQL sa password will be asked for or another password with full domain administrator rights could be used.
When updating an existing database you will sometimes be asked to enter the sa password, this is determined by the Database Initialization application. If the version it is upgrading from requires changes to be made to the SQL table structure, a new table created or new stored procedures to be created, then the sa password will be required, otherwise it will not be asked for.
NOTE:
- The "Andover97" account is not an "sa" account.
- The "Andover97" account needs to be the owner of "ContinuumDB" database and must have full access to it.
