1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

error: SQL Server does not exist or access denied

Discussion in 'C#' started by omerlevy, Nov 18, 2012.

  1. #1
    Hi.
    i run a classic asp app.

    connecting to sql server with:

    g_objconn.Open "Provider=SQLOLEDB;Server=myServerName;Database=myDBName;Uid=myIdName;Pwd=password"everything was just fine untill few days ago.im not sure if it started because Traffic increase. anyways, i started to get this error: Microsoft OLE DB Provider for SQL Server error '80004005'
    [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

    ill appreciate some help.
    thanks !
    SEMrush
     
    omerlevy, Nov 18, 2012 IP
    SEMrush
  2. demonicBeat

    demonicBeat Well-Known Member

    Messages:
    178
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    110
    #2
    How much for this task?
     
    demonicBeat, Nov 18, 2012 IP
  3. mambug

    mambug Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    1 of 2 possible scenarios here:

    1) You (or someone else) changes your login credentials to the SQL server. To verify, try to log into the SQL server using the credentials you use in your website. 2
    2) Your SQL server no longer exists or the name has been changed.

    Assuming you've made NO changes, scenario 1 is most likely the culprit: somebody changes the server's SQL password.
     
    mambug, Nov 19, 2012 IP
  4. TayyabRazaq

    TayyabRazaq Peon

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Either the connection string is not good or you (or some one else ) has changed the db name
     
    TayyabRazaq, Dec 10, 2012 IP
  5. funkseo

    funkseo Greenhorn

    Messages:
    23
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #5
    it may be a firewall issue or something disabled sql server remote access
     
    funkseo, Mar 11, 2013 IP
  6. Jacksons84

    Jacksons84 Member

    Messages:
    26
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    26
    #6
    Cause #
    Integrated security is enabling in the SQL Enterprise Manager and Microsoft Windows NT account that is being used or may be not mapped in SQL Account
    The User ID in the connection String is invalid
    Resolve #


    Right Click the SQL Server name that appears in the Server Manager window and Click the Properties then Click Security Options and then Click Standard and Windows so the Password option is disable for that Project.
     
    Jacksons84, Apr 23, 2013 IP
  7. annaharris

    annaharris Active Member

    Messages:
    119
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    51
    #7
    May be your connection string is falsely built. Check it once again.
     
    annaharris, Apr 30, 2013 IP