none
jdbc connect to sql server. The TCP/IP connection to the host localhost, port 1433 has failed.

    Question


  • I read over com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed and tried the answer before I ask my question. However,still fail to connect sql server.

    • java connect to local ms sql server (not express edition)....at the end of the project,I'll switch to Azure Cloud db
    • I turn-off firewall already
    • I have check setting via SQL Server Configuration Manager.

    Following is the error message,code to test connect local sql server db and screenshot for SQL Server Configuration Manager

    Hope someone advice.Thanks

    The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused: connect. 
    Verify the connection properties, check that an instance of SQL Server is running on the host and accepting
    TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".


    • Edited by ocibala Tuesday, April 01, 2014 8:10 AM correction of spelling
    Tuesday, April 01, 2014 8:06 AM

Answers