Rob, what you're trying to do is referred to as "trusted"or "type 2" or "windows" authentication.
The good news is that if you're using CF 8 or 9, all you need to do is leave the username blank. CF will use that to infer that you want to use trusted authentication with, as you note, whatever account has been used to start CF. This is discussed in the docs, but it's pretty easy to miss, even for those who ever do note that there are docs on CF Administration. :-) CF9: http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811 cbf364104-7fe5.html CF8: http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=datasource s_ADV_MJS_11.html If you're on CF7, though, such trusted authentication was enabled only by updating the JDBC drivers, a discussed in this technote: http://kb2.adobe.com/cps/000/42dcb10a.html And further, you needed to modify the connection parameters. See the section there near the bottom on "SQL Server NT authentication users". Let us know if any of that works for you, Rob. /charlie arehart [email protected] Providing on-demand troubleshooting services for CF and CFBuilder at http://www.carehart.org/consulting From: [email protected] [mailto:[email protected]] On Behalf Of Rob Saxon Sent: Monday, February 21, 2011 2:55 PM To: [email protected] Subject: RE: [ACFUG Discuss] ColdFusion system account access to database Thanks for the suggestion Steve. I also tried that and it failed. Interestingly enough, if I don't specify a user name or password, I get: "Could not establish a connection using integrated security: No LoginModules configured for JDBC_DRIVER_01" Thanks, Rob From: [email protected] [mailto:[email protected]] On Behalf Of Steve Ross Sent: Monday, February 21, 2011 2:44 PM To: [email protected] Subject: Re: [ACFUG Discuss] ColdFusion system account access to database You might have to use "user@domain" as your user name... On Mon, Feb 21, 2011 at 2:02 PM, Rob Saxon <[email protected]> wrote: Our DBA is wanting use to use an Active Directory domain account to access an internal database. He has given our CF service account access to the DB, but I am having difficulty getting a data source to connect thru CF Admin. Is it possible to do this? So far, I'm using domain\system account name as the data source user name and corresponding password. Any suggestions? Thanks, Rob ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
