AppInsight for SQL is Unknown after installing MS KB 5022289

Yesterday, we had a patching cycle in our environment where MS KB 5022289 was installed on our MS SQL Servers. Since then, all of our Databases have been unable to be polled correctly which leads them to be in the Applications with Problems section of our SolarWinds.

In the KB Article, it mentions the following:

This update addresses a known issue that affects apps that use Microsoft Open Database Connectivity (ODBC) SQL Server Driver (sqlsrv32.dll) to connect to databases. The connection might fail. You might also receive an error in the app, or you might receive an error from the SQL Server.

Source: https://support.microsoft.com/en-us/topic/january-10-2023-kb5022289-os-build-14393-5648-36de3673-55d0-4e0f-8b77-d06326b58456

I was wondering if anybody else had experienced anything similar once this patch was installed.

Find more posts tagged with

appinsight_for_sql

sam

kb5022289

Comments

mbutler756

I removed the offending KB to see if that would resolve the issue - sadly, it has not. I will continue to troubleshoot the issue and update here if I find out more

mbutler756

I found one more KB 5019081 that was just recently installed that may relate to it. Removing that update to do some additional testing.

https://support.microsoft.com/en-us/topic/november-8-2022-security-update-kb5019081-d53a4cf1-0987-4ab7-a529-23f7136f4083