> Does anyone know how to setup a datasource to authenticate with Active > Directory. We are moving away from service accounts on SQL Server and I > need to pass the Windows login credentials through my CF apps to SQL Server > so the user is allowed access to certain views and sprocs. For example > in .net you add "IntegratedSecurity=SSPI" to the connection script and your > done.
Are you talking about passing the end-user's credentials to the database? If so, I'm pretty sure that CF simply doesn't support this, as it doesn't have the ability to impersonate users. .NET applications can do this sort of thing because they're tightly tied to Windows, run in-process with IIS, etc. However, you can use Windows Authentication to pass the service account's credentials to CF, which is not the default behavior. In any case, even if you could do this, it would generally be a bad idea for performance reasons. Each user would have their own connection pool, and you wouldn't be able to reuse connections across users. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:322807 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
