Post reply

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

  • November 2, 2009 at 1:49 am

    #212746

    when i am trying to connect to a application,it is showing the following error.ple help me on this

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

  • November 2, 2009 at 2:06 am

    #1073699

    Hi,

    This could have multiple causes

    1. try connecting to sql to ssms with your user credentials

    2. ensure the correct protocol is selected under SACM,i.e named pipes and tcp/ip

    not sure what you have tried

  • November 2, 2009 at 2:12 am

    #1073701

    shanu.hoosen (11/2/2009)

    Hi,

    This could have multiple causes

    1. try connecting to sql to ssms with your user credentials

    2. ensure the correct protocol is selected under SACM,i.e named pipes and tcp/ip

    not sure what you have tried

  • November 2, 2009 at 2:16 am

    #1073703

    shanila_minnu (11/2/2009)

    shanu.hoosen (11/2/2009)

    Hi,

    This could have multiple causes

    1. try connecting to sql to ssms with your user credentials

    2. ensure the correct protocol is selected under SACM,i.e named pipes and tcp/ip

    not sure what you have tried

    i tried connecting from front end

  • November 2, 2009 at 2:19 am

    #1073705

    your front end cannot connect to sql for some reason.

    we need to check if sql is running, if it is, then we need to check if your login is valid.

    once you have these answers, you will have some direction on the resolution.

  • November 2, 2009 at 2:32 am

    #1073711

    sql is running and login is valid

  • November 2, 2009 at 2:36 am

    #1073714

    did you check my 2nd suggestion in my initial reply?

  • November 2, 2009 at 2:38 am

    #1073716

    it is namedpipes/tcp

  • November 2, 2009 at 2:47 am

    #1073722

    try testing the ODBC connection.

    if this works, then its ur app.

    sorry thats all i got

  • November 2, 2009 at 3:01 am

    #1073728

    shanu.hoosen (11/2/2009)

    try testing the ODBC connection.

    if this works, then its ur app.

    sorry thats all i got

    how can we test ODBC connection

  • November 2, 2009 at 3:06 am

    #1073732

    start > control panel > administrative tools > data source

    u should see the connection ur app is using. double click and click the test connection button at the end of the wizard

  • November 3, 2009 at 3:32 am

    #1074197

    Hi,

    Do Post Xp_readerrorlog contents here.

Viewing 12 posts - 1 through 11 (of 11 total)

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