Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2007
    Posts
    2

    Unanswered: SHowing Errror [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or ac

    Hi frens

    one of my site with the Databse workd fine while the other with the same database shows the following error:

    Microsoft OLE DB Provider for SQL Server error '80004005'

    [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

    /Connection.asp, line 6

  2. #2
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    this could be lots of things. your connection string could be wrong. this happened to me this morning on a development server because something is wrong with the domain account that runs the sql server service.

    what happens when you rty to connect through the QA or SSMS with the same credentials.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  3. #3
    Join Date
    Oct 2007
    Posts
    2
    Dear Thrasymachus,

    I am using classical asp with both of my sites

    when i use it with Enterprise Manager then the connection gets established easily

    i am putting my connection.asp code here. this code works fine with my one site,whereas it gives this error with another.


    Dim Objconn

    set Objconn=Server.CreateObject("Adodb.Connection")

    ObjConn.Open "Provider=SQLOLEDB.1;Password=xxxx;User ID=xxxx;Initial Catalog=xxxx;Data Source=213.171.197.34"



    THis is my connection.asp file code which in futher is used thruout the application

  4. #4
    Join Date
    Mar 2010
    Posts
    1
    i have the same problem, code works in all systems, but not my Win7 IIS7.5 (and i normally connect to sqlserver with asp.net pages.

Posting Permissions

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