Cannot Connect SQL 2000 Database to Cold Fusion

[Taxido_Mask]

Hello
I have a problem connecting my SQL2000 Server Database to my Macromedia
ColdFusion MX in the ColdFusion MX Administrator section: Data & Services >
Data Sources
In the server data field I tried both: 127.0.0.1 and the Server Name
I always receive the following error message:

Connection verification failed for data source: personals
[]java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login
failed for user '(null)'. Reason: Not associated with a trusted SQL Server
connection.
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC
Driver][SQLServer]Login failed for user '(null)'. Reason: Not associated with a
trusted SQL Server connection

I have checked
- TCP/IP Protocol is enbaled
- the test database has the appropriate rights (I use Windows Authentification)

CondFusionMX and SQL2000 Server are running on the same local computers

I'd like to mention that I use:
- Windows 2000 Prefession OS
- Macromedia Cold Fusion MX
- Microsoft SQL Server2000 + SP3

Can anyone tell me what else I could try or tell me where the problem lies.

Thank You.:confused;

[mkauspe]

I'm prob way off the ball, but it looks like you jsut have the wrong username
for your DSN. localhost or 127.0.0.1 shoud work fine granted it is on the same
box as CF. If you use Windows authentication on it than try using the
administrator account on that PC. I'm a n00b so ignore me if this is just
completely ignorant ;)