Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Can't Install SQL Server 2008 R2 Express

I have a problem with installing SQL Server 2008 R2 Express.

On my computer, I have installed VC# and VWebdev 2010 express. It included SQL Server 2008 Express inside.

After that, I did an upgrade to SQL Server 2008 R2 Express.

The consequence is I can't connect to a local server itself. So, I uninstall all of SQLServer products and reinstall again. Then an error message pops up on my screen which is pasted on the end of this question.

My computer runs on Win7 x64. SQL Server installer is a 64-bit version. My System.dll, which I think a root of this problem, assembly is 2.0.0.0 version.

The error message:

System.Configuration.ConfigurationErrorsException: 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:\Users\BenZ\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\10.0.0.0\user.config line 5) ---> System.IO.FileNotFoundException: 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. File name: 'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' at System.Configuration.TypeUtil.GetTypeWithReflectionPermission(IInternalConfigHost host, String typeString, Boolean throwOnError) at System.Configuration.RuntimeConfigurationRecord.RuntimeConfigurationFactory.Init(RuntimeConfigurationRecord configRecord, FactoryRecord factoryRecord) at System.Configuration.RuntimeConfigurationRecord.RuntimeConfigurationFactory.InitWithRestrictedPermissions(RuntimeConfigurationRecord configRecord, FactoryRecord factoryRecord) at System.Configuration.RuntimeConfigurationRecord.CreateSectionFactory(FactoryRecord factoryRecord) at System.Configuration.BaseConfigurationRecord.FindAndEnsureFactoryRecord(String configKey, Boolean& isRootDeclaredHere)

like image 375
Pipat Methavanitpong Avatar asked Nov 20 '10 14:11

Pipat Methavanitpong


2 Answers

Deleting the user.config file mentioned in the error message resolves this.

Full path:

%USERPROFILE%\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\10.0.0.0\user.config

Note: I am using Windows 7 Ultimate (64 bit) . First I have uninstalled Visual Studio 2010, then I deleted user.config from the above path.

like image 77
Ankur Avatar answered Sep 20 '22 15:09

Ankur


I have found that if I press a close button on the right top of the error message box, it will jump to a normal installation screen.

The installation is successful now. I finally can connect to a server by SQL Server Management Studio. But I still wonder what will be coming after this.

like image 38
Pipat Methavanitpong Avatar answered Sep 18 '22 15:09

Pipat Methavanitpong