帮忙看看我这个登陆问题~~~

Question

我下载了《JSP数据库系统开发案例精选》里面的代码，想学习一下，但是登陆报错，这个是什么错误？？HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: net.sf.hibernate.JDBCException: Cannot open connection
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:516)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:423)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
com.bOS.Action.ActionServlet.process(ActionServlet.java:21)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause net.sf.hibernate.JDBCException: Cannot open connection
net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:281)
net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3264)
net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3244)
net.sf.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:40)
net.sf.hibernate.transaction.JDBCTransactionFactory.beginTransaction(JDBCTransactionFactory.java:19)
net.sf.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:2195)
com.bOS.bPRO_PersonManage.service.UsersDao.logonUsers(UsersDao.java:78)
com.bOS.bPRO_PersonManage.action.UsersAction.logon(UsersAction.java:111)
com.bOS.bPRO_PersonManage.action.UsersAction.execute(UsersAction.java:41)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
com.bOS.Action.ActionServlet.process(ActionServlet.java:21)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]用户 'sa' 登录失败。
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(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:582)
java.sql.DriverManager.getConnection(DriverManager.java:154)
net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:95)
net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:278)
net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3264)
net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3244)
net.sf.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:40)
net.sf.hibernate.transaction.JDBCTransactionFactory.beginTransaction(JDBCTransactionFactory.java:19)
net.sf.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:2195)
com.bOS.bPRO_PersonManage.service.UsersDao.logonUsers(UsersDao.java:78)
com.bOS.bPRO_PersonManage.action.UsersAction.logon(UsersAction.java:111)
com.bOS.bPRO_PersonManage.action.UsersAction.execute(UsersAction.java:41)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
com.bOS.Action.ActionServlet.process(ActionServlet.java:21)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.33 logs.
--------------------------------------------------------------------------------Apache Tomcat/6.0.33

Answer 1

 [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]用户 'sa' 登录失败。你sql server 2000数据库的账号密码不对吧？
sa这个账号请在自己本机的数据库命令行登录试试。

Answer 2

 Cannot open connection
看下数据库服务开了没，或者ip 端口号错了没，或者用户名密码是否正确

Answer 3

你先在cmd里面运行 telnet 127.0.0.1 1433看看，能不能登录，然后在验证数据库账号、密码！

Answer 4

jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=PersonManage;user=sa;password=sa;我修改成这个了，我的数据库 用户名和密码 都是  sa ，还是不行。我自己做的别的项目就可以连接，不知道什么问题

Answer 5

1、可能是sqlserver的补丁问题；
2、检查sa用户，是否拥有owner的权限；
3、检查密码是否正确

Answer 6

net.sf.hibernate.JDBCException: Cannot open connectionDB没连上,可以自己在项目中写一个java方法测试一下get connection能不能成功.