A patch from Microsoft’s November Patch Tuesday 2022 is causing issues in database environment SQL Server. Microsoft confirmed the problem in an official statement. According to the tech giant, a fix won’t be available until the next round of updates.

The issues arise on systems patched with the KB5019980 security update. Applications that use the Open Database Connectivity (ODBC) interface for SQL Server can no longer connect to the SQL Server Driver. As a result, the database is inaccessible.

Some connection attempts generate error messages when the connection fails. Examples include ‘the EMS System encountered a problem,’ ‘protocol error in TDS Stream’ and ‘unknown token received from SQL Server’.

Multiple versions affected

Only systems updated with the KB5019980 security patch seem to be affected. These include Windows 11 22H2 and 21H2, Windows 10 22H2, 21H1 and 20H2, Windows 10 Enterprise LTSC 2019 and LTSC 2016, Windows 10 Enterprise 2015 LTSB, Windows 8.1 and Windows 7 SP1.

The issues were also found in Windows Server 2022, 2019 and 2016, Windows Server 2012 R2 and 2012, Windows Server 2008 R2 SP1 and Windows Server 2008 SP2. Microsoft indicates there is no workaround available at this time. The problem is expected to be fixed in the next release.

Tip: Microsoft introduces SQL Server 2022