Sharepoint - "Cannot connect to the configuration database"

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



We are running SBS 2003 Standard Edition with SP1, and WSUS (Windows
Server Update Services). All was well until the following update
attempted to install, which failed:

Update for SQL Server 2000 Desktop Engine (SharePoint) on Windows
Server 2003 (KB909544)

I now cannot start the MSSQL$SHAREPOINT service - it starts and
immediately stops again. The MSDE log file indicates a invalid schema
for the 'master' database now. This results in the fact that the
default Sharepoint point site is not accessible, but reports the
following error: "Cannot connect to the configuration database. For
tips on troubleshooting this error, search for article 823287 in the
Microsoft Knowledge Base at http://support.microsoft.com.";

I managed to find the KB909544 update package and attempted to manually
re-install it, but it reports that it is already installed.

It does not seem that the database for KB909544 vesion of MSDE is
compatible with previous versions (refer to the kb article), and the
slq service reports that the 'master' database has an "invalid schema".
I therefore suspect that the database itself has been upgraded, but
the MSDE engine upgrade failed.

Other threads that I have posted in regarding this same problem:
microsoft.public.sqlserver.setup: "Failed KB909544 installation"
microsoft.public.windowsupdate: "Update for SQL Server 2000 Desktop
Engine (SharePoint) on Windows"
microsoft.public.windows.server.sbs: "Help and Support Service is
missing. HELP."

Refer to the verbatim Application Event Log and MSDE log file info
below this message (sorry about any linewrapping)

Does anyone have any suggestions? Thanks in advance for your
assistance.

Regards,
Nicolas Noakes
www.intersol.co.za

Event Log for the failed update installtion:
----------------------------------------------------------

Event Type: Error
Event Source: Windows Update Agent
Event Category: Installation
Event ID: 20
Date: 2005/12/30
Time: 14:34:26
User: N/A
Computer: SERVER1
Description:
Installation Failure: Windows failed to install the following update
with error 0x800706be: Update for SQL Server 2000 Desktop Engine
(SharePoint) on Windows Server 2003 (KB909544).

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 57 69 6e 33 32 48 52 65 Win32HRe
0008: 73 75 6c 74 3d 30 78 38 sult=0x8
0010: 30 30 37 30 36 62 65 20 00706be
0018: 55 70 64 61 74 65 49 44 UpdateID
0020: 3d 7b 30 46 33 30 32 41 ={0F302A
0028: 42 38 2d 43 39 33 45 2d B8-C93E-
0030: 35 36 46 35 2d 43 35 36 56F5-C56
0038: 31 2d 33 33 37 31 38 30 1-337180
0040: 35 39 30 43 46 37 7d 20 590CF7}
0048: 52 65 76 69 73 69 6f 6e Revision
0050: 4e 75 6d 62 65 72 3d 31 Number=1
0058: 30 30 20 00 00 .

MSDE log file for attempting to start the MSSQL$SHAREPOINT service:
--------------------------------------------------------------------------------------------------------

2006-01-16 14:21:58.31 server Microsoft SQL Server 2000 - 8.00.2039
(Intel X86)
Oct 4 2005 16:05:38
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine (Windows) on Windows NT 5.2 (Build 3790: Service
Pack
1)

2006-01-16 14:21:58.31 server Copyright (C) 1988-2002 Microsoft
Corporation.
2006-01-16 14:21:58.31 server All rights reserved.
2006-01-16 14:21:58.31 server Server Process ID is 5480.
2006-01-16 14:21:58.31 server Logging SQL Server messages in file
'c:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT\LOG\ERRORLOG'.
2006-01-16 14:21:58.32 server SQL Server is starting at priority
class 'normal'(2 CPUs detected).
2006-01-16 14:21:58.35 server SQL Server configured for thread mode
processing.
2006-01-16 14:21:58.35 server Using dynamic lock allocation. [500]
Lock Blocks, [1000] Lock Owner Blocks.
2006-01-16 14:21:58.39 spid4 Starting up database 'master'.
2006-01-16 14:21:58.48 spid4 0 transactions rolled back in database
'master' (1).
2006-01-16 14:21:58.48 spid4 Recovery is checkpointing database
'master' (1)
2006-01-16 14:21:58.51 server Using 'SSNETLIB.DLL' version
'8.0.2039'.
2006-01-16 14:21:58.51 spid5 Starting up database 'model'.
2006-01-16 14:21:58.51 server SQL server listening on Shared Memory.
2006-01-16 14:21:58.51 server SQL Server is ready for client
connections
2006-01-16 14:21:58.53 spid4 Server name is 'SERVER1\SHAREPOINT'.
2006-01-16 14:21:58.53 spid4 Skipping startup of clean database id
4
2006-01-16 14:21:58.53 spid4 Skipping startup of clean database id
6
2006-01-16 14:21:58.53 spid4 Starting up database 'STS_Config'.
2006-01-16 14:21:58.57 spid5 Clearing tempdb database.
2006-01-16 14:21:58.75 spid5 Starting up database 'tempdb'.
2006-01-16 14:21:58.87 spid4 Recovery complete.
2006-01-16 14:21:58.96 spid4 Database 'master' has invalid schema.

.



Relevant Pages

  • RE: VPN Configuration error
    ... Remote Access wizard to configure VPN. ... How to move the client programs folder to another location in Windows Small ... or if the SBS SP1 did not finish the installation. ... On the SBS server, click Start, click Run, type "regedit" (without the ...
    (microsoft.public.windows.server.sbs)
  • Re: 2 Fragen vor der Neuinstallation vom SBS 2003!
    ... >> am Internet angeschlossen sein während der Installation ... > raus, damit auch nichts schiefgehen kann, und der Server auch keinen Müll ... If your Windows Small Business Server network contains client computers ... evtl. ...
    (microsoft.public.de.german.backoffice.smallbiz)
  • RE: HDD failure! Mirror boots ok except WSUS - Re-installation is
    ... In the Add or Remove Programs list, the "Windows Small Business Server ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • RE: Updating SBS 2003 with WS 2003 SP1 dies in cleanup phase.
    ... please download the component of SBS 2003 sp1 again from the ... Windows Server 2003 Service Pack 1 ... Windows SharePoint Services 2.0 Service Pack 1 ... Installation Instructions for Service Pack 1 for Windows Small Business ...
    (microsoft.public.windows.server.sbs)
  • RE: HDD failure! Mirror boots ok except WSUS - Re-installation is
    ... Terence in the Add/Remove Programms list I see the "Windows Small Business ... Server 2003", but it isn't "R2" as you wrote. ... | I tried to uninstall WSUS 2 and re-install it, but the installation is ... Unspecified error) ...
    (microsoft.public.windows.server.sbs)