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.".
目录
(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