Hi,
I 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 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!
EDIT
I'm able to connect using named pipes, not TCP/IP although everything indicates that TCP/IP is enabled