.NET app does not connect to SQl Server 2008 R2 and SQL Express database after Windows 11 Upgrade

George Boast 0 Reputation points
2023-09-11T17:59:40.1833333+00:00

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
{count} votes

3 answers

Sort by: Most helpful
  1. Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
    2023-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


  2. 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)

    0 comments No comments

  3. George Boast 0 Reputation points
    2023-09-12T15:09:30.4066667+00:00

    That fixed it. Thank You all for the help.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.