Loading

The TCP/IP connection to the host 127.0.0.1, port 1433 has failed. Error: “Connection timed out: no

Failed to obtain JDBC Connection; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host 127.0.0.1, port 1433 has failed. Error: "Connection timed out: no further information.. 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.".

目录

 (1)打开SQL Server 2019配置管理器

 ​(2)将TCP/IP禁用状态改为已启用状态​

 (3)重启SQL Server(MSSQLSERVER)服务


(1)打开SQL Server 2019配置管理器

位置:开始–>Microsoct SQL Server 2019–>SQL Server 2019配置管理器

如果你不是用的2019版本,找到与自己安装的版本号相同的即可。

(2)将TCP/IP禁用状态改为已启用状态

sqlServer默认端口是1433,没有特别要求可以不用修改端口号。 

 

 (3)重启SQL Server(MSSQLSERVER)服务

首先通过cmd输入命令services.msc

 

 

posted @ 2022-03-28 18:28  Roc-xb  阅读(104)  评论(0编辑  收藏  举报

易微帮源码


易微帮官网