Hi Everyone, A majority of our data sources are connected via SQL authenticated accounts. This has been the norm established by previous developers and IT folk at my company. Lately, there has been discussion about using Windows authenticated accounts instead, due to the 'better' Windows security etc. My understanding is that the CF service can't simply connect to a data source in this manner because the service needs to be run as an actual domain account before a connection could be established? That and modifying IIS, drivers, ODBC connection seem to follow suit.
This has turned into a confusing topic for some of our staff who believe that simply creating multiple domain accounts with access to SQL server would solve the CF-SQL Windows authentication issue. These accounts have yet to work and I believe it's because of the reasons mentioned above. If the CF service needs to run as a domain account and all the configurations are applied, then can this be the only account that can be used? Any thoughts and input are greatly appreciated. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:330595 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
