> We have a CF 5.0 machine that needs to access another > machine running SQL. Right now CF 5 runs under the > local admin account on its machine, and SQL runs under > a domain account on the SQL machine. Is there a way to > set it up so that each application that uses its own > DSN, can access the SQL server with it own individual > account that has access to only the database it needs, > and no other access. As I understand it you need to > have CF 5 running under a domain account, and then give > that one account access to all the DB's you are using > to store data for your apps. In our case we have 10-20 > apps that have a DB backend, so now that domain account > has to have access to all of those DB's?
I suggest that you configure your SQL Server to allow both Windows and "native" SQL authentication, and that you use SQL accounts to access the database from CF, instead of using Windows authentication. Once you're done setting that up, I'd recommend running the CF service with an account that doesn't have domain access. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
