# Saturday, August 08, 2009

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

SBS installs the SQL Express edition on your server. Search server 2008 uses the same during the installation.  Once the installation is competed we tried to launch the  "SharePoint Products and Technologies Configuration Wizard "   which shouted this error.

The error says it is unable to restart the service of MSSQL , and we concentrated on the permissions to SQL SERVER.  No luck.

finally we found a clue - during the installation for search server 2008 we selected the mode of  "Standalone installation "  and concentrated more on this and searched for articles from MS KB.

yes - we found from akshays blog. - Thanks Akshay.

Changed the Registry Key for server role (HKLM/Software/Microsoft/Shared Tools/Web Server Extensions/12.0/WSS/ServerRole) is set incorrectly. It was set to SINGLESERVER.

we changed the role from SINGLESERVER to APPLICATION and after this we were able to configure and pass the wizard successfully.

 

Please note: Please take the necessary backup of the registry -before you do anything with the registry.

 

Thanks
E.Ravi

posted on Saturday, August 08, 2009 11:53:13 AM (India Standard Time, UTC+05:30)  #    Comments [0]