好久没有弄java，玩eclipse了，最近因为小小的原因，参加一个比赛，不得不把javaweb的东西又捡起来，所以不熟悉，再加上之前链接数据库都是用Oracle的，现在公司的电脑上又只是安装了sqlserver 2008R2，所以就试着，开发项目链接sqlserver 2008R2。从昨天晚，到今天晚，终于算是搞定了一系列的问题，当页面显示出来的一刹那，好开心。人生就像打怪兽，就得一关一关地过。仅此，记录一下，辛苦的这些岁月，这活在当下的大好青春。
01 五月 28, 2014 9:21:02 下午 com.microsoft.sqlserver.jdbc.SQLServerConnection Prelogin
02 警告: ConnectionID:1 ClientConnectionId: 10c92eac-e4c6-48d1-ba33-b50911fd4368 Prelogin error: host localhost port 8080 Unexpected end of prelogin response after 0 bytes read
03 com.microsoft.sqlserver.jdbc.SQLServerException: 通过端口 8080 连接到主机 localhost 的 TCP/IP 连接失败。错误:“驱动程序收到意外的登录前响应。请验证连接属性，并检查 SQL Server 的实例正在主机上运行，且在此端口接受 TCP/IP 连接。该驱动程序只能与 SQL Server 2000 或更高版本一起使用。”。 ClientConnectionId:10c92eac-e4c6-48d1-ba33-b50911fd4368
04 at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1667)
05 at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1654)
06 at com.microsoft.sqlserver.jdbc.SQLServerConnection.Prelogin(SQLServerConnection.java:1442)
07 at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1319)
08 at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
09 at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
10 at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
11 at java.sql.DriverManager.getConnection(Unknown Source)
12 at java.sql.DriverManager.getConnection(Unknown Source)
13 at com.news.util.DbUtil.getcon(DbUtil.java:18)
14 at com.news.daoImpl.TopicDaoImpl.displayTopic(TopicDaoImpl.java:17)
15 at org.apache.jsp.index_jsp._jspService(index_jsp.java:147)
16 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
17 at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
18 at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
19 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
20 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
21 at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
22 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
23 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
24 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
25 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
26 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
27 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
28 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
29 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
30 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
31 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
32 at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
33 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
34 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
35 at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
36 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
37 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
38 at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
39 at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
40 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
41 at java.lang.Thread.run(Unknown Source)
查看了080端口，没看太明白，应该怎么解决？
8080是项目访问服务器的端口 不是数据库访问的端口 端口号改为1433后 报错
01 com.microsoft.sqlserver.jdbc.SQLServerException: 通过端口 1433 连接到主机 localhost 的 TCP/IP 连接失败。错误:“Connection refused: connect。请验证连接属性。确保 SQL Server 的实例正在主机上运行，且在此端口接受 TCP/IP 连接，还要确保防火墙没有阻止到此端口的 TCP 连接。”。
02 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
03 at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:241)
04 at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2243)
05 at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:491)
06 at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1309)
07 at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
08 at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
09 at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
10 at java.sql.DriverManager.getConnection(Unknown Source)
11 at java.sql.DriverManager.getConnection(Unknown Source)
12 at com.news.util.DbUtil.getcon(DbUtil.java:18)
13 at com.news.daoImpl.TopicDaoImpl.displayTopic(TopicDaoImpl.java:17)
14 at org.apache.jsp.index_jsp._jspService(index_jsp.java:147)
15 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
16 at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
17 at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
18 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
19 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
20 at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
21 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
22 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
23 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
24 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
25 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
26 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
27 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
28 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
29 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
30 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
31 at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
32 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
33 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
34 at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
35 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
36 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
37 at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
38 at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
39 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
40 at java.lang.Thread.run(Unknown Source)
解决方法:从“开始”里的“所有程序” 里打开 “microsoft sqlserver 2008R2 ”的 SQL Server Configuration Manager(配置管理)，然后下图中启用TCP/IP协议。
接着，重启数据库服务：电脑-管理-服务和应用--启动数据库服务
