Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: Problem connecting to SQL Server 2000

    We have installed SQL Server 2000 in our new server running on Microsoft Windows Server 2003.

    We tried to connect to the database in the Server where it is installed. We are able to connect when we give server name. We are unable to connect when we give IP Address of the server.

    We have latest SP3a of SQL Server 2000 installed.

    Could anyone help us in resolving this issue?

    Thanks in Advance.

  2. #2
    Join Date
    Aug 2002
    Ensure to use the HOSTS file or LMHOSTS, put the TCP/IP address of the SQL Server server at the start of the line followed by a few spaces followed by the machine name of the SQL Server server.

    The HOSTS or LMHOSTS file belongs in the System32\Drivers\Etc directory for client computers running Microsoft Windows NT and Microsoft Windows 2000, or in the \Windows directory for clients running Microsoft Windows ME, Microsoft Windows 98, or Microsoft Windows 95.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts