Create DSN in admin tool using domain account

[curious_Lee]

Hi. We're moving away from SQL authentication and using domain accounts for SQL
Server authentication. How does one create a data source in the admin site to
use a domain account? Is this possible? We're using ColdFusion 6.1. Thanks.

[Wesociety]

Have you tried using the standard Windows formatting?

DomainName\UserID
Password

[curious_Lee]

We've tried that and get the following error,

Connection verification failed for data source: myDataSource
[]java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login
failed for user 'MYDOMAIN\domainAccount'.
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC
Driver][SQLServer]Login failed for user 'MYDOMAIN\domainAccount'.

The account exists on the SQL Server 2005 database and has read/write
privileges.