I Have a problemn. I cant configure Linked server to other sql server. I received the following error?
A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.) (.Net SqlClient Data Provider)
Windows server 2003 R2 Standandard SQL Server 2008 Standandard
I believe that is a imcopatibility between SQL 2008 and Windows 2003 R2.
Can anyone help me??
No, it means you're trying to connect using the Shared Memory Provider which is probably not possible unless you're trying to connect to a different instance on the same machine. Check your set up. You probably need to enable, on a guess, TCPIP to get the right connection.
answered Aug 04 '10 at 11:59 AM
Grant Fritchey ♦♦
A workaround is probably to go with TCP/IP as Grant says, but I don't believe you are actually doing anything wrong - I think you've stumbled across a bug. One suggestion I would have is to check the event log on the server to check for any events being logged at the same time as your error.
As an aside, I stumbled across this KB article while digging for info, which has the most scary list of possible side-effects for an ALTER TABLE statement - ever! : http://support.microsoft.com/kb/916780
answered Aug 04 '10 at 01:24 PM
Matt Whitfield ♦♦