{"id":27903,"date":"2022-12-06T18:25:24","date_gmt":"2022-12-06T17:25:24","guid":{"rendered":"http:\/\/159.69.82.204\/win\/?p=27903"},"modified":"2022-12-09T19:49:20","modified_gmt":"2022-12-09T18:49:20","slug":"windows-november-2022-updates-cause-odbc-connection-problems-with-sql-databases","status":"publish","type":"post","link":"https:\/\/borncity.com\/win\/2022\/12\/06\/windows-november-2022-updates-cause-odbc-connection-problems-with-sql-databases\/","title":{"rendered":"Windows: November 2022 updates cause ODBC connection problems with SQL databases"},"content":{"rendered":"<p><img decoding=\"async\" style=\"float: left; margin: 0px 10px 0px 0px; display: inline; border-width: 0px;\" title=\"Update\" src=\"https:\/\/www.borncity.com\/blog\/wp-content\/uploads\/2021\/06\/Update-01.jpg\" alt=\"Update\" align=\"left\" border=\"0\" \/>[<a href=\"https:\/\/www.borncity.com\/blog\/2022\/12\/06\/windows-november-2022-updates-verursachen-odbc-verbindungsprobleme-bei-sql-datenbanken\/\" target=\"_blank\" rel=\"noopener\">German<\/a>]It looks like the Windows updates released by Microsoft in November 2022 may cause problems accessing SQL databases. Then the ODBC driver triggers a database access error. According to Microsoft, all Windows versions that are still supported (both clients and servers) are affected by this problem. There is no solution for this problem yet.<\/p>\n<p><!--more--><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/vg01.met.vgwort.de\/na\/a50568b0bd034c2b9463a8e905642fa1\" alt=\"\" width=\"1\" height=\"1\" \/>Microsoft has confirmed the problem as of Dec. 5, 2022, in the Windows Release Health status area (for example, of Windows 11 22H2) in the post <a href=\"https:\/\/learn.microsoft.com\/en-us\/windows\/release-health\/status-windows-11-22h2#database-connections-using-microsoft-odbc-sql-server-driver-might-fail-\" target=\"_blank\" rel=\"noopener\">Database connections using Microsoft ODBC SQL Server driver might fail<\/a>. It states there:<\/p>\n<blockquote><p>After installing [the xxxx update], applications that use ODBC connections with the Microsoft ODBC SQL Server driver (sqlsrv32.dll) to access databases may not be able to connect.<\/p>\n<p>You may receive an error message within the application or you may receive an error message from SQL Server, such as.<\/p>\n<p>The EMS system has detected a problem<br \/>\nMessage: [Microsoft][ODBC SQL Server Driver] Protocol error in TDS stream<\/p>\n<p>or<\/p>\n<p>Message: [Microsoft][ODBC SQL Server Driver]SQL Server Driver]Unknown token received from SQL Server<\/p><\/blockquote>\n<p>The following Windows client versions are affected if the appropriate November 2022 update is installed:<\/p>\n<ul>\n<li><a href=\"https:\/\/support.microsoft.com\/help\/5019980\" target=\"_blank\" rel=\"noopener\">KB5019980<\/a>: Windows 11, version 22H2<\/li>\n<li><a href=\"https:\/\/support.microsoft.com\/help\/5019961\" target=\"_blank\" rel=\"noopener\">KB5019961<\/a>: Windows 11, version 21H2<\/li>\n<li><a href=\"https:\/\/support.microsoft.com\/help\/5019959\" target=\"_blank\" rel=\"noopener\">KB5019959<\/a>: Windows 10, version 20H2-22H2<\/li>\n<li><a href=\"https:\/\/support.microsoft.com\/help\/5019966\" target=\"_blank\" rel=\"noopener\">KB5019966<\/a>: Windows 10 Enterprise LTSC 2019<\/li>\n<li><a href=\"https:\/\/support.microsoft.com\/help\/5019964\" target=\"_blank\" rel=\"noopener\">KB5019964<\/a>: Windows 10 Enterprise LTSC 2016<\/li>\n<li><a href=\"https:\/\/support.microsoft.com\/help\/5019970\" target=\"_blank\" rel=\"noopener\">KB5019970<\/a>: Windows 10 Enterprise 2015 LTSB<\/li>\n<li><a href=\"https:\/\/support.microsoft.com\/help\/5020023\" target=\"_blank\" rel=\"noopener\">KB5020023<\/a>, <a href=\"https:\/\/support.microsoft.com\/help\/5020010\" target=\"_blank\" rel=\"noopener\">KB5020010<\/a>: Windows 8.1<\/li>\n<li><a href=\"https:\/\/support.microsoft.com\/help\/5020000\" target=\"_blank\" rel=\"noopener\">KB5020000<\/a>, <a href=\"https:\/\/support.microsoft.com\/help\/5020013\" target=\"_blank\" rel=\"noopener\">KB5020013<\/a>: Windows 7 SP1<\/li>\n<\/ul>\n<p>and also the following Windows Server versions<\/p>\n<ul>\n<li><a href=\"https:\/\/support.microsoft.com\/help\/5019081\" target=\"_blank\" rel=\"noopener\">KB5019081<\/a>: Windows Server 2022<\/li>\n<li><a href=\"https:\/\/support.microsoft.com\/help\/5019966\" target=\"_blank\" rel=\"noopener\">KB5019966<\/a>: Windows Server 2019<\/li>\n<li><a href=\"https:\/\/support.microsoft.com\/help\/5019964\" target=\"_blank\" rel=\"noopener\">KB5019964<\/a>: Windows Server 2016<\/li>\n<li><a href=\"https:\/\/support.microsoft.com\/help\/5020023\" target=\"_blank\" rel=\"noopener\">KB5020023<\/a>, <a href=\"https:\/\/support.microsoft.com\/help\/5020010\" target=\"_blank\" rel=\"noopener\">KB5020010<\/a>: Windows Server 2012 R2<\/li>\n<li><a href=\"https:\/\/support.microsoft.com\/help\/5020009\" target=\"_blank\" rel=\"noopener\">KB5020009<\/a>, <a href=\"https:\/\/support.microsoft.com\/help\/5020003\" target=\"_blank\" rel=\"noopener\">KB5020003<\/a>: Windows Server 2012<\/li>\n<li><a href=\"https:\/\/support.microsoft.com\/help\/5020000\" target=\"_blank\" rel=\"noopener\">KB5020000<\/a>, <a href=\"https:\/\/support.microsoft.com\/help\/5020013\" target=\"_blank\" rel=\"noopener\">KB5020013<\/a>: Windows Server 2008 R2 SP1<\/li>\n<li><a href=\"https:\/\/support.microsoft.com\/help\/5020019\" target=\"_blank\" rel=\"noopener\">KB5020019<\/a>: Windows Server 2008 SP2<\/li>\n<\/ul>\n<p>To check whether the driver for Microsoft SQL Server is affected, the following command can be entered in an administrative command prompt.<\/p>\n<p>tasklist \/m sqlsrv32.dll<\/p>\n<p>If the process appears and the error is reported, the system is affected by the problem. So far, there is no fix (other than uninstalling the update). Microsoft is working on this problem and wants to fix it via update in the future. (<a href=\"https:\/\/www.deskmodder.de\/blog\/2022\/12\/06\/windows-11-10-und-server-datenbankverbindungen-schlagen-moeglicherweise-fehl\/\" target=\"_blank\" rel=\"noopener\">via<\/a>)<\/p>\n<p><strong>Similar articles:<\/strong><a href=\"https:\/\/borncity.com\/win\/2022\/11\/09\/patchday-windows-10-updates-november-8-2022\/\">Patchday: Windows 10-Updates (November 8, 2022)<\/a><br \/>\n<a href=\"https:\/\/borncity.com\/win\/2022\/11\/09\/patchday-windows-11-server-2022-updates-november-8-2022\/\">Patchday: Windows 11\/Server 2022-Updates (November 8, 2022)<\/a><br \/>\n<a href=\"https:\/\/borncity.com\/win\/2022\/11\/09\/windows-7-server-2008-r2-windows-8-1-server-2012-r2-updates-november-8-2022\/\">Windows 7\/Server 2008 R2; Windows 8.1\/Server 2012 R2: Updates (November 8, 2022)<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>[German]It looks like the Windows updates released by Microsoft in November 2022 may cause problems accessing SQL databases. Then the ODBC driver triggers a database access error. According to Microsoft, all Windows versions that are still supported (both clients and &hellip; <a href=\"https:\/\/borncity.com\/win\/2022\/12\/06\/windows-november-2022-updates-cause-odbc-connection-problems-with-sql-databases\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[463,22,2],"tags":[47,2751,195,194],"class_list":["post-27903","post","type-post","status-publish","format-standard","hentry","category-issue","category-update","category-windows","tag-issue","tag-patchday-11-2022","tag-update","tag-windows"],"_links":{"self":[{"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/posts\/27903","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/comments?post=27903"}],"version-history":[{"count":0,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/posts\/27903\/revisions"}],"wp:attachment":[{"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/media?parent=27903"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/categories?post=27903"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/tags?post=27903"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}