Applications Systems

List resources does not detect the AppInsight for SQL when a Node polled by SNMP is running a Microsoft SQL Server 2022

MS SQL 2022 is not detected by Discovery or List Resources in the SolarWinds Platform.

First published date

2/11/2025 9:19 AM

Last published date

2/11/2026 12:25 AM

Overview

When adding or running a list resources on a Windows node polled by SNMP, the discovery does not detect the Appinsight for SQL if the node runs a Microsoft SQL Server 2022 instance.

The discovery log shows:

MsSqlDetection - NotApplicable (003.54s): [No supported instances of SQL server detected]

The result is the Appinsight for SQL does not appear in the List Resources.

Product section

Server Application Monitor

Cause

Known issue.

The C:\Program Files\SolarWinds\Orion\SolarWinds.APM.BlackBox.Sql.DiscoveryPlugin.dll.config file is missing the following entry:

"Microsoft SQL Server 2022 (64-bit)"

Current content:

<add key="SupportedServers" value="
Microsoft SQL Server 2008 (64-bit),
Microsoft SQL Server 2008 R2 (64-bit),
Microsoft SQL Server 2012 (64-bit),
Microsoft SQL Server 2014 (64-bit),
Microsoft SQL Server 2016 (64-bit),
Microsoft SQL Server 2017 (64-bit),
Microsoft SQL Server 2019 (64-bit),
Microsoft SQL Server 2008 Database Engine Services,
SQL Server 2008 R2 Database Engine Services,
SQL Server 2012 Database Engine Services,
SQL Server 2014 Database Engine Services,
SQL Server 2016 Database Engine Services,
SQL Server 2017 Database Engine Services,
SQL Server 2019 Database Engine Services" />

Resolution

This issue is addressed in SolarWinds Platform 2026.1. Consider upgrading your environment. If you cannot upgrade, use the workaround below.

Workaround:

1- RDP the poller engine where the SQL 2022 node is assigned and stop the SolarWinds services.

2- Backup the C:\Program Files\SolarWinds\Orion\SolarWinds.APM.BlackBox.Sql.DiscoveryPlugin.dll.config file.

2- Open Notepad as admin and edit the C:\Program Files\SolarWinds\Orion\SolarWinds.APM.BlackBox.Sql.DiscoveryPlugin.dll.config file.

3- Add "Microsoft SQL Server 2022 (64-bit)" to the list of SupportedServers and save the file:

<add key="SupportedServers" value="
Microsoft SQL Server 2008 (64-bit),
Microsoft SQL Server 2008 R2 (64-bit),
Microsoft SQL Server 2012 (64-bit),
Microsoft SQL Server 2014 (64-bit),
Microsoft SQL Server 2016 (64-bit),
Microsoft SQL Server 2017 (64-bit),
Microsoft SQL Server 2019 (64-bit),
Microsoft SQL Server 2022 (64-bit),
Microsoft SQL Server 2008 Database Engine Services,
SQL Server 2008 R2 Database Engine Services,
SQL Server 2012 Database Engine Services,
SQL Server 2014 Database Engine Services,
SQL Server 2016 Database Engine Services,
SQL Server 2017 Database Engine Services,
SQL Server 2019 Database Engine Services" />

4- Start the SolarWinds services and try to list resources for the affected SQL 2022 Node polled by SNMP, the Appinsight for SQL should appear.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.