> 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?
CF can use Windows authentication to connect to SQL Server: http://kb2.adobe.com/cps/000/1a3c2ad0.html CF uses the account you use to run the CF service, so only one account can be used per CF instance. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or on ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:330597 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
