Home / server / Questions / 327797
Accepted
Yeodave
Asked: 2011-11-05 05:34:43 +0800 CST

Error when connecting to Named Instance as a Linked Server

  • 772

I have a MS SQL2008 server running a root instance and a named instances.

SQL001\.

SQL001\Pilgrim

When I connected to SQL001\Pilgrim I can set-up a link to the default instance SQL001\. no problem, but when I connect to the Default Instance SQL001\. and try to add a link to the named instance SLQ001\Pilgrim I get the error below.

This was working before I rebooted the server nearly a month ago but all services are running. I have tried restarting them.

The server in Windows 2008 R2 64bit and MSSQL is 2008. I am using Microsoft SQL Server Management Studio on the server itself and the firewall is off.

The web applications and clients that use both instances are working perfectly.

SQL Error: Encryption not supported on the client

sql-server-2008 linked-server multiple-instances

1 Answers

  1. Best Answer

    I would start out by verifying:

    A.) Ensure Named Pipes and TCP/IP are both enabled for the named instance. (SQL Server Configuration Manager --> Server Network Config --> Protocols --> Verify TCP/IP, Named Pipes are enabled

    B.) SQL Server Browser service is enabled and running

    • 3