So then we set up system DSN's that use these SQL accounts to access the DB they need access to? I believe that this makes it a trusted connection. Does anybody know if there are any issues with this?
Thanks, Thomas. -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 01, 2002 7:28 AM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: SQL Access. > 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 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
