[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket 解决方法

昨天经理让我调查一个问题，在客户那装的SQL2000重新安装后联不上了，一开始数据驱动总抱错误[Microsoft][SQLServer 2000 Driver for JDBC]？？？？？？？？，不知道什么意思，就不断的想出现这种错误的原因，在网上查了一会，别人总结了三个原因：

1、服务器正常启动检查是不是使用1433端口
2、查看防火墙是不是屏蔽1433端口了
3、CMD-NETSTAT-AN检查下你的1433端口是不是开启没有的话打SQLSERVER的丁SP3ORSP4基本都是补丁问题
于是我们就想到是不是TCP/IP协议没开，可是看数据服务器，开了！因为在本地可以通过查询器连上数据库，所以我们想是不是要把补丁打到SP4，可是打了SP4后还是解决不了.......怎么回事呢？

这时想着死马当活马医吧，就在网上下了一个SQLServer 2000 Driver JDBC for SP3 的数据库驱动，还是没连上，可是错误变清晰了，成了

[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset

at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)

at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)

at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)

at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)

at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:582)

at java.sql.DriverManager.getConnection(DriverManager.java:185)

at s2jsp.lg.dao.impl.BaseDao.getConn(BaseDao.java:24)

at s2jsp.lg.dao.impl.TopicDaoImpl.findListTopic(TopicDaoImpl.java:101)

at org.apache.jsp.index_jsp._jspService(index_jsp.java:128)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)

at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)

at java.lang.Thread.run(Thread.java:619)

这下知道了，端口问题！

于是就在网上查，看见了不少解决方法可是没什么用......

自己在机子上运行cmd netstat -abn 然后找到SQLServer所使用的端口，是1433没错！

问题真来了，后来经理发现原来服务器端的端口是1443，这下所有问题都解决了，我们把服务器端也改为1433，OK！
运行了cmd telnet 127.0.0.1 1433 OK！

感谢经理，又学到一个新东西！