Post reply

Sql Connectivity Issue.

  • November 24, 2008 at 11:45 pm

    #96728

    Hi all,

    I have developed an application which uses the system dsn for connection to sql server database. The application works fine when the user logges on using the admin loggin and pwd. But if the user loggins thrg his own user id and pwd, then the connection error occurs.

    Please any one can help with the connection string. Thanks in advance.

  • November 25, 2008 at 12:55 am

    #902954

    Hi,

    You didn't give us a lot of details regarding

    - are you using SQL Server or Windows Authentication?

    - what is the error message?

    - if you run Profiler on the SQL Server, can you see the (failed) connections coming in?

    Are you sure it is a connection string problem and not a permission problem? Can they log in via let's say SQL Server Management Studio?

    http://www.connectionstrings.com contains all different kind of connection strings for different authentication models.

    HTH

    /Elisabeth

    elisabeth@sqlserverland.com
    MCITP | MCT
    http://sqlblog.com/blogs/elisabeth_redei/
    http://linkedin.com/in/elisabethredei

  • November 25, 2008 at 1:00 am

    #902957

    sushanth11 (11/24/2008)

    Hi all,

    I have developed an application which uses the system dsn for connection to sql server database. The application works fine when the user logges on using the admin loggin and pwd. But if the user loggins thrg his own user id and pwd, then the connection error occurs.

    Please any one can help with the connection string. Thanks in advance.

    post the error message and also check the auth. modes of sql server.

  • December 1, 2008 at 4:38 am

    #905484

    The message box showed the following error:

    Connection failed:

    SQL State: '01000'

    SQL Server Error: 53

    [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnetcionOpen(Connect())

    Connection failed:

    SQL State: '08001'

    SQL Server Error: 17

    [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL server does not exist or access denied.

    Note, I am using the windows authentication.

    Thank you..

  • December 1, 2008 at 11:34 am

    #905810

    Hi,

    This blog from the MS SQL Server Protocols team contains a step by step for troubleshooting the problem you are having:

    http://blogs.msdn.com/sql_protocols/archive/2005/10/29/486861.aspx

    /Elisabeth

    elisabeth@sqlserverland.com
    MCITP | MCT
    http://sqlblog.com/blogs/elisabeth_redei/
    http://linkedin.com/in/elisabethredei

Viewing 5 posts - 1 through 5 (of 5 total)

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