jbuilder和sql server的连接问题,怎么也连不上,郁闷中……,错误如下:
Jarky 2003-04-05 03:27:32 Error connecting to database: java.sql.SQLException: 用户 'sa' 登录失败。原因: 未与信任 SQL Server 连接相关联。 Severity 14, State 1, Procedure 'null null', Line 0 Unable to connect, please check your server's version and availability.
URL:jdbc:weblogic:mssqlserver4:northwind@localhost
driver:weblogic.jdbc.mssqlserver4.Driver
user name :sa
password:19830720(密码和用户名都是我的sql里面的)
换了window 登陆的用户名和密码还是不行
sql server运行着
weblogic 也建立连接池不成功
下载微软的jdbc驱动安装后也不行错误如下:
url:jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind
driver:com.microsoft.jdbc.sqlserver.SQLServerDriver
密码和用户名同上
错误:
See com.borland.dx.dataset.DataSetException error code: BASE+66
com.borland.dx.dataset.DataSetException: 用户 'zzr' 登录失败。原因: 未与信任 SQL Server 连接相关联。 Severity 14, State 1, Procedure 'null null', Line 0 Unable to connect, please check your server's version and availability.
at com.borland.dx.dataset.DataSetException.a(Unknown Source)
at com.borland.dx.dataset.DataSetException.throwException(Unknown Source)
at com.borland.dx.dataset.DataSetException.SQLException(Unknown Source)
at com.borland.dx.sql.dataset.Database.openConnection(Unknown Source)
at com.borland.jdbcx.metadata.DatabaseInfo.openConnection(Unknown Source)
at com.borland.jdbcx.metadata.e.run(Unknown Source)
Chained exception:
java.sql.SQLException: 用户 'zzr' 登录失败。原因: 未与信任 SQL Server 连接相关联。 Severity 14, State 1, Procedure 'null null', Line 0 Unable to connect, please check your server's version and availability.
at weblogic.jdbc.mssqlserver4.TdsStatement.microsoftLogin(TdsStatement.java:2823)
at weblogic.jdbc.mssqlserver4.MicrosoftConnection.beginLogin(MicrosoftConnection.java:44)
at weblogic.jdbc.mssqlserver4.TdsConnection.login(TdsConnection.java:59)
at weblogic.jdbc.mssqlserver4.MicrosoftConnection.login(MicrosoftConnection.java:55)
at weblogic.jdbc.mssqlserver4.BaseConnection.prepareConnection(BaseConnection.java:181)
at weblogic.jdbc.mssqlserver4.Driver.newConnection(Driver.java:34)
at weblogic.jdbc.mssqlserver4.ConnectDriver.connect(ConnectDriver.java:148)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at com.borland.dx.sql.dataset.Database.openConnection(Unknown Source)
at com.borland.jdbcx.metadata.DatabaseInfo.openConnection(Unknown Source)
at com.borland.jdbcx.metadata.e.run(Unknown Source)