Login failed for SQL Server 2000 datasource

[KingZeus]

I am trying to setup a SQL server 2000 datasource, but I keep getting the error
"[Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user...".

I have no idea what the problem could be. I've looked everywhere for info.

TCP/IP is configured.

The SQL Server is configured for both Windoes and SQL server authentication.
The username can login via enterprise manager.

I've tried accessing the database from CF installed on the same machine and an
my local machine. Both times I get the same error. Also, the ColdFusion admin
seems to convert the password to a 16 character string. I'm not sure if that is
normal.

This is the error info from the page:

SQL SELECT * FROM CUSTOMERS
DATASOURCE mamdev
VENDORERRORCODE 18456
SQLSTATE 28000

Any help would be appreciated.

Thank you.

[Tom Jordahl]

You should double check the username and password in the datasource. That
is the problem if you are getting log in errors.

The password field in the admin is always shown the same way, that probably
isn't the problem.
--
Tom Jordahl
Macromedia Server Development