A major bug affects Windows 10 and 11, Microsoft publishes a solution while waiting for a fix

Windows 11 and Windows 10 have been victims of a major bug for a few weeks. In early December, Microsoft acknowledged that in certain situations, connections to a database through Microsoft OBDC SQL Server can fail.

This failure is problematic or even critical. Why ? Any application that uses ODBC connections using the Microsoft ODBC SQL Server driver (sqlsrv32.dll) to access databases fails to connect. The user is faced with an error. The problem affects Windows 11 but also all other versions of Windows, namely Windows 10, Windows 8.1 and Windows 7.

This bug appeared following the publication of the November cumulative updates (Patch Tuesday). For Windows 11 for example the problem is introduced by KB5019980. While waiting for a fix Microsoft offers a workaround. It allows the PCs concerned to regain access.

There are two scenarios

If the application uses or can use the data source name (DSN, contraction of Data Source Name) to select ODBC connections, it is necessary to install the Microsoft 17 ODBC driver for SQL Server then select it using DSN. Microsoft adds

“We recommend the latest version of Microsoft ODBC Driver 17 for SQL Server because it has better compatibility with applications currently using the legacy Microsoft ODBC SQL Server Driver (sqlsrv32.dll) than Microsoft ODBC Driver 18 for SQL Server. »

If the application cannot use DSN, the application will need to be modified to allow DSN or to use a newer ODBC driver than the Microsoft ODBC SQL Server driver (sqlsrv32.dll).

At the moment Redmond does not offer any release date for the official fix. We must therefore be patient and use this solution while waiting. If you want to know if you are affected, just run the following command in a command prompt window:

READ  Windows 10, during installation Microsoft offers to upgrade to Windows 11

Tasklist /m sqlsrv32.dll

Here are the affected Windows versions.

Customer.

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

Waiter.

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