We help IT Professionals succeed at work.

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

IUAATech
IUAATech asked
on
1,061 Views
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.
Comment
Watch Question

Christopher KileSenior Software Analyst
CERTIFIED EXPERT

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

Author

Commented:
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.
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
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.

OR

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.