I recently applied SP2 to WSS 3.0 and came across the problem that from what I can find has been pretty widespread.
I'm currently getting "Cannot connect to configuration database"
* Restarted Microsoft##SSEE service, W3C service and Sharepoint Service
* Rebooted the server (required to apply updates)
* Run "psconfig -cmd upgrade -inplace b2b -wait -force"
* Been through http://support.microsoft.com/kb/944154
which failed, see below:
Performing configuration task 3 of 4
Upgrading SharePoint Products and Technologies...
Failed to upgrade SharePoint Products and Technologies.
An exception of type Microsoft.SharePoint.Upgra
n was thrown.
Additional exception information: Upgrade completed with errors. Review the u
pgrade.log file located in C:\Program Files\Common Files\Microsoft Shared\Web Se
.log. The number of errors and warnings is liste
d at the end of the upgrade log file.
Total number of configuration settings run: 3
Total number of successful configuration settings: 2
Total number of unsuccessful configuration settings: 1
Successfully stopped the configuration of SharePoint Products and Technologies.
Configuration of SharePoint Products and Technologies failed. Configuration mus
t be performed before you use SharePoint Products and Technologies. For further
details, see the diagnostic log located at C:\Program Files\Common Files\Micros
oft Shared\Web Server Extensions\12\LOGS\PSCDiag
65996320.log and the application event log.
C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>stsa
dm -o upgrade -inplace -url http://intranet
Database state cannot be changed while other users are using the database 'Share
ALTER DATABASE statement failed.
sp_dboption command failed.
* Checked DB permissions in Microsoft SQL Server Management Studio Express, Sharepoint_Config database seems to be inaccessible, see below.
The database SharePoint_Config_3f2203a2
a30428c2 is not accessible. (Microsoft.SqlServer.Expre
ryView summaryView, List`1 columnDescriptors)
Event log shows the following, I know this can be a permission problem but since it doesn't mention the login details maybe something else?
SQL Database 'SharePoint_Config_3f2203a
on SQL Server instance 'SERVER\Microsoft##SSEE' not found. Additional error information from SQL Server is included below.
Cannot open database "SharePoint_Config_3f2203a
requested by the login. The login failed.
I also get the following but have had these for a while and they've never caused issues although getting a lot more of them at the moment especially when trying any operations on the databases.
The description for Event ID ( 17137 ) 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: Lansweeper32.
I'm no database/Sharepoint guru so if anyone out there with more knowledge of this problem can point me in the right direction would be greatly appreciated.