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=22.214.171.124, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified. (C:\Users\eli\ AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccgl axmt4nhllj5z3thycltsvyyx\10.0.0.0\user.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:
- Quit the installer, if you press the Continue button it will just continue to fail, so don’t bother.
- Go to your app data directory by going to start > run > %appdata%
- This will by default take you to the “roaming” folder, go up one directory and move into the “Local” folder.
- Go to the “Microsoft_Corporation” folder
- 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:
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.
- Re-run the installer – it should run with no problems this time around.
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…