2232777 - Database error 229 at OPC in Solution Manager

The Solution Manager is monitoring a remote SQL Server database.

In SM21 transaction you can see the following error repeatedly:

"Database Error 229 at OPC"
"The SELECT permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'.
"Database Error 229"

By following the errors in the SM21, in ST11 it is possible to follow up more details about the errors:

In the application server that the error occurred, go to ST11 transaction and open the given dev_wXX file (in this case, you can see it is the dev_w25 file):

 

In the developer trace file you can see the following errors:

C  dbdsmss: DBSL99 SQL229
C  The SELECT permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'.
B  ***LOG BY2=> sql error 229 performing OPC [dbds         398]
B  ***LOG BY0=> The SELECT permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'. [dbds         398]
B  ***LOG BY1=> sql error 229 [dbacds       1843]
B  Connect to E83 as E83_SAPMonitor with OBJECT_SOURCE=SAPMonitor MSSQL_DBNAME=E83 MSSQL_SERVER=WHIPLASH-DB
...
C Mon Oct 19 10:00:17 2015
C  ERROR: -1 in function StartSelect (execute) [line 14752]
C  (229) [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]The SELECT permission was denied on the object 'sysjobs', dat
C  Error 99 (dbcode 229) in StartSelect
C  StartSelect: stmt of NULL_STMTID
 
C  dbdsmss: DBSL99 SQL229
C  The SELECT permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'.
B  ***LOG BY2=> sql error 229 performing OPC [dbds         398]
B  ***LOG BY0=> The SELECT permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'. [dbds         398]
B  ***LOG BY1=> sql error 229 [dbacds       1843]

OR

C  dbdsmss: DBSL99 SQL229
C  The SELECT permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'.
B  ***LOG BY2=> sql error 229 performing OPC [dbds         398]
B  ***LOG BY0=> The SELECT permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'. [dbds         398]
B  ***LOG BY1=> sql error 229 [dbacds       1843]
B  Connect to E83 as E83_SAPMonitor with OBJECT_SOURCE=SAPMonitor MSSQL_DBNAME=E83 MSSQL_SERVER=WHIPLASH-DB
...
C Mon Oct 19 10:00:17 2015
C  ERROR: -1 in function StartSelect (execute) [line 14752]
C  (229) [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]The SELECT permission was denied on the object 'sysjobs', dat
C  Error 99 (dbcode 229) in StartSelect
C  StartSelect: stmt of NULL_STMTID
 
C  dbdsmss: DBSL99 SQL229
C  The SELECT permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'.
B  ***LOG BY2=> sql error 229 performing OPC [dbds         398]
B  ***LOG BY0=> The SELECT permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'. [dbds         398]
B  ***LOG BY1=> sql error 229 [dbacds       1843]

• SAP Solution Manager 7.1;
• Windows Server 2003 and higher;
• MS SQL Server 2005 and higher.

SELECT PERMISSION DENIED, denied on sysjobs, SOLMAN, solman, datenbank zugriff verweigert, datenbank zugriff , KBA , BC-DB-MSS-CCM , CCMS/Database Monitors for SQL Server , Problem