Post reply

SQL Server Does Not Exist or Access Denied

  • August 8, 2007 at 7:35 am

    #62610

    Hi,

    I'm running SQL Server 2000 on Windows Server 2003.  I have a user pc that cannot connect to SQL Server.  All services are running, a username and password have been set up in SQL Server, and I am able to ping the server from the user machine.  I am also able to log onto the server from other user machines using the same SQL username and password.  Yet I receive the 'SQL Server Does Not Exist or Access Denied.  Connection.Open' ERROR.  Does anybody know what I'm forgetting?  Any ideas would be appreciated.

    thanks.

    bc

  • August 8, 2007 at 7:47 am

    #725433

    It is most likely a problem on your own machine. Check your ODBC connection.

  • August 8, 2007 at 7:53 am

    #725437

    ODBC looks fine.  It's weird .. because I can connect to other servers.

  • August 8, 2007 at 8:30 am

    #725452

    Hi,

    Are you pinging the server by IP address or by FQDN?  If you can't ping by FQDN there could be a problem with DNS.

    Cath

  • August 8, 2007 at 9:54 am

    #725479

    I am pinging by FQDN...

  • August 8, 2007 at 12:12 pm

    #725507

    Is the SQL Server Clustered and behind a FireWall ? A firewall may be in effect is a Virtual Private Network is being used for connectivity.

    SYMPTOMS

    If you try to connect a clustered named instance of SQL Server through a firewall, and you use only the instance name (for example, SQL_Virtual_Name\Instance_Name) in the connection string, the connection fails.

    WORKAROUND

    Connect using a TCP IP and port number such as 10.218.122.161,1871

    Bug description at http://support.microsoft.com/default.aspx?scid=kb;%5bLN%5d;318432

    SQL = Scarcely Qualifies as a Language

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply