Java开发网 - 如何解决？(未与信任 SQL Server 连接相关联)

Topic: 如何解决？(未与信任 SQL Server 连接相关联)

1.如何解决？(未与信任 SQL Server 连接相关联)

Posted by: ququ_0811
Posted on: 2005-05-19 19:31

请尽量用准确的文字描述作为标题
Your next post without a proper Subject will be removed.

Could you please do a search on this board or google for it before you post?

D:\>java testsql
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]用户 '(null)' 登录失败。原
因: 未与信任 SQL Server 连接相关联。java.sql.SQLException: [Microsoft][SQLServer
2000 Driver for JDBC][SQLServer]用户 '(null)' 登录失败。原因: 未与信任 SQL Serv
er 连接相关联。
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source
)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Un
known Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Sour
ce)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Sou
rce)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown S
ource)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at testsql.main(testsql.java:17)
我在连数据库时遇到上面错误！
我想知道是不是我应该在sql 2000中设置什么吗？

2.Re:如何解决？(未与信任 SQL Server 连接相关联) [Re: ququ_0811]

Copy to clipboard

Posted by: why
Posted on: 2005-05-19 20:09

from http://www.cjsdn.net/post/view?bid=10&id=140731 :

Check http://support.microsoft.com/default.aspx?scid=kb;en-us;313100

Basic Connectivity Troubleshooting
These are common error messages that may occur when you try to connect to your SQL server:

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for user 'user'. Reason: Not associated with a trusted SQL Server connection.
This error message occurs if the SQL Server 2000 authentication mode is set to Windows Authentication mode. The Microsoft SQL Server 2000 driver for JDBC does not support connecting by using Windows NT authentication. You must set the authentication mode of your SQL Server to Mixed mode, which permits both Windows Authentication and SQL Server Authentication.

Please post your 心得, 总结 like what you suggested on http://www.cjsdn.net/post/view?bid=10&id=143891

3.Re:如何解决？(未与信任 SQL Server 连接相关联) [Re: ququ_0811]

Copy to clipboard

Posted by: ququ_0811
Posted on: 2005-05-21 11:23

经过几天的数据库的连接！我现在已经可连接到我的ms sql
了，也练习了大哥教的方法，效果挺好的！在我刚安装my sql 由于我选这了windows 模式！使我的连接出现问题！由于我的个人版中没找到修改选项，我只好重一边！结果就可以了！如果我们使用工具时，一定要配好环境！
我感觉当我们遇到问题时，一定不要感觉有什么特别的，在我们的学习中这应该很正常，只要我们多接触，多看看别人的经验，问题一一排除，好好的总结，慢慢来就会见到效果！
请大哥多给点指教！
Tounge