Question

SQL 连接提示：Connection reset

我用Myeclipse做web项目连接sql server2008本机的数据库，一直连接不上提示com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset
然后我连远程服务器的数据库OK，没有问题！自己的本机的数据库第一次可以连上，可是当页面一刷新就有出现上面的错误了！具体错误信息如下：
com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSChannel.read(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.Prelogin(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(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at DB.DB.getConn(DB.java:15)
at Student.StudentOprate.SelectAll1(StudentOprate.java:44)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:71)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:384)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:228)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
数据库连接为：
public static Connection getConn() throws InstantiationException, IllegalAccessException {
Connection conn = null;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
//String url="jdbc:sqlserver://10.3.37.3:1433;DataBaseName=HQUStudentsData";
String url="jdbc:sqlserver://localhost:1434;DataBaseName=StudentDateSource";
conn= DriverManager.getConnection(url,"sa","wenwen");
//conn= DriverManager.getConnection(url,"PublicDev","654321");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}

return conn;
}

Answer 1

运行--cmd-- netstat -a -n，看一下1433端口是否打开
未打开的原因如下：
1sqlserver2000打sp4补丁
2 sql服务器没开

Answer 2

先屏蔽一下你的杀毒软件试试。如果不行，先保存好资料，请重装一下系统

Answer 3

Connection reset

应该是网络中断