【转】SQL 2008 R2 problems on a Windows 2008 R2 Enterprise server

(From: http://social.msdn.microsoft.com/Forums/en/sqlsetupandupgrade/thread/99ee7868-4b0b-4379-82fb-95004d376c86)

 

vonryman

We are receiving the following error message when installing SQL 2008 R2 on a Windows 2008 R2 Enterprise server. "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.

 

Here is the details to the error message above.

See the end of this message for details on invoking

just-in-time (JIT) debugging instead of this dialog box.

 

************** Exception Text **************

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\kachampongadmin\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)

 

WRN: Assembly binding logging is turned OFF.

To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.

Note: There is some performance penalty associated with assembly bind failure logging.

To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

 

   --- End of inner exception stack trace ---

   at System.Configuration.BaseConfigurationRecord.FindAndEnsureFactoryRecord(String configKey, Boolean& isRootDeclaredHere)

   at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)

   at System.Configuration.BaseConfigurationRecord.GetSection(String configKey)

   at System.Configuration.ClientConfigurationSystem.System.Configuration.Internal.IInternalConfigSystem.GetSection(String sectionName)

   at System.Configuration.ConfigurationManager.GetSection(String sectionName)

   at System.Configuration.ClientSettingsStore.ReadSettings(String sectionName, Boolean isUserScoped)

   at System.Configuration.LocalFileSettingsProvider.GetPropertyValues(SettingsContext context, SettingsPropertyCollection properties)

   at System.Configuration.SettingsBase.GetPropertiesFromProvider(SettingsProvider provider)

   at System.Configuration.SettingsBase.GetPropertyValueByName(String propertyName)

   at System.Configuration.SettingsBase.get_Item(String propertyName)

   at System.Configuration.ApplicationSettingsBase.GetPropertyValue(String propertyName)

   at System.Configuration.ApplicationSettingsBase.get_Item(String propertyName)

   at Microsoft.SqlServer.Configuration.LandingPage.LandingPageForm.OnLoad(EventArgs e)

   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)

   at System.Windows.Forms.Control.CreateControl()

   at System.Windows.Forms.Control.WmShowWindow(Message& m)

   at System.Windows.Forms.Control.WndProc(Message& m)

   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

 

 

************** Loaded Assemblies **************

mscorlib

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.4952 (win7RTMGDR.050727-4900)

    CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll

----------------------------------------

LandingPage

    Assembly Version: 10.0.0.0

    Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1539 )

    CodeBase: file:///D:/SQL%202008/x64/LandingPage.exe

----------------------------------------

System.Windows.Forms

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)

    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

----------------------------------------

System

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)

    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

----------------------------------------

System.Drawing

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)

    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

----------------------------------------

Microsoft.SqlServer.Configuration.Sco

    Assembly Version: 10.0.0.0

    Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1539 )

    CodeBase: file:///D:/SQL%202008/x64/Microsoft.SqlServer.Configuration.Sco.DLL

----------------------------------------

Microsoft.SqlServer.Chainer.Infrastructure

    Assembly Version: 10.0.0.0

    Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1539 )

    CodeBase: file:///D:/SQL%202008/x64/Microsoft.SqlServer.Chainer.Infrastructure.DLL

----------------------------------------

System.Xml

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)

    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll

----------------------------------------

Accessibility

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)

    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll

----------------------------------------

Microsoft.SqlServer.Management.Controls

    Assembly Version: 10.0.0.0

    Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1539 )

    CodeBase: file:///D:/SQL%202008/x64/Microsoft.SqlServer.Management.Controls.DLL

----------------------------------------

System.Configuration

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)

    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

----------------------------------------

 

************** JIT Debugging **************

To enable just-in-time (JIT) debugging, the .config file for this

application or computer (machine.config) must have the

jitDebugging value set in the system.windows.forms section.

The application must also be compiled with debugging

enabled.

 

For example:

 

<configuration>

    <system.windows.forms jitDebugging="true" />

</configuration>

 

When JIT debugging is enabled, any unhandled exception

will be sent to the JIT debugger registered on the computer

rather than be handled by this dialog box.

 

---

It specialist

Answers

• Saturday, September 11, 2010 8:53 AM

  Jinchun Chen

  Microsoft

  (MSFT)

  22,848 Points

   

  Hi vonryman,

  From the following message, we can know the issue is caused by that the LandingPage is trying to find the assembly 'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089', however the assembly is missing from Global Assemblies Control(GAC).

  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. 
  

  The cause the assemly is missing may be that the .NET framework 4.0 is uninstalled. To verify this issue, we can:

  1. Go to the GAC folder "C:\Windows\assembly"
  2. Find the assemblies "System"
  3. Make sure there is a "System" assembly with version 4.0.0.0

  I assume the "System" assembly with version 4.0.0.0 is missing in this case.

  Here are two solutions to solve the issue:

  1. Install the Microsoft .NET framework 4.0
  2. Modify the user.config file to refer to .NET framework 2.0. (I will attach the user.config which uses .NET framework 2.0 at the end of this post). In this case, the user.config is located in C:\Users\kachampongadmin\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\10.0.0.0

  Microsoft .NET framework 4.0 can be downloaded from: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=0a391abd-25c1-4fc0-919f-b21f31ab88b7
  user.config that is refered to .NET framework 2.0.:

  <?
  xml
   version
  =
  "
  1.0
  "
   encoding
  =
  "
  utf-8
  "
  ?>
  
  <
  configuration
  >
  
   <
  configSections
  >
  
    <sectionGroup name="userSettings" type="System.Configuration.UserSettingsGroup, System, Version=2.0.0.0, Culture=neutral, 
  PublicKeyToken=b77a5c561934e089" >
     <
  section
   name
  =
  "
  Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings
  "
   
  type
  =
  "
  System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
  "
   
  allowExeDefinition
  =
  "
  MachineToLocalUser
  "
   requirePermission
  =
  "
  false
  "
   />
  
    </
  sectionGroup
  >
  
   </
  configSections
  >
  
   <
  userSettings
  >
  
    <
  Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings
  >
  
     <
  setting
   name
  =
  "
  WindowPlacement
  "
   serializeAs
  =
  "
  Xml
  "
  >
  
      <
  value
  >
  
       <
  WINDOWPLACEMENT
   xmlns:xsi
  =
  "
  http://www.w3.org/2001/XMLSchema-instance
  "
  
        xmlns:xsd
  =
  "
  http://www.w3.org/2001/XMLSchema
  "
  >
  
        <
  showCmd
  >
  1</
  showCmd
  >
  
        <
  ptMinPosition
  >
  
         <
  x
  >
  -1</
  x
  >
  
         <
  y
  >
  -1</
  y
  >
  
        </
  ptMinPosition
  >
  
        <
  ptMaxPosition
  >
  
         <
  x
  >
  -1</
  x
  >
  
         <
  y
  >
  -1</
  y
  >
  
        </
  ptMaxPosition
  >
  
        <
  rcNormalPosition
  >
  
         <
  left
  >
  289</
  left
  >
  
         <
  top
  >
  152</
  top
  >
  
         <
  right
  >
  1089</
  right
  >
  
         <
  bottom
  >
  752</
  bottom
  >
  
        </
  rcNormalPosition
  >
  
       </
  WINDOWPLACEMENT
  >
  
      </
  value
  >
  
     </
  setting
  >
  
    </
  Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings
  >
  
   </
  userSettings
  >
  
  </
  configuration
  >
  
  
  

   

  If you have any more questions, please feel free to ask.

  Thanks,
  Jin Chen