MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

MSSQL$OfficeServers - Sharepoint Configuration Wizard Error

  Asked By: Margret    Date: Jan 03    Category: MOSS    Views: 5929

I installed sharepoint 2007 Server(a stand-alone server) on Windows 2008 Server
R2. Because of the following error message I am unable to run the Sharepoint
Products and Technologies and configuration Wizard:

"Failed to start the database service MSSQL$OfficeServers. Repair this product
by selecting it from the Add/Remove Programs menu."

Can anyone tell me how to fix it? There is no entry in the Add/Remove programs.



8 Answers Found

Answer #1    Answered By: Janell Camacho     Answered On: Jan 03

There is no SQL entry in the add/remove programs?

Sometime starting the setup again will get you to the remove all feature setup.

I found this is a newsgroup:
Failed to start the database service MSSQL$OfficeServers. Repair this product by
selecting it from the Add/Remove Programs menu. Here’s the solution: Go to
“regedit”, browse thru “HKLM_Local_Machine/Software/Microsoft/Shared
Tools/Web Server Extensions/12.0/WSS/”. Then change the value of attribute
named “ServerRole” from SINGLESERVER to APPLICATION

Answer #2    Answered By: Julia Washington     Answered On: Jan 03

This fixed my problem. thanks

Answer #3    Answered By: Shashwat Takle     Answered On: Jan 03

Always start with the most simplest thing:

Answer #4    Answered By: Aastha Acharya     Answered On: Jan 03

This is a good blog. I was not upgrading my server just a new install of
windows 2008 Server R2 using the advanced options for stand-along, single

Answer #5    Answered By: Glenda Roth     Answered On: Jan 03

A standalone installation of SharePoint will use the Windows Internal
Database (WID). This is an embedded copy of SQL Express that is used
specifically for SharePoint or things like Windows Server Update Services
(WSUS). It can't be removed from Add/Remove programs. The following
Microsoft Support article explains.


The underlying problem could be a number of things. I would suggest
re-running the SharePoint setup program to try to repair the installation.
If that doesn't work uninstall SharePoint and use the support article above
to remove WID. Then try re-installing. Remember you can only have one
instance of WID on the server, so if you are using the server for something
else like WSUS that could be the problem.

Answer #6    Answered By: Jada Clemons     Answered On: Jan 03

I assume the msiexec command will work on a x64-based
addition of windows 2008 server r2.

Answer #7    Answered By: Brooke Lewis     Answered On: Jan 03

It should. It's the command line for the Windows Installer service.