Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006

    Unanswered: SQL Server does not exist or access denied

    Am trying to connect to the server through Enterprise Manager. Server is Window2000 using SQL 7.0.

    It was working prior to the network people moving the server to a different subnet or segment on the network.

    I am able to ping to it and am able to map a drive to the server but not able to register through Enterprise Manager. The services are running.

    Any help would greatly be appreciated.

  2. #2
    Join Date
    Oct 2003
    First, log onto the database server and open Enterprise Manager. Under Tools, Options, change the login timeout to something greater than 4. Change it to 30 or more. Often times when the connection settings are valid, the initial connection can take longer than 4 seconds.

    Try to connect again from your machine to the DB server using EM.

    If it still doesn't work, find out some details about the server you are trying to connect to. What are the required client settings? TCP/IP or Named Pipes? If TCP/IP, is it listening on port 1433 or a different port? Are there multiple instances and are you connecting the right one?

    See if you can connect to the DB using telnet on the right port, like 'telnet 1433'.

    This is a good place to start. Let me know if it worked out for you.

Posting Permissions

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