Hi, Tom, Dave, Thanks for the reminder about Site Minder console ... I discovered it ages ago and had forgotten about it as I never found a use for it ..will investigate.
Tom, could you please let me know the versions (NT, MDAC, SQL, Spectra, CF) you finished up with when you got it all working and what database you used for the Policy Store (Access, SQL 7, SQL 2000 ?) Dave, unfortunately the problem with MDAC is that CF5 seems to require a low version (2.5SP1) not a high one (see KB 21664), whereas SQL 2000 seems to require 2.6 or higher (2.6 gets installed with SQL2K). Thanks again, Andy. > Date sent: Thu, 07 Feb 2002 15:30:59 -0600 > From: "Tom Briscoe" <[EMAIL PROTECTED]> > > Hello Andy. I'm taking a guess here as my company ran into a similar > problem. We found we had to manually set the password in the SiteMinder > console, "/cfusion/bin/smconsole.exe", to get Advanced Security back. We > still had to resort to this after a complete reinstall of CF and Spectra. > > > Tom Briscoe > Web Developer > Compass Bank > > >>> [EMAIL PROTECTED] 02/05/02 01:12PM >>> > I'm suffering from the problem described in CF Knowledgebase > article 21664, which is, briefly, if you have NT4 with MDAC 2.6 > installed, and you upgrade to CF5 and use SQL server 2000 for a > Policy Store ... Advanced security is broken. That is, you can't > administer Adv. Sec. through CF Admin. and you can't log on to > any Spectra Apps. > > I'd like to revert to my Access database, smPolicy50.mdb, which > seems have been created by the upgrade (before the security > wizard kindly migrated me to sql2k), but since CF Admin is broken > this is presumably going to mean registry hacks etc. > > Has anyone any idea how I might do this ? > > Any other advice would be much appreciated. > > Thanks, Andy > > ------- > > Background: > > What happened to me was that I had done the CF5 upgrade and > was following tech note 21551 (CF5 upgrade security issues). The > net result of steps 5-8 was that I was thrown into the upgrade > wizard which offered to convert my Access smPolicy to SQL > Server, hence the problem. > > I've already found a registry key that seems to name the Policy > Store datasource, but switching that to the Access datasource > made no difference, so I've switched back. It could be that this > might work in combination with another change ... e.g. the > migration wizard had about 12 steps including one to set the > "Policy Store Admin Password". Where did that get set ? Registry > and in the DB itself ? > > Versions: > > Windows NT 4 SP6a > SQL 2000 > MDAC 2.6 > CF 5 > > Possible courses of action: > > 1) Rollback to MDAC 2.5 SP1 (suggested by Macromedia). I'm > reluctant to do this as MDAC 2.6 was installed with SQL server > 2000 so I'm sure there was a reason for this. > > 2) Swap back to the access database smPolicy50.mdb which > seems to have been created by the CF5 upgrade. This is my > preferred option. > > 3) Uninstall + reinstall the Advanced security option, followed by (a) > swapping in the converted smPolicy50.mdb, if possible or else (b) > re-installing Spectra. > > 4) Rebuild the box from scratch using Windows 2000. I'd very much > prefer to avoid this. > > > > -- > Andy > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. ------------------------------------------------------------------------------ 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.
