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 (21)

  1. Anonymous says:

    Good stuff. it took me 5 hours to find that out

  2. Anonymous says:

    thank you very much,your way is very cool

  3. Anonymous says:

    Thanks – was stressing about not getting past that error!!

  4. Anonymous says:

    awesome man

    very good.

    keep it up.

    helped me a lot.

  5. Anonymous says:

    Thanks man. It worked for me. Great Job.

  6. Anonymous says:

    just awesome! you made my day! thank you so much! it worked like champ!

  7. Anonymous says:

    Man you saved my life!!! I was stuck for over a week with this problem, tanks

  8. Anonymous says:

    Thank you for the info…worked on this all weekend and your fix did the trick. Keep up the great postings.

  9. Anonymous says:

    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,

  10. Anonymous says:

    Great!!! I am on stand alone. This worked for me. But little curious to the info SINGLESERVER vs APPLICATION.

  11. Anonymous says:

    Yep!! Thanks a lot! I was getting crazy with this stupid install process!

  12. Anonymous says:

    Thanks!!

    i have this error in Sharepoint 2010 and this helps! thanks

  13. Anonymous says:

    very helpful!! thank you thank you!

  14. Anonymous says:

    Akshay, my friend……you kicked my day off with this little and beautiful solution. I owe you one.

  15. Anonymous says:

    This worked like a charm. Thank you OP!

  16. Anonymous says:

    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.

  17. Anonymous says:

    Awsome… Gr8 work

  18. Anonymous says:

    Awesome. It worked great.. Hats off to you man..!!

  19. Anonymous says:

    Worked for me… Thanks alot

  20. Anonymous says:

    Great help, job done in a sec…

  21. Anonymous says:

    Thanx – helped me out