Connecting MSSQL in CF Admin via a domain user

[cewyattjr]

Normally when I connect a database resource, we use a user specific to the MSSQL server.  However, I have a new resource that requires putting in domain-based credentials.  I've tried inputting domain\username for the domain-based db user in the regular username field, but that bounces me to the "invalid login" error.  Surely it is trying to interpret that username as a regular MSSQL user account. 

How do I tell it that the account is in Active Directory instead?  Maybe there is something I should add to the "Connection String" field?

Alternatively, I imagine I could set up a JDBC "other" driver, though that's more of a pain of course.

Thanks,

Chuck

[Steve Sommers]

The only way I have been able to use domain users is to configure the CF service to run as the domain user and leave the cfquery username and password empty. But this comes with it's own set of issues.