Error using linked servers

john4242

I just tried the linked servers feature for the first time and I get the following error dialog the moment I hit "Pick from list" for linked servers in the "Additional Databases" dialog:



(The error is in German, but I guess the meaning is obvious enough.)

If I enter the linked server manually, the same error appears on the connection as a tooltip.

This is Sql Server 2016 and LinqPad 5.22.02.

JoeAlbahari

I don't understand German... is it telling you to run sp_addlinkedserver on SQL Server first? And have you tried doing that?

john4242

I did that, yes. That's why LINQPad can find the server at all (the message came before I even tried to enter the linked server's name manually).

The message says it's not finding the linked server in "sys.servers", but it does in fact show in "sys.servers" when I look at it from SSMS.

So apparently LINQPad gets the information about the linked server from somewhere other than "sys.servers" and then can't find it in there for some reason.

I use the same login credentials in both cases.

You want me to post the contents of "sys.servers"?

EDIT: Who's originating the message anyway? ADO.NET?

JoeAlbahari

This is the query that's failing:

select data_source from sys.servers where provider = 'SQLNCLI' and is_linked = 1

john4242

The statement works when I enter it in SSMS. It returns the IP address of the linked server. The credentials are the same, so I can't see why LINQPad would be failing to do that query.

DaveC

Was this issue ever taken care of? I am experiencing this issue on v5.43.000.

JoeAlbahari

Can you provide the full error message?