`
Joson_Coney
  • 浏览: 57209 次
  • 性别: 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 企业版 绿色版 v1.4

    "sql2008R264位管理器"指的是SQL Server Management Studio(SSMS),这是一个集成的环境,用于管理和开发SQL Server的所有方面,包括数据库、SQL Server代理、复制、Integration Services、Reporting Services和...

    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的支持。本文将深入探讨如何解决这个问题,...

    sql2008R2驱动包

    而"sql2008R2驱动包"则指的是用于连接Java应用程序与SQL Server 2008 R2数据库的驱动程序。这个驱动包主要包含两个文件:sqljdbc.jar和sqljdbc4.jar,它们是Microsoft提供的Java Database Connectivity (JDBC) 驱动...

    sqlserver2008r2卸载工具包

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

    sqlServer2008R2简装版本

    sql server2008R2简装版本 1、打开安装包,点击setup.exe 2、选择左侧列表中的“安装 3、点击“全新安装或向现有安装添加功能”。 4、检测完成点击确定。 5、选择版本和密钥,然后下一步。(因为有版权要求,在这不...

    英文版SQL server2008R2.zip

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

    sql server2008 r2 sp1 补丁包

    SQL Server 2008R2 SP1 KB2528583 补丁 数据库 windows 数据库

    sqlserver2008R2应用添加实例步骤

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

    Microsoft SQL Server 2008 R2 SP1 Native Client

    适用 SQL Server Native Client 的这个可转散发安装程序会安装运行时间期间需要的客户端组件,以利用 SQL Server 2008 新功能,并选择性地安装开发使用 SQL Server Native Client API 之应用程序时所需要的头文件。

    sqlserver 2008R2的jdbcjar包

    sqlserver 2008R2的工具jar包,在学习或者工作中jar包是连接sqlserver 2008R2的纽带,比如JAVA举例,在编码中如果不导入这个jar包,会爆出很多的错误,

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

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

    SQLServer2008R2主从数据库同步

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

    SQL2008 R2 绿色版 免安装

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

    JDBC连接SQL Server 2008 R2的驱动

    标题中的“JDBC连接SQL Server 2008 R2的驱动”指的是使用Java数据库连接(JDBC)技术与Microsoft SQL Server 2008 R2数据库进行交互所需的驱动程序。JDBC是Java平台的标准接口,它允许Java应用程序与各种类型的...

    SQL Server 2008 R2开启数据库的远程连接及客户端配置

    1. 打开 sql2008,使用 windows 身份登录 2. 登录后,右击数据库服务器选择“方面” 3. 在右侧的方面下拉框中选择“服务器配置”;将“RemoteAccessEnabled”属性设为“True”,点“确定” 4. 右击数据库服务器选择...

    SQL Server 2008 R2 Datacenter简体中文数据中心版

    ]SQL Server 2008 R2 Datacenter简体中文版 SQL Server 2008 R2 Datacenter简体中文版(MSDN版)[在MSDN I TELL YOU网站是找不到的] 文件名:cn_sql_server_2008_r2_datacenter_x86_x64_ia64_dvd_522245.iso SHA1:...

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

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

    绿色版sql2008r2+管理器

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

Global site tag (gtag.js) - Google Analytics