win7新安装sql2005，jdbc出现无法连接的错误，The TCP/IP connection to the host localhost解决方案...

The TCP/IP connection to the host localhost, port 1433 has failed. Error: Connection refused: connect. Please verify the connection properties and check that a SQL Server instance is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.

 

解决方法就是设置全局动态端口为0；

转载于:https://www.cnblogs.com/zdqbk/archive/2013/06/16/3138297.html