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:
Test connection failed because of an error in initializing provider. [DBNETLIB]ConnectionOpen (SECDoClientHandshake()).SSL Security error.
Any suggestion is very much appreciated.