×

Loading...
Ad by
  • 最优利率和cashback可以申请特批,好信用好收入offer更好。请点链接扫码加微信咨询,Scotiabank -- Nick Zhang 6478812600。
Ad by
  • 最优利率和cashback可以申请特批,好信用好收入offer更好。请点链接扫码加微信咨询,Scotiabank -- Nick Zhang 6478812600。

我就知道如何搞定SQL Authenticataion的,你的问题,我苦思冥想,外加google,最终获得结果如下:

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.

这段话是从microsoft的网页上copy下来的,所以,你放弃吧。
Report

Replies, comments and Discussions:

  • 工作学习 / IT技术讨论 / SQL Server里面有类似Oracle里面的Sequence吗?我在Transact-SQL Ref里面没找到,谢谢
    • there is a data type "id" something, maybe identity
    • it depends on the property of the column, you can set the identity, identity seed, identity increment for int,numberic, smallint datatayp etc.
    • 谢谢!还有一个问题:我安装SQL Server的时候选择的是Windows Authentication,那我用jdbc连接的时候DriverManager.getConnection()的参数应该怎么写?
      我的系统是Windows 2000 professional
      • up!!!!! Thank you in advance
        • 我就知道如何搞定SQL Authenticataion的,你的问题,我苦思冥想,外加google,最终获得结果如下:
          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.

          这段话是从microsoft的网页上copy下来的,所以,你放弃吧。
          • 谢谢,我死心了。。。。。。。。。。。:P