"[DBNETLIB][ConnectionOpen(Connect()] Sql Server does not exist or access denied"

• cr_mit06001-1129443

  SSC Enthusiast

  Points: 149

  More actions

  July 15, 2009 at 10:26 pm

  #73936

  I am in real problem I have a database server Ms Sql server 2000 standard edition on windows server 20003.We are using Local Autehentication method means when I login to system I enter the correct username and password of Admin. After this I could easily login and start Sql Server using the Enter prize manager. And Sql Server and Sql server agent were set to auto start with os. There was no need to give any further user name or password.It was all well. But suddenly one day when I tried to re login, the system displayed the message that " One of the service or driver failed during start up...." I clicked ok and when I try to connect Sql Server using Sql Server enterprise manager it gave me the message "[DBNETLIB][ConnectionOpen(Connect()] Sql Server does not exist or access denied" Waiting for your instructions....

  Regards

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  July 15, 2009 at 11:16 pm

  #1025478

  Check the error log in Windows for a reason why the service didn't start.

• Eswin

  SSCrazy Eights

  Points: 8320

  More actions

  July 16, 2009 at 1:37 am

  #1025500

  You may receive this error message when the following conditions are true:

  • SQL Server 2005 or SQL Server 2000 is installed on a cluster.

  • You are connecting to a SQL Server named instance by using TCP/IP sockets.

  • IPSec policy is enabled on the client domain.

  • IPSec policy is not enabled on the server domain.

  check these links :

  http://support.microsoft.com/kb/888228

  [url= http://forums.asp.net/t/1089665.aspx%5D

  http://forums.asp.net/t/1089665.aspx%5B/url%5D

  Tanx 😀