We help IT Professionals succeed at work.

Can't connect to SQL Server 2000 using the Server Name

IUAATech asked
Last Modified: 2008-01-09
I am trying to connect to SQL 2000 running on Windows Server 2003 from a XP machine using Enterprise Manager. Here is the problem I have:

I can connect to the database if I type in the IP address. However, if I use the server name, I get the following message:
SQL Server does not exist or access denied.

I am trying to understand what's going on here. I have the same problem when I try to create an ODBC connection.

Also, when I try to connect to the database from another server running Server 2003, it works just fine when I use either the IP or the server name.

And when I do a "ping <server_name>" from my machine, I get a reply.

I don't even know where to start looking. I am not a DB admin and I have having to do this on my own since our DB admin is lazy and doesn't want to work.
Watch Question

Christopher KileSenior Software Analyst

Do you get this problem when attempting to register the server in Enterprise Manager?


yes. I get this problem from my XP box. But I don't get this problem when I connect from a different Server 2003 box.
Unlock this solution and get a sample of our free trial.
(No credit card required)


got it to work. Thanks assyst!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.