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.
Comments
- Anonymous
March 04, 2009
Good stuff. it took me 5 hours to find that out - Anonymous
May 04, 2009
thank you very much,your way is very cool - Anonymous
June 22, 2009
Thanks - was stressing about not getting past that error!! - Anonymous
July 01, 2009
awesome manvery good.keep it up.helped me a lot. - Anonymous
July 05, 2009
Thanks man. It worked for me. Great Job. - Anonymous
August 10, 2009
just awesome! you made my day! thank you so much! it worked like champ! - Anonymous
August 18, 2009
Man you saved my life!!! I was stuck for over a week with this problem, tanks - Anonymous
September 28, 2009
Thank you for the info...worked on this all weekend and your fix did the trick. Keep up the great postings. - Anonymous
November 10, 2009
Thanks for the info. It works great. But could you (or anyone) explain to me what's the implication of changing the server role from SINGLESERVER to APPLICATION? I'm running a stand-alone server.Thanks, - Anonymous
November 18, 2009
Great!!! I am on stand alone. This worked for me. But little curious to the info SINGLESERVER vs APPLICATION. - Anonymous
December 10, 2009
The comment has been removed - Anonymous
January 13, 2010
Thanks!!i have this error in Sharepoint 2010 and this helps! thanks - Anonymous
January 27, 2010
very helpful!! thank you thank you! - Anonymous
March 15, 2010
Akshay, my friend......you kicked my day off with this little and beautiful solution. I owe you one. - Anonymous
March 27, 2010
This worked like a charm. Thank you OP! - Anonymous
April 25, 2010
Great thanks, worked first time, thanks for the heads up! Also found the solution straight away in Google, very useful and saved a lot of time digging around. - Anonymous
June 21, 2010
Awsome... Gr8 work - Anonymous
November 23, 2010
Awesome. It worked great.. Hats off to you man..!! - Anonymous
April 25, 2011
Worked for me... Thanks alot - Anonymous
August 07, 2011
Great help, job done in a sec... - Anonymous
January 24, 2012
Thanx - helped me out