Microsoft Content Management Server - Re: REPOST: Re: MCMS2002 SP1a upgrade - Offending SQL: GetTimeZoneSetting

This is Interesting: Free IT Magazines  
Home > Archive > Microsoft Content Management Server > March 2005 > Re: REPOST: Re: MCMS2002 SP1a upgrade - Offending SQL: GetTimeZoneSetting





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Re: REPOST: Re: MCMS2002 SP1a upgrade - Offending SQL: GetTimeZoneSetting
Jan-Willem

2005-03-23, 7:47 am

Hi all,

I checked the ISAPI filters as well as the anonymous users rights, there was
nothing wrong with that.
What fixed my problem was the following:

* create a new empty channel
* create a new webserver in IIS and mark it as an MCMS site in the SCA
* visit the new empty channel, and see the default listing with all other
channels as links

After these 3 simple steps, my other sites started working again. Probable
cause of this: database got
corrupted during the upgrade process, according to MS Support. Apparently
something happens when you create
a new channel and visit it. Perhaps a DB check?

Although i'm happy it all works again :-) i'm quite curious how this works
internally? What happens on channel creation,
etc. Can somebody give a more in depth explanation on this?

- JW

"Stefan [MSFT]" <stefang@online.microsoft.com> wrote in message
news:upYf5S7KFHA.688@TK2MSFTNGP10.phx.gbl...
> Hi Jan,
>
> not sure if these windows should show up on an upgrade as you already
> defined these things before the SP install.
> Usually I would expect that the installer uses the configuration it has
> before.
>
> The directory listing denied can happen if the ISAPI filter are registered
> twice in IIS.
> Please check if you have 2 or 4 MCMS ISAPI filters.
> The MCMS ISAPI filters contain either MCMS or Resolution in their name.
> After SP1a is installed on the MCMS filters should be used.
>
> Cheers,
> Stefan.
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> Book: Building Websites Using MCMS: http://tinyurl.com/6zj44
> ----------------------
>
>
> "Jan-Willem" <janwillemREMOVETHIS@evident.nl> wrote in message
> news:#ltqL46KFHA.1948@TK2MSFTNGP14.phx.gbl...
> I
> rights
> SP3
> on
>
>



Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com