Database connections using the Microsoft ODBC SQL Server driver can now fail due to a recent Patch Tuesday update.
According to an update from the Windows Health dashboard (opens in new tab)Users who installed the database tool update, which was part of an update named KB5019980, receive an error message in the app or through their SQL Server.
This message may look like this: “A problem has occurred in the EMS system” accompanied by “Message: [Microsoft][ODBC SQL Server Driver] Protocol error in TDS Stream” or “Message: [Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server”.
Microsoft promises that it is looking for a solution for the erroneous updates and will provide an update in an upcoming release.
The update (opens in new tab) was originally intended to address an issue affecting File Explorer, which meant the tool was unable to locate folders, as well as security vulnerabilities within the Windows operating system.
If you don’t know if you’re using one of the affected apps, Microsoft says to open all apps that use a database and then open the command prompt.
Users must then select Start, type and select command prompt, and then type the following command: tasklist /m sqlsrv32.dll.
This isn’t the first time in 2022 that a Tuesday patch update has caused problems.
The KB5002112 and KB5002121 updates reportedly affected access to MS Access runtime applications.
Another patch Tuesday update, dubbed KB5018410, reportedly caused problems for users of OneDrive and OneDrive for Business, causing OneDrive to “quit unexpectedly” for some Windows 10 users.
But maybe soon we’ll see the end of Patch Tuesday and know it too.
In July 2022, Microsoft rolled out a tool that will use Windows Update for Business to roll out important updates automatically.
Dubbed Microsoft Autopatch, the tool for Windows 10 and 11, and Microsoft Edge and Microsoft 365 is now available to users with Windows Enterprise E3 and E5 licenses.