> 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?
First, this won't be a trusted connection. When you create a trusted connection, the process connecting to the database (in our case, the CF server) will authenticate itself via Windows authentication. Second, when you create an ODBC system DSN, the username and password isn't stored within the DSN itself, but rather within the client application that uses the DSN (again, the CF server). In CF 5 and earlier, when you create a DSN within the CF Administrator, this not only creates the DSN but also stores the username and password within the ColdFusion registry key. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
