SQL Server Performance Forum – Threads Archive
Linked Server Problems from SQL2005When 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.
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided Ã¯Â¿Â½AS ISÃ¯Â¿Â½ with no rights for the sake of knowledge sharing.