MSSQLServerOLAPService start request failed

Ever had one of those frustrating problems that eats up days of your time? This is one such nasty.

On a Windows XP laptop here at IPL, we installed SQL Server 2008 R2 Developer Edition. All was fine, until we encountered a problem installing the AdventureWorks databases for SQL Server 2008 R2 (which is another story…). We uninstalled SQL Server, and reinstalled- only to find this problem:

We uninstalled and reinstalled many times, trying various options- and as SQL Server 2008 is a hefty piece of software, you can imagine how much time this took. Google was not the usual help- people had been reporting the problem, but in most cases no-one had replied.

Eventually, we went deeper into Google and found this Connect bug, which Microsoft had helpfully closed as unreproducible. Thankfully, a kind soul called Vinnie has posted a workaround. And it works! Bizarrely, Analysis Services won’t start up because it wants to raise an event but there is no space in the Event Log!

After you get this error, simply go into the Event Log and clear out all your events. Go into SQL Server Configuration Manager, and start up Analysis Services, and you are done.

Advertisements
This entry was posted in Solutions and tagged , , , . Bookmark the permalink.

15 Responses to MSSQLServerOLAPService start request failed

  1. Bill says:

    THANKS! Worked for me, saved me a ton of time no doubt.

  2. zxy says:

    thank you very much! i met same problem and you saved me from frustration

  3. AndyDee says:

    GREAT!!!

  4. MJ says:

    THANK YOU!!

  5. Rowshan Kibria says:

    Thank u very much. u make me relieve.. God bless you.

  6. SRS says:

    Another Happy Camper! Thank you for the fix!

  7. Jason Long says:

    Wow!!! Thank you sooo much for posting this! I’ve been banging my head against the wall trying to figure this out. I went through 2 install/re-installs trying to figure this out. I don’t think there was a chance in hell of me figuring this one out on my own.
    Anyway, it worked like a charm and I’m a happy man! Again, THANK YOU!!!

  8. Ashish says:

    THanks.

  9. Peter says:

    Wow, what a bizarre problem and solution. I’ve been beating my head against the wall all day with this one (including several Removal and Installs). Thanks !

  10. hlkjhlkjhl says:

    Yesss ! Thanks tooooo !

  11. hlkjhlkjhl says:

    Thanks !!! worked for me too !

    Roger

  12. Isaac says:

    Amazing!!! Thanks amigo!!!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s