With SharePoint 2010 SP1 and SQL Server 2008 R2 (CU6 at the time) with Database Engine, SQLServer Reporting Services, and PowerPivot, I ran into the following error:
![clip_image002[6][3]](http://sharepoint.nauplius.net/wp-content/uploads/2011/07/clip_image00263.jpg)
Clicking OK would exit the installation process. Modifying the following value fixed the issue:
HKLM\Software\Microsoft\Microsoft SQL Server\100\ConfigurationState and change Analysis_Server_SPI to “1” to fix the “[Analysis_Server_SPI,]” error. To fix the PowerPivot error, modify HKLM\Software\Microsoft\Microsoft SQL Server\MSAS10_50.POWERPIVOT\ConfigurationState and change “Analysis_Server_Full” to “1”. In my case, the data was “2”
It works, thank you!!!
Thomas
This works great for me as well !!! THX a Lot !!!
Werner
Webkatalog München
There was a failure of installing a part of analysis server, after that W. update could not setup sql 2008 r2 sp1.
I set
HKLMSoftwareMicrosoftMicrosoft SQL ServerMSAS10_50.(the instancename without paranthesis)UpgradeInCompleteStateAnalysis_Server_Full
to 1. Its value was zero before.
the Windows update worked.
I use Windows XP proffessional
Nice and elegant solution.
I've tested it just about now on SQL Server 2008 R2 Developers Edition x64.
And one important thing:
I highly recommend THIS approach vs. Microsoft official response on the subject – they suggested to actually delete instance manually.
I'm fed up over the years with the INCOMPETENT "professionals" working in Microsoft. They don't learn their own technology.
Cool solution.
Tested Win7x64, SQL 2008 R2 Developer X64.
Worked for me. I had several entries under: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\ConfigurationState and under:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
Setting all of them to “1″ resolved the SP installation trouble.
Thanx, could fix the same issue with this solution.