SCOM 2019 Discovery Error

Copper Contributor

Hi All,

I have SCOM 2019 configured and for SQL Server database servers , Opsmanager showing below Discovery error , Please suggest us best way to resolve the Errors.

Exception Type: System.Data.SqlClient.SqlException
Message: The EXECUTE permission was denied on the object 'SQLAGENT_SUSER_SNAME', database 'msdb', schema 'dbo'.
Number: 229

 

Thanks in advance.

 

1 Reply

@snivas Hi, It seems to be a pretty straightforward issue, the user SQLAGENT_SUSER_SNAME does not have execute permission, Please validate the permission granted to the user and try again,