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

丁8241

　　(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
                              http://i3.social.s-msft.com/Forums/resources/images/trans.gif?cver=3145.5%0d%0ahttp://i3.social.s-msft.com/Forums/resources/images/trans.gif?cver=3145.5%0d%0a
  
  
  
  　　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:
  
  
  
  
  • Go to the GAC folder "C:\Windows\assembly"
    
  • Find the assemblies "System"
    
  • 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:
  
  
  
  
  • Install the Microsoft .NET framework 4.0
    
  • 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