SQL 2005 Error connecting to SQL2000

  • Thread starter Thread starter Ant
  • Start date Start date
A

Ant

Hi,
I'm connecting to an SQL2000 Server, it runs a very slow SP that takes
around two minutes. I've set the command & connection timeout to handle this.
It used to work fine but now I get a seemingly unrelated error. I can connect
remotely to do simple queries & LINQ queries but the SP doesn't run.

Any ideas would be gratefully appreciated

Below is the error message:

"An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to
SQL Server)"
 
A couple of things I can think of immediately:

1. Someone has shut off a protocol that you are using (no matching protocol
between servers)
2. You have removed the default instance and are trying to hit a named
instance via Shared Memory
(http://support.microsoft.com/kb/926929/en-us)

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://gregorybeamer.spaces.live.com/lists/feed.rss

or just read it:
http://gregorybeamer.spaces.live.com/

*************************************************
| Think outside the box!
|
*************************************************
 
Back
Top