Share via


An error occurred creating the configuration section handler for userSettings/Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings

You may receive the below error message while installing Microsoft® SQL Server® 2008 R2 Setup

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.

As per the fusion log:

The operation failed.
Bind result: hr = 0x80070002. The system cannot find the file specified.

I launched the Setup in debugger and captured a crash dump.  I found the following information from the crash dump:

0:000> kpnL50
# ChildEBP RetAddr 
00 0017e788 771066c9 ntdll!KiFastSystemCallRet(void)
01 0017e78c 04bc8e08 user32!NtUserWaitMessage(void)+0xc
02 0017e820 04bc88f7 System_Windows_Forms_ni!System.Windows.Forms.Application+ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(<HRESULT 0x80004001>)+0x3c8
03 0017e878 04bc8741 System_Windows_Forms_ni!System.Windows.Forms.Application+ThreadContext.RunMessageLoopInner(<HRESULT 0x80004001>)+0x177
04 0017e8a8 050de597 System_Windows_Forms_ni!System.Windows.Forms.Application+ThreadContext.RunMessageLoop(<HRESULT 0x80004001>)+0x61
05 0017e8c0 05112d98 System_Windows_Forms_ni!System.Windows.Forms.Application.RunDialog(<HRESULT 0x80004001>)+0x33
06 0017e94c 05112faf System_Windows_Forms_ni!System.Windows.Forms.Form.ShowDialog(<HRESULT 0x80004001>)+0x370
07 0017e98c 050df6f2 System_Windows_Forms_ni!System.Windows.Forms.Form.ShowDialog(<HRESULT 0x80004001>)+0x7
08 0017e98c 050e80c6 System_Windows_Forms_ni!System.Windows.Forms.Application+ThreadContext.OnThreadException(<HRESULT 0x80004001>)+0xd2
09 0017e998 050eab4c System_Windows_Forms_ni!System.Windows.Forms.Control.WndProcException(<HRESULT 0x80004001>)+0x16
0a 0017ea54 04bb8512 System_Windows_Forms_ni!System.Windows.Forms.Control+ControlNativeWindow.OnThreadException(<HRESULT 0x80004001>)+0xc
0b 0017ea54 002b0a34 System_Windows_Forms_ni!System.Windows.Forms.NativeWindow.Callback(<HRESULT 0x80004001>)+0x72

0:000> !pe
Exception object: 01d017bc
Exception type: System.Configuration.ConfigurationErrorsException
Message: 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.
InnerException: System.IO.FileNotFoundException, use !PrintException 01cf2048 to see more
StackTrace (generated):
    SP       IP       Function
    0017E5A0 6423FA81 System_Configuration_ni!System.Configuration.BaseConfigurationRecord.FindAndEnsureFactoryRecord(System.String, Boolean ByRef)+0x111
    0017E658 6423F8C8 System_Configuration_ni!System.Configuration.BaseConfigurationRecord.GetSectionRecursive(System.String, Boolean, Boolean, Boolean, Boolean, System.Object ByRef, System.Object ByRef)+0x598
    0017E6F0 6423F309 System_Configuration_ni!System.Configuration.BaseConfigurationRecord.GetSection(System.String, Boolean, Boolean)+0x39
    0017E70C 6423F2B9 System_Configuration_ni!System.Configuration.BaseConfigurationRecord.GetSection(System.String)+0x9
    0017E710 64233821 System_Configuration_ni!System.Configuration.ClientConfigurationSystem.System.Configuration.Internal.IInternalConfigSystem.GetSection(System.String)+0x41
    0017E724 64242B4F System_Configuration_ni!System.Configuration.ConfigurationManager.GetSection(System.String)+0x4f
    0017E730 79900220 System_ni!System.Configuration.ClientSettingsStore.ReadSettings(System.String, Boolean)+0xa0
    0017E770 798DAB09 System_ni!System.Configuration.LocalFileSettingsProvider.GetPropertyValues(System.Configuration.SettingsContext, System.Configuration.SettingsPropertyCollection)+0x79
    0017E7C4 798DA9B3 System_ni!System.Configuration.SettingsBase.GetPropertiesFromProvider(System.Configuration.SettingsProvider)+0x103
    0017E800 798FF815 System_ni!System.Configuration.SettingsBase.GetPropertyValueByName(System.String)+0x85
    0017E814 798FF73B System_ni!System.Configuration.SettingsBase.get_Item(System.String)+0x3b
    0017E844 798FF5C7 System_ni!System.Configuration.ApplicationSettingsBase.GetPropertyValue(System.String)+0x37
    0017E858 798FF53B System_ni!System.Configuration.ApplicationSettingsBase.get_Item(System.String)+0x3b
   0017E888 005D547A LandingPage!Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings.get_WindowPlacement()+0x12
    0017E898 005D1704 LandingPage!Microsoft.SqlServer.Configuration.LandingPage.LandingPageForm.OnLoad(System.EventArgs)+0x54
    0017E8D4 04BC4145 System_Windows_Forms_ni!System.Windows.Forms.Form.OnCreateControl()+0x55
    0017E8E0 04BB6D71 System_Windows_Forms_ni!System.Windows.Forms.Control.CreateControl(Boolean)+0x181
    0017E91C 04BB6B74 System_Windows_Forms_ni!System.Windows.Forms.Control.CreateControl()+0x24
    0017E934 04BC3008 System_Windows_Forms_ni!System.Windows.Forms.Control.WmShowWindow(System.Windows.Forms.Message ByRef)+0x98
    0017E970 04BB8966 System_Windows_Forms_ni!System.Windows.Forms.Control.WndProc(System.Windows.Forms.Message ByRef)+0x2b6
    0017E9C8 04BC1DAA System_Windows_Forms_ni!System.Windows.Forms.ScrollableControl.WndProc(System.Windows.Forms.Message ByRef)+0x2a
    0017E9D4 04BC1D60 System_Windows_Forms_ni!System.Windows.Forms.ContainerControl.WndProc(System.Windows.Forms.Message ByRef)+0x10
    0017E9DC 04BC2F51 System_Windows_Forms_ni!System.Windows.Forms.Form.WmShowWindow(System.Windows.Forms.Message ByRef)+0x41
    0017E9EC 04BC1B34 System_Windows_Forms_ni!System.Windows.Forms.Form.WndProc(System.Windows.Forms.Message ByRef)+0x154
    0017EA00 04BB86A0 System_Windows_Forms_ni!System.Windows.Forms.Control+ControlNativeWindow.OnMessage(System.Windows.Forms.Message ByRef)+0x10
    0017EA08 04BB8621 System_Windows_Forms_ni!System.Windows.Forms.Control+ControlNativeWindow.WndProc(System.Windows.Forms.Message ByRef)+0x31
    0017EA1C 04BB84FA System_Windows_Forms_ni!System.Windows.Forms.NativeWindow.Callback(IntPtr, Int32, IntPtr, IntPtr)+0x5a

StackTraceString: <none>
HResult: 80131902
0:000> !do 01d017bc
Name: System.Configuration.ConfigurationErrorsException
MethodTable: 64246b18
EEClass: 642127dc
Size: 92(0x5c) bytes
(C:\Windows\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll)
Fields:
      MT    Field   Offset                 Type VT     Attr    Value Name
788d0d28  40000b5        4        System.String  0 instance 01d0d690 _className
788d019c  40000b6        8 ...ection.MethodBase  0 instance 00000000 _exceptionMethod
788d0d28  40000b7        c        System.String  0 instance 00000000 _exceptionMethodString
788d0d28  40000b8       10        System.String  0 instance 01d01c30 _message
788ca684  40000b9       14 ...tions.IDictionary  0 instance 00000000 _data
788d0ebc 40000ba 18 System.Exception 0 instance 01cf2048 _innerException
788d0d28  40000bb       1c        System.String  0 instance 00000000 _helpURL
788d0944  40000bc       20        System.Object  0 instance 01d023e0 _stackTrace
788d0d28  40000bd       24        System.String  0 instance 00000000 _stackTraceString
788d0d28  40000be       28        System.String  0 instance 00000000 _remoteStackTraceString
788d2f74  40000bf       34         System.Int32  1 instance        0 _remoteStackIndex
788d0944  40000c0       2c        System.Object  0 instance 00000000 _dynamicMethods
788d2f74  40000c1       38         System.Int32  1 instance -2146232062 _HResult
788d0d28  40000c2       30        System.String  0 instance 00000000 _source
788d35f0  40000c3       3c        System.IntPtr  1 instance        0 _xptrs
788d2f74  40000c4       40         System.Int32  1 instance -532459699 _xcode
788d0d28  400315d       44        System.String  0 instance 00000000 _filename
788d2f74  400315e       48         System.Int32  1 instance        0 _line
788d0d28  4000253       4c        System.String  0 instance 01cd4434 _firstFilename
788d2f74  4000254       54         System.Int32  1 instance        5 _firstLine
00000000  4000255       50              SZARRAY  0 instance 00000000 _errors

0:000> !do 01cf2048
Name: System.IO.FileNotFoundException
MethodTable: 788b7638
EEClass: 78684310
Size: 84(0x54) bytes
(C:\Windows\assembly\GAC_32\mscorlib\2.0.0.0__b77a5c561934e089\mscorlib.dll)
Fields:
      MT    Field   Offset                 Type VT     Attr    Value Name
788d0d28  40000b5        4        System.String  0 instance 00000000 _className
788d019c  40000b6        8 ...ection.MethodBase  0 instance 00000000 _exceptionMethod
788d0d28  40000b7        c        System.String  0 instance 00000000 _exceptionMethodString
788d0d28  40000b8       10        System.String  0 instance 01cf24b8 _message
788ca684  40000b9       14 ...tions.IDictionary  0 instance 00000000 _data
788d0ebc  40000ba       18     System.Exception  0 instance 00000000 _innerException
788d0d28  40000bb       1c        System.String  0 instance 00000000 _helpURL
788d0944  40000bc       20        System.Object  0 instance 01cf29ec _stackTrace
788d0d28  40000bd       24        System.String  0 instance 00000000 _stackTraceString
788d0d28  40000be       28        System.String  0 instance 00000000 _remoteStackTraceString
788d2f74  40000bf       34         System.Int32  1 instance        0 _remoteStackIndex
788d0944  40000c0       2c        System.Object  0 instance 00000000 _dynamicMethods
788d2f74  40000c1       38         System.Int32  1 instance -2147024894 _HResult
788d0d28  40000c2       30        System.String  0 instance 00000000 _source
788d35f0  40000c3       3c        System.IntPtr  1 instance        0 _xptrs
788d2f74  40000c4       40         System.Int32  1 instance -532459699 _xcode
788d0d28  4001bb3       44        System.String  0 instance 00000000 _maybeFullPath
788d0d28  4001bcf       48        System.String  0 instance 01cf15f8 _fileName
788d0d28  4001bd0       4c        System.String  0 instance 01cf169c _fusionLog

0:000> !do 01cf24b8
Name: System.String
MethodTable: 788d0d28
EEClass: 7868d66c
Size: 698(0x2ba) bytes
(C:\Windows\assembly\GAC_32\mscorlib\2.0.0.0__b77a5c561934e089\mscorlib.dll)
String: 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.
Fields:
      MT    Field   Offset                 Type VT     Attr    Value Name
788d2f74  4000096        4         System.Int32  1 instance      341 m_arrayLength
788d2f74  4000097        8         System.Int32  1 instance      178 m_stringLength
788d1a08  4000098        c          System.Char  1 instance       43 m_firstChar
788d0d28  4000099       10        System.String  0   shared   static Empty
    >> Domain:Value  00375b90:01b51198 <<
788d1958  400009a       14        System.Char[]  0   shared   static WhitespaceChars
    >> Domain:Value  00375b90:01b51720 <<

I found that there was an invalid entry in the userSettings section of the Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings file. So the resolution was to delete this configuartion file or delete the folder "Microsoft_Corporation". Since it is a cached copy location, there is no harm in doing it. In order to resolve the issue, try running the command: rd /s /q %localappdata%\Microsoft_Corporation

Comments

  • Anonymous
    March 20, 2014
    Thanks a lot! I was blocked due to this error.

  • Anonymous
    March 20, 2014
    Thanks a lot, this was helping me in fixing this issue.

  • Anonymous
    March 22, 2014
    Thanks very much. This certainly helped me. Too bad the product creates such cryptic messages. One would think that the programmers when creating the error traps would do a better job of also showing a solution. In my case the reason for the files sitting there was from a previous "un-installation" of SQL Express 2008.

  • Anonymous
    April 08, 2014
    Thanks! This saved me from a lot of indiscriminate file removal.

  • Anonymous
    May 23, 2014
    Thanks very much - this solved a similar problem for me too :-)

  • Anonymous
    June 15, 2014
    Thanks!  Solved mine too. :)

  • Anonymous
    August 05, 2014
    Thanks a lot dude! This tip resolved my issue!!!

  • Anonymous
    August 25, 2014
    Thanks,It worked out.

  • Anonymous
    August 26, 2014
    And worked for me. Well done Soumitra, and thaks

  • Anonymous
    September 30, 2014
    Thanks for the helpful tip!

  • Anonymous
    October 09, 2014
    Perfect! You made another SysAdmin happy today :o) tnx a lot!

  • Anonymous
    November 04, 2014
    Hey Soumitra, Thank You so much, it helped us in resolving this issue within no time.

  • Anonymous
    November 05, 2014
    The comment has been removed

  • Anonymous
    January 25, 2015
    The path is slightly different for a Windows 2012 R2 server loading SQL Server 2012 ("...appdatalocal..."), but the resolution is the same: Success! Thanks for the tip.

  • Anonymous
    January 31, 2015
    (y) Thanks :)

  • Anonymous
    February 13, 2015
    This fix did not work for me. I continue to receive the error even after I delete the file. Any suggestions?

  • Anonymous
    February 13, 2015
    Please look at the fusion log. If needed capture a crash dump as well.

  • Anonymous
    March 10, 2015
    Thank you for this solution. It worked perfectly.

  • Anonymous
    March 17, 2015
    Create, it worked!

  • Anonymous
    May 28, 2015
    Great , it works for me thanks man

  • Anonymous
    August 04, 2015
    Thanks worked. Was also uninstalled problem.

  • Anonymous
    August 23, 2015
    i have same problem but your solution do not help me out, I'm still getting that error in my win 8.1 64 bit cmd saya parameters incorrect or not valid path help out please and send me solution ASAP on my email id- pt1382203@apiit.edu.in thanks if u do thiis

  • Anonymous
    August 23, 2015
    Please open a support case with Microsoft for further troubleshooting support.microsoft.com/en-us

  • Anonymous
    November 20, 2015
    Thanks a lot... now its working

  • Anonymous
    April 19, 2016
    I am having the same problem what pc says pls help me once

  • Anonymous
    August 11, 2016
    thanks a lot ! mine has been solved!