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

Posted on 2007-10-03
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.
Question by:IUAATech
    LVL 23

    Expert Comment

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


    Author Comment

    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.
    LVL 7

    Accepted Solution

    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.


    Author Comment

    got it to work. Thanks assyst!

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
    Viewers will learn how the fundamental information of how to create a table.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now