This sounds vaguely like a problem I had a long time ago with a corrupted smpolicy.mdb.
See if you can get a fresh copy and try again.
Cheers, Rich Ragan
----- Original Message -----
From: Tristan Roddis <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 03, 2000 3:29 AM
Subject: RE: Siteminder caching (was RE: Problems with moving the user directory to
SQLServer)
> > > > 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.
>
------------------------------------------------------------------------------
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.
