SQL / Windows Authentication Per User

[BrkWindows]

Does anyone know if it is possible to configure ColdFusion MX 6.1 Enterprise
Server to connect to a SQL 2000 Server using Windows Authenitcation passing
individual user credentials. For example: User one logs into the coldfusion
application with username: domain\user1 and his password and those
credentials are used to connect to the SQL database to run the SQL command.

This is needed to provide SQL Auditing at a per domain user level.

If this cannot be done, is there an article that identifies this incapability?
Needed for federal certification.

If 6.1 Cannot, is this feature available in the new 7.0. If not, again, is
there a written article that identifies this incapability?

Thanks,

[tzimmerman]

The only way I know to use Windows authentication for individual users and SQL
Server is to use ODBC. However, ODBC is not recommended in production
environments with CFMX. As of the DataDirect 3.4 drivers you can use Windows
NT Authentication, but it is only for one user and that is the user that starts
the ColdFusion service. See "SQL Server NT authentication users (new feature)"
at
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=1a3c2ad0[/url].

Ted Zimmerman