Sql-server – Connect windows 2000 to sql server 2016

sql-server-2016ssl

I have a really old piece of industrial equipment that connects from windows professional to a sql server 2008r2 on win 2008R2, not completely patched.
We cannot replace the windows 2000, but would like to connect to a sql server 2016.

This is the connection string in the udl file
[oledb]
; Everything after this line is an OLE DB initstring
Provider=SQLOLEDB.1;Password=blabla;Persist Security Info=True;User ID=LVD;Initial Catalog=LVDLASER;Data Source=someserver

It works if I point to the old server.
If I change the servername, test it on a win 10 machine, it works.
On the win2000 I get this:
enter image description here

Test connection failed because of an error in initializing provider.
[DBNETLIB]ConnectionOpen (SECDoClientHandshake()).SSL Security error.

Any suggestion is very much appreciated.

Best Answer

Colin's suggestion fixed it. Installed windows installer 3.1 and found the native client 2005 somewhere and now it is ok. Works also for sql server 2019 on windows 2019.