Microsoft confirms a new bug affecting all supported versions of Windows 10 and 11. It also affects the latest version of Windows 11, 22H2.
This failure is linked to one of the latest updates deployed as part of Patch Tuesday last November. As we pointed out Windows 11 22H2 is also impacted and Microsoft explains that the responsible update in this case is KB5019980.
After installing update KB5019980, applications that use ODBC connections using the Microsoft ODBC SQL Server driver (sqlsrv32.dll) to access databases may fail to connect. You may receive an error in the application or you may receive an error from SQL Server, such as “EMS has encountered a problem” with “Message: [Microsoft] [ODBC SQL Server Driver] Protocol error in TDS Stream” or “Message: [Microsoft] [ODBC SQL Server Driver]Unknown token received from SQL Server.
If you want to know if you are affected by this problem, just run the following command in a command prompt window:
Tasklist /m sqlsrv32.dll
Microsoft explains that a fix is in development. However, we have no information on its release date or online availability. As for the affected Windows versions, here is the list
Windows 11, version 22H2; Windows 10, Version 22H2, Windows 11, Version 21H2, Windows 10, Version 21H2, Windows 10, Version 21H1, Windows 10, Version 20H2, Windows 10 Enterprise LTSC 2019, Windows 10 Enterprise LTSC 2016, Windows 10 Enterprise 2015 LTSB, Windows 8.1 , Windows 7 SP1
Windows Server 2022, Windows Server 2019, Windows Server 2016; Windows Server 2012 R2, Windows Server 2012, Windows Server 2008 R2 SP1, Windows Server 2008 SP2
It is likely that the fix will be offered during the next Patch Tuesday, scheduled for December 13.