MSSQL$SHAREPOINT starts and then stops - after Windows Update on 7

[javisa]

MOSS-Sharepoint, SBS Small Business Server
Tags:
Microsoft, SBS 2003 Premium, SP2, Database 'master' has invalid schema
SharePoint cannot connect to config database.
MSSQL$SHAREPOINT will not start automatically. If I start it manually it
runs for about two seconds and shut down.

Looking at the MSSQL$SHAREPOINT Errorlog I see the following at the end of
the file.
2008-07-09 16:09:38.56 spid2 Recovery complete.
2008-07-09 16:09:38.70 spid2 Database 'master' has invalid schema.

I have applied every update to the server available from Microsoft update.

I suspect an update clobbered it. Anyone else have this issue?

[Peter Saddow [Microsoft]]

This is a known issue. We are have been working on creating a document on
how to workaround this problem. I'm looking for the public document and when
I located, I will sent to you.

Thanks,
Peter Saddow [Microsoft]

"javisa" <javisa@discussions.microsoft.com> wrote in message
news:CF1A49A6-05F0-45B6-9C1C-FA6532DB5A1B@microsoft.com...
> MOSS-Sharepoint, SBS Small Business Server
> Tags:
> Microsoft, SBS 2003 Premium, SP2, Database 'master' has invalid schema
> SharePoint cannot connect to config database.
> MSSQL$SHAREPOINT will not start automatically. If I start it manually it
> runs for about two seconds and shut down.
>
> Looking at the MSSQL$SHAREPOINT Errorlog I see the following at the end of
> the file.
> 2008-07-09 16:09:38.56 spid2 Recovery complete.
> 2008-07-09 16:09:38.70 spid2 Database 'master' has invalid schema.
>
> I have applied every update to the server available from Microsoft update.
>
> I suspect an update clobbered it. Anyone else have this issue?
>

[rybickiibsen@gmail.com]

On 16 Jul., 08:49, "Peter Saddow [Microsoft]"
<peter...@online.MICROSOFT.COM> wrote:
> This is a known issue. We are have been working on creating a document on
> how to workaround this problem. I'm looking for the public document and when
> I located, I will sent to you.
>
> Thanks,
> Peter Saddow [Microsoft]
>
> "javisa" <jav...@discussions.microsoft.com> wrote in message
>
> news:CF1A49A6-05F0-45B6-9C1C-FA6532DB5A1B@microsoft.com...
>
> > MOSS-Sharepoint, SBS Small Business Server
> > Tags:
> > Microsoft, SBS 2003 Premium, SP2, Database 'master' has invalid schema
> > SharePoint cannot connect to config database.
> > MSSQL$SHAREPOINT will not start automatically. If I start it manually it
> > runs for about two seconds and shut down.
>
> > Looking at the MSSQL$SHAREPOINT Errorlog I see the following at the end of
> > the file.
> > 2008-07-09 16:09:38.56 spid2 Recovery complete.
> > 2008-07-09 16:09:38.70 spid2 Database 'master' has invalid schema.
>
> > I have applied every update to the server available from Microsoft update.
>
> > I suspect an update clobbered it. Anyone else have this issue?

Hi Peter

Could you post a link to the document, as we are quite a few
struggling with this problem.

Cheers

Jesper

[Peter Saddow [Microsoft]]

This issue and a workaround is documented at
http://support.microsoft.com/kb/948110 (See the known issue section)

Thanks,
Peter Saddow [Microsoft]

"javisa" <javisa@discussions.microsoft.com> wrote in message
news:CF1A49A6-05F0-45B6-9C1C-FA6532DB5A1B@microsoft.com...
> MOSS-Sharepoint, SBS Small Business Server
> Tags:
> Microsoft, SBS 2003 Premium, SP2, Database 'master' has invalid schema
> SharePoint cannot connect to config database.
> MSSQL$SHAREPOINT will not start automatically. If I start it manually it
> runs for about two seconds and shut down.
>
> Looking at the MSSQL$SHAREPOINT Errorlog I see the following at the end of
> the file.
> 2008-07-09 16:09:38.56 spid2 Recovery complete.
> 2008-07-09 16:09:38.70 spid2 Database 'master' has invalid schema.
>
> I have applied every update to the server available from Microsoft update.
>
> I suspect an update clobbered it. Anyone else have this issue?
>

[allenjb1@gmail.com]

On Jul 17, 1:53 am, "Peter Saddow [Microsoft]"
<peter...@online.MICROSOFT.COM> wrote:
> This issue and a workaround is documented athttp://support.microsoft.com/kb/948110(See the known issue section)
>
> Thanks,
> Peter Saddow [Microsoft]
>
> "javisa" <jav...@discussions.microsoft.com> wrote in message
>
> news:CF1A49A6-05F0-45B6-9C1C-FA6532DB5A1B@microsoft.com...
>
>
>
> > MOSS-Sharepoint, SBS Small Business Server
> > Tags:
> > Microsoft, SBS 2003 Premium, SP2, Database 'master' has invalid schema
> > SharePoint cannot connect to config database.
> > MSSQL$SHAREPOINT will not start automatically. If I start it manually it
> > runs for about two seconds and shut down.
>
> > Looking at the MSSQL$SHAREPOINT Errorlog I see the following at the endof
> > the file.
> > 2008-07-09 16:09:38.56 spid2 Recovery complete.
> > 2008-07-09 16:09:38.70 spid2 Database 'master' has invalid schema.
>
> > I have applied every update to the server available from Microsoft update.
>
> > I suspect an update clobbered it. Anyone else have this issue?- Hide quoted text -
>
> - Show quoted text -

Does this problem also occur with SQL Server 2005?

[Mozzis]

The title of the article linked by Peter is

MS08-040: Description of the security update for SQL Server 2000 GDR and
MSDE 2000: July 8, 2008

The steps mentioned in the article do not apply to the configuration
described by the original poster. Please, can someone answer this issue?

"allenjb1@gmail.com" wrote:

> On Jul 17, 1:53 am, "Peter Saddow [Microsoft]"
> <peter...@online.MICROSOFT.COM> wrote:
> > This issue and a workaround is documented athttp://support.microsoft.com/kb/948110(See the known issue section)
> >
> > Thanks,
> > Peter Saddow [Microsoft]
> >
> > "javisa" <jav...@discussions.microsoft.com> wrote in message
> >
> > news:CF1A49A6-05F0-45B6-9C1C-FA6532DB5A1B@microsoft.com...
> >
> >
> >
> > > MOSS-Sharepoint, SBS Small Business Server
> > > Tags:
> > > Microsoft, SBS 2003 Premium, SP2, Database 'master' has invalid schema
> > > SharePoint cannot connect to config database.
> > > MSSQL$SHAREPOINT will not start automatically. If I start it manually it
> > > runs for about two seconds and shut down.
> >
> > > Looking at the MSSQL$SHAREPOINT Errorlog I see the following at the end of
> > > the file.
> > > 2008-07-09 16:09:38.56 spid2 Recovery complete.
> > > 2008-07-09 16:09:38.70 spid2 Database 'master' has invalid schema.
> >
> > > I have applied every update to the server available from Microsoft update.
> >
> > > I suspect an update clobbered it. Anyone else have this issue?- Hide quoted text -
> >
> > - Show quoted text -
>
> Does this problem also occur with SQL Server 2005?
>

[lcordero]

this is happening on my sql 2005 server, seems to have happened just after an update.
i am removing the updates now and will let you know