Getting Installation Error! with permission was denied on the object or you do not have permission from database initialization.

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 Lessons Learned article#7263.

 

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.