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.

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. Mazen says:

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

  2. maziar bijari says:

    thank you very much,your way is very cool

  3. SteveH says:

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

  4. neeraj says:

    awesome man

    very good.

    keep it up.

    helped me a lot.

  5. Deepak Rai says:

    Thanks man. It worked for me. Great Job.

  6. suresh says:

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

  7. Junior says:

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

  8. PopH says:

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

  9. Haven 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.


  10. reddappa says:

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

  11. Jean says:

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

  12. Natalia Pavlova says:


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

  13. joan repil says:

    very helpful!! thank you thank you!

  14. Ravi Dinavahi says:

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

  15. Carl says:

    This worked like a charm. Thank you OP!

  16. Moodey 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. Harsh says:

    Awsome… Gr8 work

  18. Arun Kumar says:

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

  19. Shashwat says:

    Worked for me… Thanks alot

  20. JE says:

    Great help, job done in a sec…

  21. Gerry says:

    Thanx – helped me out

Skip to main content