到主机 的 TCP/IP 连接失败解决方案

到主机 的 TCP/IP 连接失败
我在自己机子上做的项目打成的WAR包，放到别人的机子上就包错误

Java code

com.microsoft.sqlserver.jdbc.SQLServerException: 到主机  的 TCP/IP 连接失败。 java.net.ConnectException: Connection refused: connect 
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source) 
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source) 
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source) 
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source) 
 at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source) 
 at java.sql.DriverManager.getConnection(Unknown Source) 
 at java.sql.DriverManager.getConnection(Unknown Source) 
 at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110) 
 at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72) 
 at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1463) 
 at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1004) 
 at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:805) 
 at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:745) 
 at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:134) 
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1203) 
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1172) 
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:427) 
 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:249) 
 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:155) 
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:246) 
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160) 
 at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:285) 
 at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352) 
 at org.springframework.web.struts.ContextLoaderPlugIn.createWebApplicationContext(ContextLoaderPlugIn.java:354) 
 at org.springframework.web.struts.ContextLoaderPlugIn.initWebApplicationContext(ContextLoaderPlugIn.java:295) 
 at org.springframework.web.struts.ContextLoaderPlugIn.init(ContextLoaderPlugIn.java:225) 
 at org.apache.struts.action.ActionServlet.initModulePlugIns(ActionServlet.java:869) 
 at org.apache.struts.action.ActionServlet.init(ActionServlet.java:336) 
 at javax.servlet.GenericServlet.init(GenericServlet.java:212) 
 at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1161) 
 at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:981) 
 at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4042) 
 at org.apache.catalina.core.StandardContext.start(StandardContext.java:4348) 
 at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791) 
 at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771) 
 at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525) 
 at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920) 
 at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883) 
 at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)  
 
 at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138) 
 at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) 
 at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117) 
 at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) 
 at org.apache.catalina.core.StandardHost.start(StandardHost.java:719) 
 at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) 
 at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) 
 at org.apache.catalina.core.StandardService.start(StandardService.java:516) 
 at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) 
 at org.apache.catalina.startup.Catalina.start(Catalina.java:566) 
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) 
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 
 at java.lang.reflect.Method.invoke(Unknown Source) 
 at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) 
 at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)

[解决办法]
com.microsoft.sqlserver.jdbc.SQLServerException: 到主机 的 TCP/IP 连接失败。 java.net.ConnectException

你需要打开允许SQL2005远程连接
开始--->程序---->sql2005---->配置工具---->SQLServer外围应用配置--->允许远程连接


[解决办法]
<property name="connection.url">jdbc:sqlserver://localhost;databaseName=hahafanDB</property>
你这个配置的是连接自己机器的数据库，要改成你机器的IP地址
[解决办法]
总结 (枫之泪（泪洒天堂）) (锋哥) (努力学习java) (王老么) 的回答
我感觉就得从这几个方面去检查：
1.是否打开SQL2005远程连接。 
2.别人机子上有哪个数据库。
3.配置连接机器的数据库IP地址。
应该能找出问题。
[解决办法]

探讨

不是 我把我的war包放到别的机子上了，不涉及远程访问
也就是说 我把 在A机子上的放到B机子运行

[解决办法]
看连接数据库的端口是不是一样的
[解决办法]
别人机子上的SQL数据库 tcp/ip启动了吗
[解决办法]
端口号的问题
看SQLserver的端口号
再把连接的端口号改成它

查看更多 下一篇