Can't connect to mssql4

andyp

Guppy
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?
 
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. :)
 
andyp said:
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. :)
Lol, you are not alone, it happens to me all the time :)
 
Back
Top