> > > 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?
>
> You actually have to go in to the ODBC section of Control
> Panel on the machine CF is running on. Then about halfway
> through the 'setup ODBC data source' screens for the System
> DSN in question, there's a choice to use SQLServer
> authentication (where you supply a username and password) or
> to switch to NT authentication (where you don't)
As an update to this, it doesn't appear to be so simple! While the above
worked for one machine here (see Log 1 below), when we tried this for
another machine, authentication failed with the same error message that we
were receiving when the ODBC source was using SQLServer authentication (Log
2 - note the mysterious user '/'). No amount of stopping and restarting
services, deleting and recreating the datasource or even rebooting the whole
machine seems to get it to behave as it should.
Has anybody else had any experience of this, positive or negative?
Thanks,
-T.
-----------------------------------------------
Siteminder log 1: working OK (correctly using NT authentication)
[01/Sep/2000:10:06:11 0000][153-I] req r# 5/2 > 200 : 'CFSM'
[01/Sep/2000:10:06:11 0000][153-I] req r# 5/2 > 208 : ''
[01/Sep/2000:10:06:11 0000][153-I] req r# 5/2 > 204 :
'06-5669b070-66f2-11d4-9022-00d0b72a137f'
[01/Sep/2000:10:06:11 0000][153-I] req r# 5/2 > 210 : 'admin'
[01/Sep/2000:10:06:11 0000][153-I] req r# 5/2 > 211 : '** Not Shown **'
[01/Sep/2000:10:06:11 0000][153-SmObjProvider] Fetching object 'Realm'
06-5669b070-66f2-11d4-9022-00d0b72a137f
[01/Sep/2000:10:06:11 0000][153-SmObjProvider] Fetching property
'UserDirectories' of object 'Domain' 03-5669b062-66f2-11d4-9022-00d0b72a137f
[01/Sep/2000:10:06:11 0000][153-SmObjProvider] Fetching object
'UserDirectory' 0e-5669b060-66f2-11d4-9022-00d0b72a137f
[01/Sep/2000:10:06:11 0000][153-SmDs] Directory 'userDirectory'
[01/Sep/2000:10:06:11 0000][153-SmObjProvider] Fetching object 'Scheme'
0d-4afc0e42-ae25-11d1-9cdd-006008aac24b
[01/Sep/2000:10:06:11 0000][153-SmDs] User 'admin' in directory
'userDirectory'
[01/Sep/2000:10:06:11 0000][153-SmObjProvider] Fetching object 'Scheme'
0d-4afc0e42-ae25-11d1-9cdd-006008aac24b
[01/Sep/2000:10:06:11 0000][153-SmAuthUser] Authenticating via scheme
'Basic'
[01/Sep/2000:10:06:11 0000][153-I] ** Status r# 5/2 : Authenticated.
-----------------------------------------------
Siteminder log 2: failing (still trying to use SQLServer authentication)
[26/Aug/2000:13:08:48 0000][300-I] req r# 1/6 > 200 : 'CFSM'
[26/Aug/2000:13:08:48 0000][300-I] req r# 1/6 > 208 : ''
[26/Aug/2000:13:08:48 0000][300-I] req r# 1/6 > 204 :
'06-5cd88360-618c-11d4-a6c9-00d0b72a137f'
[26/Aug/2000:13:08:48 0000][300-I] req r# 1/6 > 210 :
'FC558595621D11D4A6CA00D0B72A137F'
[26/Aug/2000:13:08:48 0000][300-I] req r# 1/6 > 211 : '** Not Shown **'
[26/Aug/2000:13:08:48 0000][300-SmObjProvider] Fetching object 'Realm'
06-5cd88360-618c-11d4-a6c9-00d0b72a137f
[26/Aug/2000:13:08:48 0000][300-SmObjProvider] Fetching property
'UserDirectories' of object 'Domain' 03-5cd88352-618c-11d4-a6c9-00d0b72a137f
[26/Aug/2000:13:08:48 0000][300-SmObjProvider] Fetching object
'UserDirectory' 0e-f8e954a0-618a-11d4-a6c9-00d0b72a137f
[26/Aug/2000:13:08:48 0000][300-SmDs] Directory 'userDirectory'
[26/Aug/2000:13:08:48 0000][300-E] Failed to connect to ODBC data source
'userDirectory. Login failed for user '\'.
[26/Aug/2000:13:08:48 0000][300-SmServAuth] User directory 'userDirectory'
can not be contacted
[26/Aug/2000:13:08:48 0000][300-I] ** Status r# 1/6 : Authentication Attempt
Failed.
-----------------------------------------
------------------------------------------------------------------------------
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.
