问题描述
我继续收到此错误。我尝试了一个来自stackoverflow的解决方案（下面），这对我来说不起作用 -
I keep on getting this error. I tried one solution from stackoverflow (below) which did not work for me -SQL Exception while connecting to SQL server
我尝试通过链接使用Windows防火墙中的端口1433，这也不起作用。
请参阅在Windows防火墙中打开TCP访问端口部分
I tried allowing port 1433 in the windows firewall by using a link, that did not work too.Refer to section "To open a port in the Windows firewall for TCP access"http://msdn.microsoft.com/en-us/library/ms175043.aspx
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP
connection to the host localhost, port 1433 has failed. Error:
"Connection refused: connect. Verify the connection properties.
Make sure that an instance of SQL Server is running on the host
and accepting TCP/IP connections at the port. Make sure that TCP
connections to the port are not blocked by a firewall.
请帮我解决这个问题。
谢谢
推荐答案
你需要去
开始> Microsoft SQL Server>配置工具> SQL Server配置管理器
当它打开转到
SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for SQLExpress
在哪里可以找到协议TCP / IP，如果禁用则启用它单击TCP / IP，您将找到其属性。
Where you'll find the Protocol TCP/IP, if disabled then Enable it Click on TCP/IP, You'll find its properties.
在此属性删除所有TCP动态端口并将值1433添加到所有TCP端口
a nd重新启动 SQL Server服务> SQL Server
完成它。
这篇关于com.microsoft.sqlserver.jdbc.SQLServerException：与主机localhost，端口1433的TCP / IP连接失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！