Database connections using the Microsoft ODBC SQL Server driver may now fail as a result of the recent Patch Tuesday update.
According to update to Windows health dashboard (opens in a new tab)users who have installed the database utility update that was part of the update named KB5019980 receive an error message in the application or via SQL server.
This message might look like “EMS encountered a problem” along 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.”
What now?
Microsoft promises that it is trying to fix the problem of defective updates and will provide an update in an upcoming release.
Update (opens in a new tab) it was originally intended to address a problem that affected File Explorer, which meant the tool was not locating folders, as well as security issues in the Windows operating system.
If you don’t know if you’re using any of the affected apps, Microsoft says to open all apps that use the database and then open a command prompt.
Users should then select Start, then type Command Prompt and select it, then type in the following command: tasklist /m sqlsrv32.dll.
This isn’t the first time in 2022 we’ve seen Tuesday’s update cause problems.
The KB5002112 and KB5002121 updates reportedly affected access to MS Access runtime applications.
Another Patch Tuesday update, called KB5018410, reportedly caused issues for OneDrive and OneDrive for Business users, allegedly causing OneDrive to “shut down unexpectedly” for some Windows 10 users.
But perhaps we will soon see the end of the patch on Tuesday, and we know it well.
In July 2022, Microsoft introduced a tool that will use Windows Update for Business to automatically deploy important updates.
Dubbed Microsoft Autopatch, the tool for Windows 10 and 11 as well as Microsoft Edge and Microsoft 365 is now available to users with Windows Enterprise E3 and E5 licenses.