SQL Server Performance Forum – Threads Archive

Linked Server Problems from SQL2005

When I run linked server queries from SQL2005 it fails. Query Example :
SELECT * FROM [servername].master.dbo.sysobjects Error:
OLE DB provider "SQLNCLI" for linked server " servername" returned message "Communication link failure".
Msg 10054, Level 16, State 1, Line 0
TCP Provider: An existing connection was forcibly closed by the remote host.
Msg 18452, Level 14, State 1, Line 0
Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection. Notes:
The linked server is configured to use the current logins security context. It does not matter whether I connect to SQL2000 or SQL2005. I have a case with MS (6 hours on the phone yesterday), but no help yet. All spn settings are as recommended by Microsoft. The MS engineer states that SQL is not passing the login as indicated in a capture file from netcap. Any help is appreciated. Terry

---

Check this linkhttp://www.aspfaq.com/show.asp?id=2544 is any help to you.
Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.

---

]]>