I created a new MS SQL DB (it says it’s on mssql4) and I can’t connect to it with Enterprise Manager or Query Analyzer. They say “SQL Server does not exist or access denied”. Tried to put IP instead of the hostname as Yash suggested - all the same. I doublechecked the login/password so I’m sure they are entered correctly. Any ideas?
My knowledge with Enterprise Manager is limited. Are you behind a firewall or proxy server?
No, I have a direct connection. I will play with client tools’ configuration and will let you know the result.
Argh! Stupid me! I did not check the protocol - I was trying to connect with Named pipes instead of TCP/IP. Changed it to TCP/IP - now it’s OK. 
[QUOTE=andyp]
Argh! Stupid me! I did not check the protocol - I was trying to connect with Named pipes instead of TCP/IP. Changed it to TCP/IP - now it’s OK.
[/QUOTE]
Lol, you are not alone, it happens to me all the time