MSSQL 2016: Monitoring failed

I ran into this error when using SCOM 2012 R2 for monitoring SQL 2016 and didn’t find any good solution fast on google so i decided to create one myself when i found the solution.

The error message SCOM gave me was.

After som research if found out that the run as account the agent was using tried to use c:\windows\temp to save files and it does not have access to that folder. After i gave permission to c:\windows\temp to the run as account the alert went away.

One thought on “MSSQL 2016: Monitoring failed

  1. Benj Eliseo

    Hi, I came across these steps in culham.net. These might help.

    1.Open Windows Explorer and navigate to C:\Windows.
    2. Right click on the Temp folder and choose “Properties”.
    3. Choose the “Security” Tab then click the “Edit” button.
    4. Click “Add” and enter in the name of your Run As account and click “Check Names”. Click “OK”.
    5. In the Permissions window grant delete, read and write permissions to this account or give it “Full
    Control”.
    6. Click “OK” and “OK” again.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *