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.