SQL Server 2008 R2 : install mess

Back in 2008 I wrote an article about “reboot check” error with installer.

Now it is time to mention another situation – total failure of installing SQL Server 2008 R2 on the machine with prior installation of SQL Server 2008. Please note that if you work with Visual Studio 2010 you would most likely get express edition unless declined during install. I do not know for sure if it is related but… just happened to be that after doing unrelated reinstall of VS 2010 I have to reinstall SQL Server 2008 R2 Dev build on the same machine as well.

Fan started when installer refused to be applied on top of existing installation, nice and very informative error about with 2 pages of debug data would appear…

An error occurred creating the configuration section handler for …

Per MSDN Blog, the following solution was suggested – Delete Microsoft Folder in user’s Application Data Folder.

PS: Do not forget to make a registry backup before the doing anything suggested below

OK, then we get to the next hurdle and this is actually more complex… During deployment of actual components error dialog pops up similar to this

After few attempts to fix it, I have stumbled on this nice article. Brace yourself to a long read, attempts to solve errors one by one, or just scroll to the end and just restore registry to its default state for permissions with

If this still fails, consider resetting registry permissions back to the
default settings using the following command:

secedit /configure /cfg %windir%\inf\defltbase.inf /db defltbase.sdb /verbose /areas REGKEYS

This nice little thing will solve all the mysteries…

Enjoy

This entry was posted in Fun stuff with SQL Server and tagged , , , . Bookmark the permalink.

Leave a Reply

  • About

    From being a junior developer all the way to Development Manager position, I was always interested in new technologies. Passionate speaker, IT junky, developer, architect, team lead, and development manager - many hats, one goal - making software better and closer to people’s needs. For the most part I am using my blog as a scratch pad, writing small articles on things which I came across, was asked about more then once, and which would otherwise require additional research again and again.

    View Serguei Dosyukov's profile on LinkedIn
  • Testimonials

    I’m a huge fan of this theme. I’ve got more than 90,000 pictures in my gallery3 running on a Ubuntu...

    Jklobo

    I've been using this [theme] since the start. It is by far the most attractive, feature packed and stable of...

    Rhyull

    The greydragon theme is fantastic. It’s clean, stable and feature rich. It took me a while to decide to move...

    Ed

    more...

  • Categories