SQL - Connect to Linked Server with Named Instance

Question

How do I connect to a named instance of a linked SQL server.

If its not linked, I would do the following:

ServerName.DatabaseName.dbo.TableName

If it is linked, I would assume the following:

ServerName\InstanceName.DatabaseName.dbo.TableName

but SQL doesn't like the "\"

What is the correct syntax

score 13 · Accepted Answer · edited May 23 '17 at 12:06

13

Check this

You can surround server name with brackets

edited May 23 '17 at 12:06

Community

answered Apr 27 '09 at 15:39

score 2 · Answer 2 · edited Jul 05 '12 at 11:31

2

the correct syntax is [ServerName\InstanceName].DatabaseName.dbo.TableName.

edited Jul 05 '12 at 11:31

Taryn

answered Jan 29 '10 at 15:48

Martin Kafka

2

I get this: "Could not find server 'ServerName\InstanceName' in sysservers. Execute sp_addlinkedserver to add the server to sysservers". – tjmoore Jul 30 '12 at 09:00

score 1 · Answer 3 · answered Nov 01 '11 at 20:14

If you are using the default instance, you don't need to specify the instance name.

Example using the default instance: [MyServer].[MyDatabase].[MySchema].[MyTable]

NB: If you don't know your schema name, give [dbo] a try, since that is the default schema.

So something like this should work for you

SELECT *
FROM [MyTable] t
INNER JOIN [MyLinkedServer].[MyLinkedDatabase].[MyLinkedSchema].[MyLinkedTable] lt ON lt.Id = t.Id

3 Answers3