When UMSSv550-560 ran as part of STAT upgrade to 5.6.0, we received below message:
User does not have permission to alter database 'XXXXXX', the database does not exist, or the database is not in a state that allows access checks. The current compatibility level is 100. * Data - STAT_DBSCRIPT_TBL * Verify SQL Server version * * The starting compatibility level is shown below The current compatibility level is 100. * * If received this message is normal - DBCC execution completed. If DBCC printed error messages, contact your system administrator. Msg 15418, Level 16, State 1, Procedure sp_dbcmptlevel, Line 78 Only members of the sysadmin role or the database owner may set the database compatibility level. * * The new changed compatibility level is shown below, which likely is the same as the before level The current compatibility level is 100. * * Verify Stat database version * Procedure STAT_COUNTS created *
Permission error and this is a SQL Server Database issue
1. You need to be member of sysadmin server role or db_owner database role.
2. Click on the link below to obtain more information:
3. Check with your DBA for further assistant with running the upgrade script.
