3

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

Yeodave
  • 145

1 Answers1

3

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

Mike Walsh
  • 437