Hi Peter,
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> 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:[EMAIL PROTECTED]]
> 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:[EMAIL PROTECTED]]
> > 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:[EMAIL PROTECTED]]
> > > 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:[EMAIL PROTECTED]]
> > > 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:[EMAIL PROTECTED]]
> > > > 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
> > > > [EMAIL PROTECTED]
> > > > www.wwstudios.com
> > > >
> > > > > -----Original Message-----
> > > > > From: Lee Fuller [mailto:[EMAIL PROTECTED]]
> > > > > 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 [EMAIL PROTECTED] with 'unsubscribe' in the body.
