JDBC Connection Question

Hi,

I am using sqljdbc_1.1 and am able to connect / query to my SQLServer 2000 database when I pass the "sa" userID and password in the connect URL.

String connectionUrl = "jdbc:sqlserver://<hostName>;databasename=mydb;user=sa;password=********";

However when I pass my username and password instead of the "sa" userID I get the following error (I edited out my userID from the error message):

com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user '<userID>'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.processLogon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at sqlCall.main(sqlCall.java:19)


I have tried passing the domain name with the userID and get the same error. I don't understand why the login would fail as I used my userID in a systemDSN on my laptop and had no problem connecting. I also used "SQL Server Enterprise Manager" configured to use my DOMAIN login information when I built the database.

Does anyone know what I could be doing wrong or what configuration I have overlooked?



Thanks,

RNG