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"
I have:
* 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:
<snip>
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
de.SPUpgra
deExceptio
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
rver Extensions\12\Logs\Upgrade
.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
nostics_6_
15_2010_11
_1_53_312_
19
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
Point_Config_3f2203a2-d36f
-4784-86bf
-bc80a3042
8c2'
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
-d36f-4784
-86bf-bc80
a30428c2 is not accessible. (Microsoft.SqlServer.Expre
ss.ObjectE
xplorer)
--------------------------
----
Program Location:
at Microsoft.SqlServer.Manage
ment.UI.VS
Integratio
n.ObjectEx
plorer.Dat
abaseNavig
ableItem.G
etChildren
()
at Microsoft.SqlServer.Manage
ment.UI.VS
Integratio
n.ObjectEx
plorer.Sum
maryView.g
et_Items()
at Microsoft.SqlServer.Manage
ment.UI.VS
Integratio
n.AppIDPac
kage.ListV
iewVirtual
Storage.Co
pyItems(IS
ummaryView
summaryView)
at Microsoft.SqlServer.Manage
ment.UI.VS
Integratio
n.AppIDPac
kage.ListV
iewVirtual
Storage..c
tor(ISumma
ryView summaryView, List`1 columnDescriptors)
at Microsoft.SqlServer.Manage
ment.UI.VS
Integratio
n.AppIDPac
kage.Right
PaneListVi
ewer.Popul
ateView()
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
2-d36f-478
4-86bf-bc8
0a30428c2'
on SQL Server instance 'SERVER\Microsoft##SSEE' not found. Additional error information from SQL Server is included below.
Cannot open database "SharePoint_Config_3f2203a
2-d36f-478
4-86bf-bc8
0a30428c2"
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.