Re: [ACFUG Discuss] ColdFusion system account access to database

2011-02-21 Thread Steve Ross
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





 ---
 Rob Saxon
 Director
 Web Management
 Mercer University
 478-301-5550








-- 
Steve Ross
web application  interface developer
http://blog.stevensross.com
[mobile] (912) 344-8113
[ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ]


RE: [ACFUG Discuss] ColdFusion system account access to database

2011-02-21 Thread Rob Saxon
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.edumailto: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


---
Rob Saxon
Director
Web Management
Mercer University
478-301-5550





--
Steve Ross
web application  interface developer
http://blog.stevensross.com
[mobile] (912) 344-8113
[ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ]



-

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

-




RE: [ACFUG Discuss] ColdFusion system account access to database

2011-02-21 Thread Charlie Arehart
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
-