Aug 05 2021
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.SqlExceptionMessage: The EXECUTE permission was denied on the object 'SQLAGENT_SUSER_SNAME', database 'msdb', schema 'dbo'.Number: 229
Thanks in advance.
Aug 18 2021
@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,