Using Active Directory to connect to a database.

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

Re: Using Active Directory to connect to a database.

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