Yes, it works like that. The CF server's authentication is passed through to SQL. You only need to ensure that the CF domain account has a matching login, in SQL, as well as the appropriate permissions within the database(s).
You should also clear the username and password fields in the datasource. They are not needed. M!ke -----Original Message----- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 14, 2007 9:40 AM To: CF-Talk Subject: Re: SOT: SQL Express Huh I never even knew this. How does it work? Does adding that to the connection string force the driver to log on to the SQL Server using Windows NTLM authentication, using the user name and password that the CF service is running under? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286150 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
