I found the only way to consistently get a secure & functional
connection (caveat, I'm no SQL Server master) was to:
1) run the CF servers & siteminder servers under a specific username
which
2) has local rights established as an imported group on the db server
and
3) set SQL Server to NT authentication only, granting access rights to
users in the imported group.
Trusted connections seem to override the specific username I may type in
to the ODBC settings in admin, and are definitely the safest way to go
from what I've been able to gather. Siteminder is also set to connect
through trusted connections since that's how the service runs.
I had screwed the connections up for a short while by messing with the
client network utility, but resetting them to their defaults made
everything work out fine for us.
"Raymond K. Camden" wrote:
>
> > Well, we finally managed to get the userdirectory out of Access
> > and over to
> > SQLServer - and we got around the problem of database connections by
> > switching from SQLServer authentication (woes detailed below) to NT
> > authentication for the database login (thanks to Richard Ragan
> > for this one:
> > searching through past messages it turns out he'd already come
> > across this).
>
> One of my coworkers (and Rich's as well :) is having this issue. Where do
> you make this switch?
>
> =======================================================================
> Raymond Camden, Cold Fusion Jedi Master for Syntegra (www.syntegra.com)
> Allaire Certified Instructor and Member of Team Allaire
>
> Email : [EMAIL PROTECTED]
> ICQ UIN : 3679482
>
> "My ally is the Force, and a powerful ally it is." - Yoda
>
> ------------------------------------------------------------------------------
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send
>a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
--
Peter Ivanick
Web Developer
School of Veterinary Medicine, University of Pennsylvania
Email: [EMAIL PROTECTED]
Phone: 215.573.2306 Fax: 215.573.8777
http://www.vet.upenn.edu/
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
