Yes.. Was hoping to do that. The problem now seems to be (just another thing!) that SQL 2000 doesn't want to run it's DTS Wizard. Each time I run it (and we're now on the 4th completely clean install of SQL as the LAST thing in the chain) it pops up with an error: "Error in the dll." Of course, it doesn't specify WHAT dll. And when looking at the redist.txt file on the CD, it says to register a bunch of DLL's.. But that doesn't seem to help.

ARGH!

(Sorry.. I know this isn't a SQL list. Just HAD to vent it.)

Lee

> -----Original Message----- > From: pwatson@macromedia.com [mailto:pwatson@macromedia.com] > Sent: Tuesday, April 03, 2001 8:30 AM > To: Spectra-Talk > Subject: RE: Anyone Ever Fixed the "SC1" Issue? > > > Lee, > > Glad you're up and runnning! > > Now, going forward, I highly recommend (ie. must do) that you > (and anyone else using advanced security) upsize the policy > store to Sql server. MOST advanced security problems are due > to the policy store being in Access. The policy store schema > is somewhat complicated so that updates and writes involve a > lot of data being manipulated....which is Access' weakness. > This is why every step takes such a long time - we have > slowed the process down so that Access can keep up with each request. > > > This article will help you run through the steps. > http://www.allaire.com/Handlers/index.cfm?ID=14566&Method=Full > > > 1. Basically just create a blank sql datasource. > 2. Run the sql script on it to create the table structure > 3. Migrate the data from smpolicy.mdb > 4. Switch the names so that the sql datasource is used by > siteminder. 5. Restart the services. > > - peter > > > -----Original Message----- > From: Lee Fuller [mailto:leelist@primedna.net] > Sent: Tuesday, April 03, 2001 1:40 AM > To: Spectra-Talk > Subject: RE: Anyone Ever Fixed the "SC1" Issue? > > > Actually, I finally seem to have figured it out. When > Spectra creates the initial 'sc1' context, it doesn't add the > UserDirectory to the context. Adding it to it seems to have > done the trick. However, another stumbling block... Unless > you go into the UserDirectories and make sure that ODBC is > set for "UserDirectory", you'll get the error I sent below. > Adjusting that setting and restarting the services got me through. > > Now I'm in and am creating an application. > > Thanks for the help! > > > > Lee Fuller > Chief Technical Officer > PrimeDNA Corporation > > > -----Original Message----- > > From: Lee Fuller [mailto:leelist@primedna.net] > > Sent: Monday, April 02, 2001 8:49 PM > > To: Spectra-Talk > > Subject: RE: Anyone Ever Fixed the "SC1" Issue? > > > > > > Hello Peter, > > > > Well.. That got me farther. However, now when I try to login > > to the webtop, I get this error: > > > > ---------------------- > > > > Error Diagnostic Information > > > > An error occurred while evaluating the expression: > > > > > > stUserDirectories[request.cfa.activeUserDirectory].namespace > > is "LDAP:" > > > > > > > > Error near line 214, column 67. > > -------------------------------------------------------------- > > ---------- > > -------- > > > > Error resolving parameter REQUEST.CFA.ACTIVEUSERDIRECTORY > > > > > > The object ACTIVEUSERDIRECTORY is not present in the scope > > named REQUEST.CFA. It is likely that you have misspelled the > > name of the object you are trying to access. > > > > ---------------------- > > > > > > > > Lee Fuller > > Chief Technical Officer > > PrimeDNA Corporation > > > > > > > > > -----Original Message----- > > > From: Peter Watson [mailto:pwatson@macromedia.com] > > > Sent: Monday, April 02, 2001 2:19 PM > > > To: Spectra-Talk > > > Subject: RE: Anyone Ever Fixed the "SC1" Issue? > > > > > > > > > Lee, > > > > > > Try this: > > > > > > 1. delete the sc1 context > > > 2. turn off all security caches on the Advanced Security page and > > > click apply 3. stop the coldfusion server service, siteminder > > > authentication service, > > > siteminder authorization service from the services > > > control panel (*** > > > this is the most important step) > > > 4. start the 3 services above > > > 5. open the cf admin - advanced security page and click on > > > security contexts 6. create sc1 and make sure to check of > > > "user object" under resource types. 7. click retry step in > > > the spectra config wizard - or just rerun the whole wizard if > > > you closed the browser. 8. let me know how it goes > > > > > > regards, > > > peter watson > > > cf & spectra qa > > > > > > -----Original Message----- > > > From: Lee Fuller [mailto:leelist@primedna.net] > > > Sent: Monday, April 02, 2001 4:19 PM > > > To: Spectra-Talk > > > Subject: RE: Anyone Ever Fixed the "SC1" Issue? > > > > > > > > > Tried that.. Didn't work. 8( > > > > > > Lee > > > > > > -----Original Message----- From: Jason Aden [mailto:jason.aden@wwstudios.com] Sent: Monday, April 02, 2001 12:56 PM To: Spectra-Talk Subject: RE: Anyone Ever Fixed the "SC1" Issue?

The best thing to do is delete and recreate SC1. Go into the CF Admin Advanced Security. Note the settings for SC1 and > > then delete it (the delete runs pretty slowly, so just wait).

Then recreate SC1 with the same settings (when creating > > the security context there will be an additional check box something > like "Add current User Directories" that you want to leave checked).

After recreating the context, try that step again.

Jason

---- Jason Aden Allaire Certified Developer jason@wwstudios.com www.wwstudios.com

> -----Original Message----- > From: Lee Fuller [mailto:leelist@primedna.net] > Sent: Monday, April 02, 2001 3:52 PM > To: Spectra-Talk > Subject: Anyone Ever Fixed the "SC1" Issue? > > > Has anyone ever figured out the problem when running the > > > first-time > configuration of 1.5 NT, where you end up with an > > > "Invalid Security > Context 'sc1'" message? > > We've tried EVERYTHING we've found in the KB, Forums, > etc.. And > nothing seems to fix it. Even tried upsizing to SQL.. Nada. > > Lee > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to spectra-talk-request@houseoffusion.com with 'unsubscribe' in the body.