Reply to Re: Linked Server setup - SQL 2005 RTM

Your name:

Reply:


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...

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация