Issue
Database initialization completes with errors
Product Line
Andover Continuum
Environment
Cyberstation installation
Cause
When running database initialization you will need full access to all of the database.
Otherwise you may see errors similar to the following:
Installation Error! <[Microsoft][ODBC SQL Server Driver][SQL Server]The SELECT permission was denied on the object 'syscategories', database 'msdb', schema 'dbo'.>
Installation Error! <[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the procedure 'dt_IsColumnDifferent', because it does not exist or you do not have permission.>
Resolution
Ensure that the Andover97 account has DBO privilege to the ContinuumDB, if not run the "Change DB Owner" query to restore Andover97 as the DBO, see Unable to Initialize Continuum Database following installing no SQL instance.
The above errors relate to setting up the SQL Server Agent Jobs that are held in the MSDB part of the database. Check that Andover97 does have the user mapping to this part of the database as per the following screenshot:
Also ensure your Windows User account has the required Administrator privileges to allow full access to the SQL database and its files.
