SQL Server does not exist

• PADMAPRIYA3.G

  SSC Rookie

  Points: 45

  More actions

  November 17, 2008 at 4:02 am

  #193865

  Hi,

  I have a process which runs every morning in a system, that picks up data from a server. But for the past two days, I find this error "[DBNETLIB][Connection Open()).]SQL Server does not exist or access denied" when the code attempts to open the connection. I run a VB application...

  The application is running quiet successfully for few years. But suddenly now this error has popped up.

  I tried running the application from a different PC, to the same server, and it works fine. After googling I found it could be due to the versioning problem of DBNet.dll, but still i found the dlls in both the PCs are of the same version..

  COuld anyone help me please?

• John H Marsh

  SSChampion

  Points: 11671

  More actions

  November 17, 2008 at 4:57 am

  #899247

  Hello,

  The main question is what has changed since the time that the Application used to work?

  If you don’t know then there are a few things to check:-

  1) Is there a Firewall in between?

  2) What protocol is the Application using e.g. TCP/IP?

  3) Can you manually connect to the Server from the PC? With the Application's Credentials? With an Admin Sign-on?

  4) Do you get an error code along with the error message?

  Regards,

  John Marsh

  www.sql.lu
  SQL Server Luxembourg User Group

• Linda-272642

  Ten Centuries

  Points: 1100

  More actions

  January 2, 2009 at 10:49 am

  #920438

  have you rebooted the server recently?

• Matt Miller (4)

  SSC Guru

  Points: 124210

  More actions

  January 2, 2009 at 11:22 am

  #920454

  make sure both PC's are using the same client protocols (under SQL Server configuration Manager).

  Also - is the SQL browser running?

  ----------------------------------------------------------------------------------
  Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?