开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜