MSSQL on Windows: Discovery error - SCOM 2019

AdamMohamed-3032 56 Reputation points
2023-11-24T10:44:14.5566667+00:00

Hello All,

We are using SQL Agnostic MP 7.0.42.0 and SCOM 2019 with UR 4.

I have been receiving alert for MSSQL on Windows: Discovery error and please find the below alert description for your reference. I have checked the permission with SQL team they said permissions are in place.

Please advise what to be followed to fix issue or should follow below article to fix this issue.

https://kevinholman.com/2021/07/14/sql-mp-7-0-32-0-brings-new-features-and-security-requirements/#comment-14146

Or Can we increase the timeout ?

Operations Manager
Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,417 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. XinGuo-MSFT 14,461 Reputation points
    2023-11-27T02:39:34.5133333+00:00

    Hi,

    To fix the "MSSQL on Windows: Discovery error" alert message in SCOM 2019, you can try increasing the timeout or checking the permissions with the SQL team.

    However, the error message you provided indicates that there is an issue with retrieving data for the request due to a timeout or the server not responding.

    You may want to check the server's performance and connectivity to ensure that it is not slow or unresponsive. Additionally, you can examine the discovery data for missing objects to see if there is a permission issue or an issue with WMI.

    References: