Error "No process is on the other end of the pipe"
I've just re-installed sql server 2005 on one of our testing servers (w2k3) after a fatal failure. After finishing with the installation I'm trying开发者_如何学Python to access remotely the server through sql management studio.
I'm getting
"The client was unable to establish a connection because an error during (etc, etc, etc).... No process is on the other end of the pipe"
I went ahead and using surface area configuration I selected "Using both TCP/IP and named pipes" on the server
After doing this the error changed to
"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding"
The remote connections area enabled, not sure what else to check. Could you help me to troobleshoot?
Thanks!
1) You might explicitly use "np:"prefix which ask for connect through named pipe and specify FQDN/LoopbackIP/IPAddress as server name in the connection string.
2) You might use FQDN/IPAddress/LoopbackIP to connect to the server.
To resolve 1) and 2), you can specify instead of FQDN/IPADress/LoopbackIP.
Taken from here.
精彩评论