上个项目.NET连接SqlServer没有问题，这个项目Java连接SqlServer连接不上，并没有修改SqlServer什么数据，找了许久才找到答案。。。

先上错误：

com.yfapp.platform.dao.template.DbUtilsTemplate[2014-07-01 10:20:25,926] ERROR- Error occured while attempting to query dataorg.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (通过端口 1433 连接到主机 localhost 的 TCP/IP 连接失败。错误:“Connection refused: connect。请验证连接属性，并检查 SQL Server 的实例正在主机上运行，且在此端口接受 TCP/IP 连接，还要确保防火墙没有阻止到此端口的 TCP 连接。”。)	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)	at org.apache.commons.dbutils.AbstractQueryRunner.prepareConnection(AbstractQueryRunner.java:175)	at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:304)	at com.yfapp.platform.dao.template.DbUtilsTemplate.queryForList(DbUtilsTemplate.java:185)	at com.yfapp.platform.listener.PushListener.contextInitialized(PushListener.java:37)	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4961)	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5455)	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:634)	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1230)	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1876)	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)	at java.util.concurrent.FutureTask.run(FutureTask.java:262)	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)	at java.lang.Thread.run(Thread.java:745)Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 通过端口 1433 连接到主机 localhost 的 TCP/IP 连接失败。错误:“Connection refused: connect。请验证连接属性，并检查 SQL Server 的实例正在主机上运行，且在此端口接受 TCP/IP 连接，还要确保防火墙没有阻止到此端口的 TCP 连接。”。	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:170)	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1049)	at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:833)	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:716)	at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:841)	at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)	at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)	... 19 more

最后经过才知道原来是SqlServer TCP/IP协议的IPALL的TCP端口没有设置