Share via

Unable to discover SQL instance in both SQL Seed Class and SQL DB Engine on Windows using Addendum MP

Daniel C 1 Reputation point
2023-01-09T11:08:34.37+00:00

Please can you help with this issue?
We are unable to discover a SQL server 2016 that is running on a Windows 10 client that is reporting in SCOM and OS of client appears healthy.
We have been enabling SQL monitoring for other computers without issues and this is strange case. We are using Kevin Holman's Addendum MP.

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,521 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 115.6K Reputation points MVP
    2023-01-09T22:37:10.593+00:00

    I am not acquainted with Addendum MP, and I have a feeling that maybe you should have included the appropriate mem- tag to target people who know SCOM.

    However, I have an idea of what might be the reason. On that server, open SQL Server Configuration Manager. Find the node SQL Server protocols. Right-click on the server itself in the left pane (and not any of the protocols to the right) and select Properties. Could it be that Hide Instance is set to Yes?

    See screenshot below.

    277547-image.png

    1 person found this answer helpful.
    0 comments
  2. SChalakov 10,491 Reputation points MVP
    2023-01-10T08:36:14.4+00:00

    Hi @Daniel C ,

    the reason for this is that the SQL Server Monitoring is supported only on Server Operating Systems, so most probably the disocveries are targeted only the WIndows Server OS classes and not to the client POS classes. This is stated here:

    Scope and Supported Configuration in Management Pack for SQL Server https://learn.microsoft.com/en-us/system-center/scom/sql-server-management-pack-supported-configuration?view=sc-om-2016&WT.mc_id=EM-MVP-5002219

    277766-image.png

    I hope I could help you with that.

    (If the reply was helpful please don't forget to upvote and/or accept as answer, thank you) Regards Stoyan Chalakov

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.