Udostępnij za pośrednictwem


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