Unable to configure SharePoint Products and Technologies Configuration Wizard

I started with MOSS 2007 today and first thing I did was to install MOSS 2007 J. The installation was successful with a few initial hiccups, but while trying to run SharePoint Products and Technologies Configuration Wizard, I got the following error message.

---------------------------
SharePoint Products and Technologies Configuration Wizard
---------------------------
Failed to start the database service MSSQL$OfficeServers. Repair this product by selecting it from the Add/Remove Programs menu.
---------------------------
OK
---------------------------

However I didn’t want to reinstall the SQL Express. I researched a bit and saw that 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.

I changed ServerRole’s value from SINGLESERVER to APPLICATION and after this I was able to configure the MOSS successfully and it’s running fine now J.

NOTE: Please make sure you make a backup of the registry before you make any changes. Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system.