Windows SharePoint Services 3.0 running on Windows Server 2003 SP2. Everything was working fine. One morning, at 3am, the server installed a Windows update and rebooted. After that reboot, all we get when trying to hit our SharePoint site AND the Central Admin site is this error message:
Cannot connect to the configuration database.
I've done extensive searching on this error and have gone through all the recommendations from Microsoft (KB823287) and the error persists.
The following error is proliferated in my event log:
Event Type: Error
Event Source: Windows SharePoint Services 3
Event Category: Database
Event ID: 3760
Date: 10/10/2007
Time: 2:17:02 PM
User: N/A
Computer: SPS01
Description:
SQL Database 'SharePoint_Config_31037d2
d-30f5-44a
7-9227-106
d3f2a20e6'
on SQL Server instance 'sps01\Microsoft##SSEE' not found. Additional error information from SQL Server is included below.
Cannot open database "SharePoint_Config_31037d2
d-30f5-44a
7-9227-106
d3f2a20e6"
requested by the login. The login failed.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
-------
Also there is this error in the event log:
Event Type: Failure Audit
Event Source: MSSQL$MICROSOFT##SSEE
Event Category: (4)
Event ID: 18456
Date: 10/10/2007
Time: 2:17:02 PM
User: NT AUTHORITY\NETWORK SERVICE
Computer: SPS01
Description:
The description for Event ID ( 18456 ) in Source ( MSSQL$MICROSOFT##SSEE ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: NT AUTHORITY\NETWORK SERVICE, [CLIENT: <named pipe>].
Data:
0000: 18 48 00 00 0e 00 00 00 .H......
0008: 16 00 00 00 53 00 50 00 ....S.P.
0010: 53 00 30 00 31 00 5c 00 S.0.1.\.
0018: 4d 00 49 00 43 00 52 00 M.I.C.R.
0020: 4f 00 53 00 4f 00 46 00 O.S.O.F.
0028: 54 00 23 00 23 00 53 00 T.#.#.S.
0030: 53 00 45 00 45 00 00 00 S.E.E...
0038: 07 00 00 00 6d 00 61 00 ....m.a.
0040: 73 00 74 00 65 00 72 00 s.t.e.r.
0048: 00 00 ..
-----
I've tried changing the Application Pool for the sharepoint app to run as Administrator and another admin-level account (although it was working fine as the default NETWORK SERVICE). It SEEMS like a permissions problem, but you'd think that would be solved by logging in as Administrator. It was not. Same error.
Also, I tried installing SQL Server Mgmt Studio on the computer and tried connecting to the SPS01\MICROSOFT##SSEE (SPS01 being the server name) instance and it won't let me connect, presumably because this is the embedded edition of SQL server that came with WSS3.0.
So, I have no way to trouble shoot the SQL portion, and no way to re-configure things in SharePoint because Central Admin won't come up either.
