解决DBeaver连接SQL Server报TCP/IP失败问题

解决DBeaver连接SQL Server报TCP/IP失败问题

ZKEASOFT November 25, 2023


DBeaver连接SQL Server连接不上,提示下面这个错误,要如何解决呢?

The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused: 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.".

开启SQL Server的TIP/IP协议

打开计算机管理

然后找到SQL Server的协议,右键启用TCP/IP:

最后重启SQL Server服务就可以了。


微信公众号