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)"
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)"