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?
Any suggestions would be greatly appreciated. Thanks, Thomas. ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
