The official blog for Windows Server Essentials and Small Business Server support and product group communications.
[Today's post comes to us courtesy of the SBS Support Team]
After installing Sharepoint 3.0 SP2 (KB 953338), when you browse http://companyweb or open Sharepoint 3.0 Central Administration, you receive the following error "Cannot connect to the configuration database".
After you install one of the following updates or service packs on a computer that is running Windows SharePoint Services 3.0, you may have to rerun the SharePoint Products and Technologies Configuration Wizard (Psconfig.exe):
Windows SharePoint Services 3.0 software update
Windows SharePoint Services 3.0 service pack
The SharePoint Products and Technologies Configuration Wizard is run automatically on SBS 2008 when the update or service pack is installed via Microsoft Update or WSUS. If the SharePoint Products and Technologies Configuration Wizard detects a problem, the wizard does not finish. Additionally, users who try to visit the SharePoint Web site may receive "404" errors. These errors occur until the wizard has finished successfully.
One common symptom of this failed updated is that the Internet Address Management Wizard will fail, and the following will be logged in the DPCW.LOG:An exception of type 'Type: System.NullReferenceException, mscorlib, Version=220.127.116.11, Culture=neutral, PublicKeyToken=b77a5c561934e089' has occurred.Timestamp: 11/10/2009 15:01:55Message: Object reference not set to an instance of an object.
Stack: at Microsoft.SharePoint.Administration.SPPersistedObject..ctor(String name, SPPersistedObject parent, Guid id) at Microsoft.SharePoint.Administration.SPPersistedObject..ctor(String name, SPPersistedObject parent)
at Microsoft.SharePoint.Administration.SPPersistedUpgradableObject..ctor(String name, SPPersistedObject parent) at Microsoft.SharePoint.Administration.SPService..ctor(String name, SPFarm farm) at Microsoft.SharePoint.Administration.SPWebService..ctor(String name, SPFarm farm)
at Microsoft.WindowsServerSolutions.Common.IWorker.WSSConfig.CWSSConfig.AddUrlToSharePointSite(Guid existingSharePointSiteId, Uri newSharePointSiteURL, Boolean clearAllExistingUrls)
at Microsoft.WindowsServerSolutions.Networking.Wizards.NetSvcWizard.TaskConfigureWorkFromHomeWebsite.Run(ITaskDataLink dataLink) at Microsoft.WindowsServerSolutions.TaskManagement.Admin.LightweightDataLink.Run(TaskId taskId, IAssemblyTask task, CompositeTask parentTask) at Microsoft.WindowsServerSolutions.TaskManagement.Admin.SequentialTask.Run(ITaskDataLink dataLink)
at Microsoft.WindowsServerSolutions.TaskManagement.Admin.AdminDataLink.Run(TaskId taskId, IAssemblyTask task) at Microsoft.WindowsServerSolutions.TaskManagement.Admin.Committer.DoWork(Object sender, DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
1. Check to see if the Sharepoint database is Read-Only. To check this:
a. Click Start, point to All Programs , point to SQL Server 2005 , right-click SQL Server Management Studio , and then click Run as administrator .
b. The Connect to Server dialog appears. In the Server name field, specify \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query and click Connect.
c. Expand Databases, right-click the ShareWebDb database and click Properties.
d. Click the Options page and scroll down to the bottom. In the State section, make sure the Database Read-Only option is set to False. If not, temporarily change it to False and click OK.
e. If you have other databases used for Sharepoint sites, double check them as well.
Note: If you have a database that was set to be Read Only, that was likely done for a reason and you may want to set it back after completing the SharePoint Products and Technologies Configuration Wizard. For example this might have been done on an old site that is no longer in use to prevent users from adding content to it.
2. Manually re-run this wizard on the server from an elevated command prompt using the following command:
C:\Program Files\Common Files\Microsoft Shared\Web server extensions\12\BIN\psconfig -cmd upgrade -inplace b2b -force
3. If this wizard completes successfully, try to browse http://companyweb and Sharepoint 3.0 Central Administration again.
4. If this wizard still fails it may be for several other reasons. Those other possibilities are documented in KB 944267.
944267 How to troubleshoot common errors that occur when you run the SharePoint Products and Technologies Configuration Wizard on a computer that is running Windows SharePoint Services 3.0 or SharePoint Server 2007
PingBack from http://www.ditii.com/2009/05/08/troubleshooting-companyweb-inaccessible-after-sharepoint-30-sp2/
In my case, When we would execute C:\Program Files\Common Files\Microsoft Shared\Web server extensions\12\BIN\psconfig -cmd upgrade -inplace b2b –force it would result in an error and kick you back out. Looking at the log file at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS\Upgrade.log I see 7 ERR Task upgradebootstrap has failed with
an unknown exception
7 ERR Exception:
System.Data.SqlClient.SqlException: Cannot open database
"SharePoint_Config_29c26fca-17b8-48c1-9704-b869932abcb6" requested by the
login. The login failed.
Login failed for user 'DOMAIN\username'.
Upon looking at the SQL database, I noticed that the login name I was using was different then the name in the SQL security.
I had renamed the user account some time ago from DOMAIN\FirstNameLastName to DOMAIN\FirstName, so I decided to rename it back to the login name as it appeared in SQL Security. Then I logged off and then logged back in with that username, and executed C:\Program Files\Common Files\Microsoft Shared\Web server extensions\12\BIN\psconfig -cmd upgrade -inplace b2b –force
It then worked sucessfully.
I have tried your recommended steps but no success. I also read MS KB article but found no solution for my problem. May be I have missed something. In the log I have found the following error:
event id 5586, database error SQL 15299, The signature of the public key is invalid. Signing object:[dbo].[ImmedSubscriptions]
Is there any solution for solving this problem? Thanks for any advice.
Thank you so much! However the "-force" param was not valid. After running the psconfig (omitting -force), MOSS came back online.
Boy - did this save me in the end..!
(needed to drop the -force param as noted above.)
"Set up Internet Address Wizard" kept crashing - no RWW etc.
Took a while but after the psconfig upgrade all works fine again...
This fixed our problem as well. I had to change directories to the bin folder first, before running psconfig, again omitting -force, before it would run.