Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1030
  • Last Modified:

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

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.
0
IUAATech
Asked:
IUAATech
  • 2
1 Solution
 
Christopher KileCommented:
Do you get this problem when attempting to register the server in Enterprise Manager?

0
 
IUAATechAuthor 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.
0
 
assystCommented:
Try this..
  Go to --client Network utility and add Alias Name. What you need to do is - select TCP/IP and in Server Name give the IP address and in Server Alias provide any Name. Now try connecting using the Alias Name.

S
0
 
IUAATechAuthor Commented:
got it to work. Thanks assyst!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now