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

作者：菜鸟追梦旅行 | 2024-06-03 09:38:13

踩

the connection to the host 127.0.0.1, named instance mssqlserver1 failed. er

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

声明：本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：【wpsshop博客】