Rob, what you're trying to do is referred to as trustedor 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
char...@carehart.org
Providing on-demand troubleshooting services for CF and CFBuilder
at http://www.carehart.org/consulting
From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Rob Saxon
Sent: Monday, February 21, 2011 2:55 PM
To: discussion@acfug.org
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: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Steve Ross
Sent: Monday, February 21, 2011 2:44 PM
To: discussion@acfug.org
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 saxon...@mercer.edu 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
-