如何从windows xp连接到SQL Server 2017

46scxncf 于 2022-12-10 发布在 Windows

关注(0)|答案(1)|浏览(164)

We have some xp (very old) machines that can't connect to sql server 2017 (runs on Linux). We try to test connection with ODBC. The problem has to do with SSL.
Is there a way to turn it off, so it can work?

Error Message : Microsoft SQL Server Login
Connection failed:
SQLState: '01000'
SQL Server Error: 772
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(SECDoClientHandshake()).
Connection failed:
SQLSTATE: '08001'
SQL Server Error: 18
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error

sql-server

来源：https://stackoverflow.com/questions/55687080/how-can-i-connect-from-windows-xp-to-sql-server-2017

1条答案

按热度按时间

uqzxnwby1#

I had the same problem and got the solution on https://www.smartftp.com/pt-br/support/kb/2754 . Here are the steps, in the case this link goes south.
The solution involves adding support for TLS 1.2 on XP, available for "Windows Embedded POSReady 2009", which is based on Windows XP SP3 (more info at https://en.wikipedia.org/wiki/Windows_Embedded_Industry#Windows_Embedded_POSReady_2009).
To make it work on "plain old XP", you'll need to add the following to the Windows Registry:

[HKEY_LOCAL_MACHINE\SYSTEM\WPA\PosReady] 
"Installed"=dword:00000001

Next, the registry entries for TLS:

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.1\Client]
"DisabledByDefault"=dword:00000000

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.1\Server]
"DisabledByDefault"=dword:00000000

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client]
"DisabledByDefault"=dword:00000000

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Server]
"DisabledByDefault"=dword:00000000

Next is to get the needed update at Microsoft, KB4019276 ( https://support.microsoft.com/en-us/help/4019276/update-to-add-support-for-tls-1-1-and-tls-1-2-in-windows ). Install the update and reboot.

赞(0）回复(0）举报 2022-12-10

我来回答

如何从windows xp连接到SQL Server 2017

1条答案

相关问题

热门标签

最新问答