Buggy Installers
This is a fun installation problem it almost made me pull my hair out trying to figure it out. Concerning installations I honestly feel that there is nothing worse than an Installer NOT installing! I would rather a program install and not work, rather than have the damn installer fail. Just like Visual Studio 2008 and even Unreal Tournament 2003. Going on a tangent, the installer for UT2K3 was horrendous, if you didn’t switch discs out fast enough and the disc didn’t spin up fast enough the whole installation would fail. Genius… Those installation DVDs were very fickle.

The SQL Server 2008 R2 Installer Error

The Contents of this Error

Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately. 

An error occurred creating the configuration section handler for userSettings/Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings: Could not load file or assembly ‘System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089’ or one of its dependencies. The system cannot find the file specified. (C:UserseliApp DataLocalMicrosoft_CorporationLandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx10.0.0.0user.config line 5).

The Stupid Fix to this Stupid Problem
This is really one of the most annoying installer problems I have ever run into and the stupid fix to this is to:

  1. Quit the installer, if you press the Continue button it will just continue to fail, so don’t bother.
  2. Go to your app data directory by going to start > run > %appdata%
  3. This will by default take you to the “roaming” folder, go up one directory and move into the “Local” folder.
  4. Go to the “Microsoft_Corporation” folder
  5. This next step may seem wrong or dangerous, but honestly if you need to install this, then you have no choice really and I can’t guarantee that this won’t mess something up (I’m like 99.99% sure it won’t).

    You want to delete the folders named:
    • DefaultDomain_Path_………………
    • LandingPage.exe_StrongName_………………..

    All of the dots represent a bunch of alphanumeric characters that really mean nothing to me and I can’t guarantee that they are the same for everyone, so use your imagination. It should look something like “ryspccglaxmt4nhllj5z3thycltsvyyx”. If you are afraid to delete the files, then back them up first if it will make you feel better about deleting something you don’t recognize – I can’t blame you it’s almost like messing with the registry.

  6. Re-run the installer – it should run with no problems this time around.

Conclusion
The most ridiculous part is if you look in that directory after the installation is finished you will notice that the folders are back?! I suspect this whole mess happened because this installer assumed that those folders and files wouldn’t be there, but it wouldn’t overwrite them either. What an annoying error…

26 thoughts on “SQL Server 2008 R2 will not install – Unhandled Exception has occurred in your application.

  1. Hi

    I am unable to find the folder "Microsoft_Corporation"
    The Local folder contains Microsoft and Microsoft help. None of them contain the data as mentioned in step 5.I am using windows server 2008 and installed SQL server 2008R2

    thanks

    1. Are there multiple users on this pc? If so then make sure to check each user's folder just in case. Other than that I am not sure. I encountered this problem on Windows 7. I suggest checking the event viewer after the install fails to see if you find any useful information.

    1. You are very welcome. I just hope they don't do something like this again in the future. I haven't had any experience with the 2012 or 2014 installers yet.

Leave a Reply

Your email address will not be published. Required fields are marked *