>Do you mean using Windows Authentication, where the client automatically >passes the credentials it has logged into the domain controller with? >As far as I know that still can't be done but I'm not sure why. Is there >are particular reason you can't create a SQL account for CF to connect with? >I actually like that because it makes it a bit easier to audit permissions >with explicit accounts.
Yes. We can use a SQL login, but for our auditing purposes we want something that is automatic and assured that the username will be entered in by the system and not just our code. If we have to, we can use CGI.AUTH_USER and tack it onto each query into a separate column if it can't happen automatically, or some other kind of system that'll meet their requirements. > cfNTauthenticate will pass NT authentication but you will need to have > the user authenticate twice; once when they login to the machine and > again per coldfusion application. Right. Unfortunately, our domain is its own server that we're not going to have access to, so that option is closed to us. Thanks for your help! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332652 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
