We help IT Professionals succeed at work.
Get Started

Windows Sharepoint Services 3.0 SP2 problem

1,730 Views
Last Modified: 2012-05-09
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.Upgrade.SPUpgradeException 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\PSCDiagnostics_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-bc80a30428c2'
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-bc80a30428c2 is not accessible. (Microsoft.SqlServer.Express.ObjectExplorer)

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.DatabaseNavigableItem.GetChildren()
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SummaryView.get_Items()
   at Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVirtualStorage.CopyItems(ISummaryView summaryView)
   at Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVirtualStorage..ctor(ISummaryView summaryView, List`1 columnDescriptors)
   at Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.RightPaneListViewer.PopulateView()

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_3f2203a2-d36f-4784-86bf-bc80a30428c2' on SQL Server instance 'SERVER\Microsoft##SSEE' not found. Additional error information from SQL Server is included below.

Cannot open database "SharePoint_Config_3f2203a2-d36f-4784-86bf-bc80a30428c2" 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.
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 11 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE