JDBC Connecting To Sqlserver2005 Problem

Hi,

I am trying to connecting Eclipse to SQLserver2005 on Win2000, and the driver I use is JDBC.

My problem is: No matter what kind of authentification I try, it always throws out the exception of:

The user is not associated with a trusted SQL Server connection.

 

I tried 2 ways for connection: one is the windows, and another is Sql server authentification

To the window authentification, I appended Trusted_Connection=yes to the URL, and omit the user and password fields, and it failed. But even I used the user and password options, it didn't work, either.

To the Sqlserver authentification, I tried with the user and password, but it failed. Before that, I also added the user account in the Security option and for the specified Database.. while failed again.

And also for example:

when using the windows authentification, I tried this:

String SERVANDDB ="jdbc:sqlserver://localhost:1433;DatabaseName=TestDB;Trusted_Connection=Yes";
....

con = DriverManager.getConnection(SERVANDDB);

This throw the exception of user' ' is not a trust_connection....blabla


when using the sqlserver authentification, I tried like this:(the user ABC is assigned authority to database TestDB)

String SERVANDDB ="jdbc:sqlserver://localhost;DatabaseName=TestDB";
String USER = "ABC";
String PWD = "CBA";

con = DriverManager.getConnection(SERVANDDB, USER,PWD);

 

(The server is runing on my computer)

 

 Thank you.