I'm using Coldfusion MX7.0.2 on Windows 2003 SP1. I've installed and set up the Microsoft SQL Server 2005 JDBC driver, and have successfully set up a datasource using Windows Authentication (I have no user/password assigned in the datasource configuration; it's passing the ColdFusion service login which is an Active Directory account).
I'm trying to run a cfquery passing a specific user's credentials to the query, like this (I've changed username and password to protect the innocent ;>) ): <cfquery datasource="MyDSN" name="testQuery" username="MyDomain\UserName" password="MyPassword"> I have the SQL Server Profiler open running a trace on the target database. When I run the CFM page and execute the query, the trace shows that ColdFusion is still using the ColdFusion service login to run the query, instead of the user I passed to CFQUERY. Is there something else I need to do to make this work? Thanks, Carl ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316280 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4