本文介绍了到主机本地主机,端口1433的TCP / IP连接失败的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

当我尝试通过 jdbc 连接eclipse与 sql server 时,我重复得到这2个错误。有没有人可以帮我这个或解释为什么我得到这个?

  1。到主机本地主机,端口1433的TCP / IP连接失败。 
2.驱动程序无法使用安全套接字层(SSL)加密建立与SQL Server的安全连接。

谢谢。

  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);


解决方案
 开始> Microsoft SQL Server>配置工具> SQL Server配置管理器

打开时转到

  SQL Server配置管理器> SQL Server网络配置> SQLExpress的协议

在哪里可以找到协议TCP / IP,如果禁用,启用它点击TCP / IP,您将找到其属性。



在此属性中删除所有TCP动态端口并将1433的值添加到所有TCP端口
并重新启动SQL Server服务> SQL Server



其完成...


I'm getting this 2 errors repeatedly when I'm trying to connect eclipse with sql server through jdbc. Could anyone help me with this or explain why am I 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.

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);
解决方案
You need to Go to Start > Microsoft SQL Server > Configuration Tools > SQL Server Configuration Manager

When it opens Go to

SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for SQLExpress

Where you'll find the Protocol TCP/IP, if disabled then Enable it Click on TCP/IP, You'll find its properties.

In this properties Remove All the TCP Dynamic Ports and Add value of 1433 to all TCP Portand restart your SQL Server Services > SQL Server

And Its Done...

这篇关于到主机本地主机,端口1433的TCP / IP连接失败的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-06 03:08