Posted by Randy Martin on 01/23/06 21:47

Hi John,

The linked server is set up for RPC=True and RPC Out=True. The Surface
Area Configuration show both Local and Remote Connections allowed over
TCP/IP. Both servers are set to accept only Shared Memory and TCP/IP
traffic, and the clients on both servers have only Shared Memory and
TCP/IP enabled.

One item I am chasing is the SPN. In doing some digging, it seems the
SPN has to be fully qualified out to the port. I need to make sure
that ours are, for both servers. A symptom I am seeing is that a
non-linked server connection shows up as NTLM, not Kerberos as
expected. This link had the details on how to discover that:
http://blogs.msdn.com/sql_protocols/archive/2005/10/12/479871.aspx.

I'll keep you posted...

• Next in forum: [ANNOUNCE] Stylus Studio Invertviews XQuery Co-Innovator Jonathan Robie
• Prev in forum: SQL Server could not configure 'Server\Instance' as a Distributor.
• Thread view: Re: Linked Server setup - SQL 2005 RTM

[Reply to this message]