Can't connect to mssql4

Discussion in 'Database Support' started by andyp, Jul 22, 2003.

  1. andyp

    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?
  2. Yash

    Yash Bass

    My knowledge with Enterprise Manager is limited. Are you behind a firewall or proxy server?
  3. andyp

    andyp Guppy

    No, I have a direct connection. I will play with client tools' configuration and will let you know the result.
  4. andyp

    andyp Guppy

    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. :)
  5. StPatrick

    StPatrick Perch

    Lol, you are not alone, it happens to me all the time :)

Share This Page

JodoHost - 26,000 hosting end-users in 100 countries
Plesk Web Hosting
VPS Hosting
H-Sphere Web Hosting
Other Services