`
Joson_Coney
  • 浏览: 57466 次
  • 性别: Icon_minigender_1
  • 来自: 广州
社区版块
存档分类
最新评论

【转】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)

 

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
    Avatar of Jinchun Chen
    Microsoft
    (MSFT)
    22,848 Points
     AnswerHas Code

    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

分享到:
评论

相关推荐

    SQL Server 2008 R2 Enterprise (SP3) 企业版 绿色版,解决部分电脑无法安装数据库的问题

    SQL Server 2008 R2 Enterprise (SP3) 企业版 绿色版,解决部分电脑无法安装数据库的问题 由于SQL Server 安装对电脑环境要求很高,有些电脑安装一半断电或者提示错误都会导致数据库无法继续安装。只能重装系统。 ...

    Microsoft SQL Server 2008 R2 SP3 简体中文功能包.rar

    Windows 7, Windows 8, Windows 8.1, Windows Server 2003, Windows Server 2008, Windows Server 2008 R2, Windows Vista, Windows XP 注: 每个功能包的系统要求都依赖于所需的技术。 在重新分发功能包时,请...

    解决WinServer2012操作系统安装 SQLServer2008R2失败,需要打sxs补丁

    在Windows Server 2012操作系统中安装SQL Server 2008 R2时,可能会遇到一些问题,导致安装过程失败。这个问题通常与系统组件的缺失有关,特别是针对.NET Framework 3.5的支持。本文将深入探讨如何解决这个问题,...

    sqlserver2008r2卸载工具包

    它包含了专门的卸载脚本和指南,帮助用户安全、完整地从Windows操作系统中移除SQL Server 2008 R2的所有相关组件。在使用这个工具包之前,建议先备份重要的数据和系统设置,以防意外丢失。 在使用这个工具包时,你...

    英文版SQL server2008R2.zip

    SQL Server 2008 R2是微软公司推出的一款企业级关系型数据库管理系统,它在SQL Server 2008的基础上进行了诸多改进和增强,旨在提供更高效、更安全的数据管理和分析能力。作为一款广泛应用于企业的数据库解决方案,...

    sqlserver2008R2应用添加实例步骤

    ### SQL Server 2008 R2 添加实例的详细步骤 #### 一、概述 SQL Server 2008 R2 是一款强大的关系型数据库管理系统,广泛应用于企业级数据管理和处理场景。对于需要在同一台服务器上运行多个独立的SQL Server环境...

    从SQL Server 2000升级至SQL Server 2008 R2实验手册

    ### 从SQL Server 2000升级至SQL Server 2008 R2的关键知识点 #### 一、系统及浏览器需求 - **操作系统要求**: - Windows XP SP3 及其以上版本 - Windows Vista SP1 及其以上版本 - Windows 7 - Windows 2008 ...

    SQL SERVER 2008 R2群集SP2补丁升级(WINDOWS 2003)操作手册

    SQL SERVER 2008 R2群集SP2补丁升级(WINDOWS 2003)操作手册SQL SERVER 2008 R2群集SP2补丁升级(WINDOWS 2003)操作手册SQL SERVER 2008 R2群集SP2补丁升级(WINDOWS 2003)操作手册

    SQLServer2008R2主从数据库同步

    ### SQL Server 2008 R2 主从数据库同步知识点详解 #### 一、环境准备与用户设置 在实现SQL Server 2008 R2的主从数据库同步之前,首先需要确保主从服务器的基本环境配置一致,并创建必要的用户及权限。 **主...

    SqlServer2008R2下载地址

    SqlServer2008R2下载地址,记事本打开

    sql server 2008 r2 express包含管理工具、手册,开发必备

    2. **SQLServer2008R2_BOL_CHS.msi**:这个文件则是SQL Server 2008 R2的联机丛书(Books Online,简称BOL)。这是一份详尽的文档资源,包含了关于SQL Server的所有技术信息,包括概念性概述、教程、参考和指南,...

    SQL2008 R2 绿色版 免安装

    SQL2008 R2是微软公司开发的一款关系型数据库管理系统,属于SQL Server系列的其中一员。这个“SQL2008 R2 绿色版 免安装”版本是针对那些希望快速部署和使用的用户设计的,无需进行常规的安装步骤,可以节省时间和...

    绿色版sql2008r2+管理器

    绿色精简版的sql server 2008r2及sql管理工具,可指定数据库实例名及端口,不过在已经安装完整版的sql server的系统中容易出现问题。建议只在未安装sql server的系统中做开发测试使用,不建议正式使用。

    超好用的SQL2008R2绿色版

    "超好用的SQL2008R2绿色版"标题表明这是一个针对SQL Server 2008 R2的特别版本,通常绿色版指的是便携式、免安装的软件版本,它无需复杂的安装过程,方便用户快速启动和使用。 描述中提到,该版本是SQL Server 2008...

    Microsoft SQL Server 2008 R2 Management Studio Express

    Microsoft SQL Server 2008 R2 Management Studio Express (SSMSE) 是一个集成环境,用于访问、配置、管理和开发所有 SQL Server Express 组件。

    Sql server 2008 r2 各版本序列号

    Sql server 2008 r2 ,亲测可用,全版本序列号.

    JAVA连接sqlserver2008R2驱动sqljdbc4-3.0.jar

    在Java编程环境中,连接SQL Server 2008 R2数据库通常需要依赖特定的数据库驱动。在本例中,我们使用的驱动是`sqljdbc4-3.0.jar`,这是微软提供的Java Database Connectivity (JDBC) 驱动,允许Java应用程序与SQL ...

    SQL Server 2008 r2 中文版SP3补丁的缺陷补丁(修补级别:10.53.6000.34)

    只有SQL Server 2008 出了SP4补丁。该补丁并不支持 SQL Server 2008 R2 版本的升级。 当 SQL Server 2008 R2 版本升级到 Service Pack 3后,存在一个缺陷,需要安装(10.53.6000.34补丁)。

    SQLServer2008R2简体中文版(64位)

    Microsoft SQL Server 2008 R2 提供完整的企业级技术与工具,帮助您以最低的总拥有成本获得最有价值的信息。您可以充分享受高性能,高可用性,高安全性,使用更多的高效管理与开发工具,利用自服务的商业智能实现...

Global site tag (gtag.js) - Google Analytics