SCOM 2019 Discovery Error

%3CLINGO-SUB%20id%3D%22lingo-sub-2613991%22%20slang%3D%22en-US%22%3ESCOM%202019%20Discovery%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2613991%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3EI%20have%20SCOM%202019%20configured%20and%20for%20SQL%20Server%20database%20servers%20%2C%20Opsmanager%20showing%20below%20Discovery%20error%20%2C%20Please%20suggest%20us%20best%20way%20to%20resolve%20the%20Errors.%3C%2FP%3E%3CTABLE%20width%3D%22100%25%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%3CP%20class%3D%22description%22%3EException%20Type%3A%20System.Data.SqlClient.SqlException%3CBR%20%2F%3EMessage%3A%20The%20EXECUTE%20permission%20was%20denied%20on%20the%20object%20'SQLAGENT_SUSER_SNAME'%2C%20database%20'msdb'%2C%20schema%20'dbo'.%3CBR%20%2F%3ENumber%3A%20229%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2613991%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOperations%20Manager%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New 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,