Using Active Directory to connect to a database.

[ib webn65]

I am use to creating a DSN in the CFAdmin to allow the CF websites to connect 
to a SQL database.  In the CF Admin the DSN’s are created using a SQL login 
id and password to access the database.  I have been asked to use an Active 
Directory account instead of a SQL account to connect to a SQL database.  Is 
this possible?  How?

Using the following systems:
CF Server = 8
SQL = 2005
IIS = 6


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325216
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Using Active Directory to connect to a database.

[Jason Fisher]

If your users have to login to the application using NTFS authorization, 
such as if you disable Anonymous access in IIS, then CF will have access 
to the user's network credentials and you could pass those into the 
query calls:

cfquery name=getMyStuff datasource=mySqlDatasource 
username=#cgi.auth_user# password=#cgi.auth_password#
...
/cfquery

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325235
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4