SQL Server 2008 R2 SP1 Installation Error 0x84B20001

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]

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”

7 Comments

  1. It works, thank you!!!
    Thomas

  2. This works great for me as well !!! THX a Lot !!!

    Werner
    Webkatalog München

  3. 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

  4. 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.

  5. Cool solution.
    Tested Win7x64, SQL 2008 R2 Developer X64.

  6. 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.

  7. Thanx, could fix the same issue with this solution.

Leave a Reply