JAVA连接数据库登陆不了

Question

求解决，打开不了要登陆的数据库 数据库名字是对的，弄死我了。求解决 下面是错误的提示

com.microsoft.sqlserver.jdbc.SQLServerException: 无法打开登录所请求的数据库 "bpim"。登录失败。 ClientConnectionId:0525fa0a-1edd-4422-8935-db13f8b0f6f7
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$1LogonProcessor.complete(SQLServerConnection.java:2665)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2910)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at UI.LoginUI.actionPerformed(LoginUI.java:97)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)

Answer 1

筛查一下吧：（当时我学JDBC时总结的，感觉挺管用的）
①SQL2000需要装pack3或以上补丁
②端口号确定1433(SQL网络实用工具里面TCP/IP-属性查看)
③local服务器右键-属性-安全性-身份验证-SQL和Win勾选
④服务管理器，确定已经启动
⑤登陆用户名"sa"密码空可以登陆(或者新建用户并授权)
⑥SQL2000/2005/2008等版本的驱动的路径不一样，jar包别用错了

Answer 2

1.window验证改成密码账号验证。
2.查看端口 确保tcp/IP开启。sqlserver管理那边可以查看。

Answer 3

你最好 把你连接数据库 的URL和Driver 贴上来，不然不好确定

Answer 4

一生一代一双人，
蠡跟她闲谈半天，觉她言语幼稚，
争教两处销魂？　　
于世务全然不懂，终于问道：“阿
相思相望不相亲，天为谁春。　　

Answer 5

需要看下你的代码