Post reply

Connection Failed Issue

  • July 9, 2012 at 8:18 am

    #100484

    Hi All,

    I have SQL 2005. I have an access front end and SQL backend. I need users to test the database I am working on. I gave the permissions to access the database. Now, I am trying connect but I am getting this error,

    have check all these possibilities allows remote connection, sql server browser service is running on the server, TCP/IP protocol is enabled but still got same issue.

    Connection Failed:

    SQLSTATE: '01000'

    SQL Server Error: 233

    [Microsoft] [ODBC SQL server driver][DBNETLIB]Connection open (PreLoginHandshake())

    Connection failed:

    SQLState: '08001'

    SQL Server error: 11

    [Microsoft] [ODBC SQL server driver][DBNETLIB]General Network error. Chcek your network documentation.

    Thanks in Advance

    Krishna...

  • July 9, 2012 at 3:06 pm

    #1510606

    Have you tried the following:

    MSSQLSERVER_233

    Joie Andrew
    "Since 1982"

  • July 9, 2012 at 3:09 pm

    #1510610

    Are you able to connect through SSMS from your workstation and from the server itself?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • July 10, 2012 at 2:43 am

    #1510740

    Thank you for your reply. I have tried that as well but still no use....

    Thank you

  • July 10, 2012 at 2:44 am

    #1510741

    Thank you for your reply. My self I can connect to DB through SSMS.....

    Thanks.

  • July 10, 2012 at 10:25 am

    #1511080

    Check the connection string that you are using within the application (Access).

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • July 11, 2012 at 3:16 am

    #1511406

    Have test the Connesction String and its working fine.

    Thank you

  • July 11, 2012 at 6:23 am

    #1511483

    krishnaprasad14 (7/11/2012)

    Have test the Connesction String and its working fine.

    Thank you

    Run below command from a command prompt on the server hosting the application.

    telnet <SQL Server IP> <SQL Server Port Number>

    If you get any error then it is a firewall issue & contact your firewall administrator to allow this particular port.

    Sujeet Singh

Viewing 8 posts - 1 through 7 (of 7 total)

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