Problem wih sp_addlinkedserver

[dkaplan]

I am trying to read tables on an 2008 SQL server from a 2012 SQL server.

I have run sp_addlinkedserver on each server, referencing the other server.

The link appears to have been established successfully.

However, when I try to query a table on the linked server with
select * from NameOfLink.MyDB.dbo.TableName

I get the message:

Msg -2146893007, Level 16, State 1, Line 0
SSL Provider: The client and server cannot communicate, because they do not possess a common algorithm.

Suggestions?

Note: I'm not sure if this is relevant, but the 2008 server is using IIS.

 

[fredericofonseca]

check to see if on one of the servers TLS 1.0 and 1.1 is disabled - most likely this will be the case and one of the servers only has tls 1.2 enabled and the other does not.
or a similar combination

Note that this is at OS level so your network team will need to investigate and deal with the issue.



Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886