The TCP/IP connection to the host localhost, port 1433 has failed

Question

I'm getting this 2 errors repeatedly when I'm trying to connect eclipse with sql server through jdbc.Can anyone help me with this or explain why am GETTING THIS??

1.The TCP/IP connection to the host localhost, port 1433 has failed .2.The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption.

Thank you..

this is the code am working on.

String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
Class.forName(driver).newInstance();
String connString ="jdbc:sqlserver://localhost:1433/databaseName=Engg_Street;instance=SQLSERVER;encrypt=true;     trustServerCertificate=true";
String username = "Vijayalakshmi";
String password = "";
conn = DriverManager.getConnection(connString,username,password);

refer to the following link http://stackoverflow.com/questions/11820799/com-microsoft-sqlserver-jdbc-sqlserverexception-the-tcp-ip-connection-to-the-ho — sunysen, Sep 24 '13 at 12:47
Is SQL Server running on port 1433, IIRC since SQL Server 2005, TCP/IP is disabled by default and if enabled it is using a randomized port by default. — Mark Rotteveel, Sep 24 '13 at 12:48
Don't post the same question multiple times, instead you should edit your existing post if you think it needs clarification! — Mark Rotteveel, Sep 24 '13 at 12:49
yes, sql server is running on port 1433 and it's enabled also.. — Navin Kumar, Sep 24 '13 at 12:54
I mean the IPALL TCP PORT IS 1433, or should we assign all other to 1433.. — Navin Kumar, Sep 24 '13 at 12:56

score 0 · Answer 1 · answered Sep 24 '13 at 16:40

0

Take the encrypt=true;trustServerCertificate=true out of your connection string. Your SQL Server probably isn't set up to use SSL for its connections.

answered Sep 24 '13 at 16:40

dpw

1,576
9
14

The TCP/IP connection to the host localhost, port 1433 has failed

1 Answers1