Issue
After installing a new SQL server and installing CyberStation on a workstation PC, Database Initialization is unable to connect to the database.
Product Line
Andover Continuum
Environment
- SQL
- Database Initialization
Cause
The Database has not been assigned with a correct owner.
Resolution
- In SQL Server Management Studio, highlight ContinuumDB.
- Right Click on ContinuumDB.
- Select "New Query"
- In the query field type SP_ChangeDBOwner 'Andover97'
- Run the query
- Once the query returns Success, it should be possible to Initialize the Database successfully.