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.