数据库连接问题?

Question

请问一下这个错误出错在那里..type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:846)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.index_jsp._jspService(index_jsp.java:94)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(DriverManager.java:525)
java.sql.DriverManager.getConnection(DriverManager.java:171)
org.apache.jsp.index_jsp._jspService(index_jsp.java:70)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.30 logs.
--------------------------------------------------------------------------------Apache Tomcat/5.0.30

Answer 1

你在命令行模式下
输入NETSTAT -NA
看1433端口打开没`~

Answer 2

如果没开
看看你的SQL SERVER SP4装了没有

Answer 3

Proto  Local Address          Foreign Address        State
TCP    ZM-CSY:epmap           ZM-CSY:0               LISTENIN
TCP    ZM-CSY:microsoft-ds    ZM-CSY:0               LISTENIN
TCP    ZM-CSY:1026            ZM-CSY:0               LISTENIN
TCP    ZM-CSY:7025            ZM-CSY:0               LISTENIN
TCP    ZM-CSY:7080            ZM-CSY:0               LISTENIN
TCP    ZM-CSY:7110            ZM-CSY:0               LISTENIN
TCP    ZM-CSY:netbios-ssn     ZM-CSY:0               LISTENIN
TCP    ZM-CSY:1140            61.186.252.136:http    TIME_WAI
TCP    ZM-CSY:1152            211.100.23.249:http    TIME_WAI
TCP    ZM-CSY:1159            210.192.102.75:http    TIME_WAI
TCP    ZM-CSY:1188            61.186.252.136:http    TIME_WAI
TCP    ZM-CSY:1200            61.186.252.136:http    TIME_WAI
TCP    ZM-CSY:1203            61.186.252.136:http    TIME_WAI
TCP    ZM-CSY:1204            61.186.252.136:http    TIME_WAI
UDP    ZM-CSY:microsoft-ds    *:*
UDP    ZM-CSY:isakmp          *:*
UDP    ZM-CSY:1025            *:*
UDP    ZM-CSY:1032            *:*
UDP    ZM-CSY:2126            *:*
UDP    ZM-CSY:2130            *:*
UDP    ZM-CSY:2361            *:*
UDP    ZM-CSY:2418            *:*
UDP    ZM-CSY:2420            *:*
UDP    ZM-CSY:2425            *:*
UDP    ZM-CSY:2428            *:*
UDP    ZM-CSY:2755            *:*
UDP    ZM-CSY:3086            *:*
UDP    ZM-CSY:4000            *:*
UDP    ZM-CSY:4001            *:*
UDP    ZM-CSY:4382            *:*
UDP    ZM-CSY:4500            *:*
UDP    ZM-CSY:6000            *:*
UDP    ZM-CSY:6001            *:*
UDP    ZM-CSY:6002            *:*
UDP    ZM-CSY:6003            *:*
UDP    ZM-CSY:6004            *:*
UDP    ZM-CSY:6005            *:*
UDP    ZM-CSY:6006            *:*
UDP    ZM-CSY:6007            *:*
UDP    ZM-CSY:6008            *:*
UDP    ZM-CSY:6009            *:*
UDP    ZM-CSY:6010            *:*
UDP    ZM-CSY:6011            *:*
UDP    ZM-CSY:6012            *:*
UDP    ZM-CSY:6013            *:*
UDP    ZM-CSY:6014            *:*
UDP    ZM-CSY:6015            *:*
UDP    ZM-CSY:6016            *:*
UDP    ZM-CSY:6017            *:*
UDP    ZM-CSY:6018            *:*
UDP    ZM-CSY:6019            *:*
UDP    ZM-CSY:6020            *:*
UDP    ZM-CSY:6021            *:*
UDP    ZM-CSY:6022            *:*
UDP    ZM-CSY:ntp             *:*
UDP    ZM-CSY:1865            *:*
UDP    ZM-CSY:1870            *:*
UDP    ZM-CSY:1900            *:*
UDP    ZM-CSY:2811            *:*
UDP    ZM-CSY:3087            *:*
UDP    ZM-CSY:ntp             *:*
UDP    ZM-CSY:netbios-ns      *:*
UDP    ZM-CSY:netbios-dgm     *:*
UDP    ZM-CSY:1900            *:*