That fixed it. Thank You all for the help.
.NET app does not connect to SQl Server 2008 R2 and SQL Express database after Windows 11 Upgrade
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 7.000000000000001%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
George Boast
0
Reputation points
Does anyone know if there is a fix to this ? After installing Windows 11, my .NET app does not connect to SQl Server 2008 R2 or Sql Express anymore. I get an SSL Security Error
Windows for business | Windows Client for IT Pros | User experience | Other
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2023-09-28T08:58:26.3133333+00:00 Hi,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Sign in to comment
3 answers
Sort by: Most helpful
-
George Boast 0 Reputation points
2023-09-11T20:48:56.84+00:00 it returns this. Are you saying the issue is with the SQL Server and not the windows 11 PC?
Microsoft SQL Server 2012 - 11.0.5058.0 (X64) May 14 2014 18:34:29 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
-
Erland Sommarskog 134.4K Reputation points MVP Volunteer Moderator2023-09-11T20:35:07.5733333+00:00 What does "SELECT @@version" return? It seems that you are running a version of SQL 2008 R2 that does not support TLS 1.2. To that end you need to install Service Pack3 and then there is another patch on top of that.
I believe that the fix you need is https://www.microsoft.com/en-us/download/details.aspx?id=56415
-
George Boast 0 Reputation points
2023-09-11T20:47:38.9333333+00:00 it returns this. Are you saying the issue is with the SQL Server and not the windows 11 PC?
Microsoft SQL Server 2012 - 11.0.5058.0 (X64) May 14 2014 18:34:29 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
-
Erland Sommarskog 134.4K Reputation points MVP Volunteer Moderator
2023-09-11T21:05:35.9166667+00:00 Well, it is a combination. You version of SQL Server, which is SQL 2012 SP2, only supports TLS 1.0. Windows 11 does not support that version of TLS, since it is completely insecure. Windows 11 only supports TLS 1.2 and 1.3. And overall, a combination of softwares that differs in age in about ten years often poses problem.
In any case, you need to install Servlce Pack 4 for SQL 2012 to get TLS 1.2 support.
-
Sign in to comment -