Search code examples
sql-serverlinked-servernamed-instance

SQL - Connect to Linked Server with Named Instance


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


Solution

  • Check this

    You can surround server name with brackets