Share via

Accessing SQL Server 2022 from Windows XP

CARTIGNY Arnaud 0 Reputation points
2025-09-16T16:54:33.3366667+00:00

Hi,

I have a SQL Server on Windows 11,
and try to reach it with an old Windows XP.

I use .udl file and have the error:

[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.

What i've tried so far with my research:

  • Enabled TLS 1.0 one the SQL server 2022 host via registry
  • Allowed port 1433
  • Forced tcp with Network Library=dbmssocn and direct IP (ex: Provider=SQOLEDB.1; Data Source=192.168.x.x,1433; Initial Catalog= Database; User ID = sa; Password=xxx; Network Library=dbmssocn

I suspect its due to incompatibility between DBNETLIB and required TLS version, but im not sure. I do not need encrypted data.

Any help or suggestions would be greatly appreciated, i know this is a legacy setup , but i need it working short term before migrating.

Thanks!

SQL Server Database Engine

Answer recommended by moderator
  1. Erland Sommarskog 133.6K Reputation points MVP Volunteer Moderator
    2025-09-16T21:02:08.6066667+00:00

    That does indeed sound like a TLS problem. Did you restart the SQL Server machine after the registry change?

    It seems that SQL Server 2022 supports connection from TLS 1.0, if the OS supports it.

    I found a program that you can use to verify support in SQL Server for different versions of TLS: https://github.com/x509cert/TlsTest. You may want to try that. (Although, the risk is that it does not run on XP...)


0 additional answers

Sort by: Most helpful

Your answer

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