none
安装sqlserver2012数据库引擎不成功 RRS feed

  • 问题

  • 在安装sqlserver2012过程中报错,“此访问控制列表格式不规范,因此无法修改。”如下图所示:

    我的操作系统版本windows7 sp1

    搞不清楚,无论如何上传,图片总是这样不能完全显示出来。

    2012年6月29日 6:42

答案

全部回复

  • Which edition of sql2012 did you install? Any details in installation log files?
    2012年6月29日 12:52
  • 在网站上下载的是:SQL Server 2012 Evaluation,安装的时候选择的“指定可用版本”是Evaluation,以下报错的日志:

    Overall summary:
      Final result:                  失败: 请查看下面的详细信息
      Exit code (Decimal):           -2068119551
      Start time:                    2012-06-29 21:56:58
      End time:                      2012-06-29 22:03:05
      Requested action:              Install

    Setup completed with required actions for features.
    Troubleshooting information for those features:
      Next step for SQLEngine:       使用以下信息解决错误,卸载此功能,然后再次运行安装过程。
      Next step for Replication:     使用以下信息解决错误,卸载此功能,然后再次运行安装过程。


    Machine Properties:
      Machine name:                  ibm77
      Machine processor count:       2
      OS version:                    Windows 7
      OS service pack:               Service Pack 1
      OS region:                     中华人民共和国
      OS language:                   中文(中华人民共和国)
      OS architecture:               x86
      Process architecture:          32 位
      OS clustered:                  否

    Product features discovered:
      Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered
      SQL Server 2008      SQLEXPRESS           MSSQL10.SQLEXPRESS             数据库引擎服务                                  1033                 Enterprise Edition   10.3.5500.0     否        
      SQL Server 2008      SQLEXPRESS           MSSQL10.SQLEXPRESS             数据库引擎服务                                  2052                 Enterprise Edition   10.3.5500.0     否        
      SQL Server 2008      SQLEXPRESS           MSSQL10.SQLEXPRESS             SQL Server 复制                            1033                 Enterprise Edition   10.3.5500.0     否        
      SQL Server 2008      SQLEXPRESS           MSSQL10.SQLEXPRESS             SQL Server 复制                            2052                 Enterprise Edition   10.3.5500.0     否        
      SQL Server 2008                                                          管理工具 - 基本                                2052                 Enterprise Edition   10.3.5500.0     否        
      SQL Server 2012      SQLEXPRESS.INACTIVE  MSSQL11.SQLEXPRESS             数据库引擎服务                                  1033                 Enterprise Edition: Core-based Licensing 11.0.2100.60    否        
      SQL Server 2012      SQLEXPRESS.INACTIVE  MSSQL11.SQLEXPRESS             数据库引擎服务                                  2052                 Enterprise Edition: Core-based Licensing 11.0.2100.60    否        
      SQL Server 2012      SQLEXPRESS.INACTIVE  MSSQL11.SQLEXPRESS             SQL Server 复制                            1033                 Enterprise Edition: Core-based Licensing 11.0.2100.60    否        
      SQL Server 2012      SQLEXPRESS.INACTIVE  MSSQL11.SQLEXPRESS             SQL Server 复制                            2052                 Enterprise Edition: Core-based Licensing 11.0.2100.60    否        
      SQL Server 2012                                                          管理工具 - 基本                                2052                 Enterprise Edition: Core-based Licensing 11.0.2100.60    否        

    Package properties:
      Description:                   Microsoft SQL Server 2012
      ProductName:                   SQL Server 2012
      Type:                          RTM
      Version:                       11
      SPLevel:                       0
      Installation location:         E:\TDDOWNLOAD\SQLFULL_x86_CHS\x86\setup\
      Installation edition:          Evaluation

    Product Update Status:
      未发现任何更新。

    用户输入设置:
      ACTION:                        Install
      ADDCURRENTUSERASSQLADMIN:      false
      AGTSVCACCOUNT:                 NT Service\SQLSERVERAGENT
      AGTSVCPASSWORD:                *****
      AGTSVCSTARTUPTYPE:             Manual
      ASBACKUPDIR:                   Backup
      ASCOLLATION:                   Latin1_General_CI_AS
      ASCONFIGDIR:                   Config
      ASDATADIR:                     Data
      ASLOGDIR:                      Log
      ASPROVIDERMSOLAP:              1
      ASSERVERMODE:                  MULTIDIMENSIONAL
      ASSVCACCOUNT:                  <空>
      ASSVCPASSWORD:                 <空>
      ASSVCSTARTUPTYPE:              Automatic
      ASSYSADMINACCOUNTS:            <空>
      ASTEMPDIR:                     Temp
      BROWSERSVCSTARTUPTYPE:         Automatic
      CLTCTLRNAME:                   <空>
      CLTRESULTDIR:                  <空>
      CLTSTARTUPTYPE:                0
      CLTSVCACCOUNT:                 <空>
      CLTSVCPASSWORD:                <空>
      CLTWORKINGDIR:                 <空>
      COMMFABRICENCRYPTION:          0
      COMMFABRICNETWORKLEVEL:        0
      COMMFABRICPORT:                0
      CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20120629_215518\ConfigurationFile.ini
      CTLRSTARTUPTYPE:               0
      CTLRSVCACCOUNT:                <空>
      CTLRSVCPASSWORD:               <空>
      CTLRUSERS:                     <空>
      ENABLERANU:                    false
      ENU:                           false
      ERRORREPORTING:                false
      FEATURES:                      SQLENGINE, REPLICATION
      FILESTREAMLEVEL:               0
      FILESTREAMSHARENAME:           <空>
      FTSVCACCOUNT:                  <空>
      FTSVCPASSWORD:                 <空>
      HELP:                          false
      INDICATEPROGRESS:              false
      INSTALLSHAREDDIR:              C:\Program Files\Microsoft SQL Server\
      INSTALLSHAREDWOWDIR:           <空>
      INSTALLSQLDATADIR:             <空>
      INSTANCEDIR:                   C:\Program Files\Microsoft SQL Server\
      INSTANCEID:                    MSSQLSERVER
      INSTANCENAME:                  MSSQLSERVER
      ISSVCACCOUNT:                  NT AUTHORITY\Network Service
      ISSVCPASSWORD:                 <空>
      ISSVCSTARTUPTYPE:              Automatic
      MATRIXCMBRICKCOMMPORT:         0
      MATRIXCMSERVERNAME:            <空>
      MATRIXNAME:                    <空>
      NPENABLED:                     0
      PID:                           *****
      QUIET:                         false
      QUIETSIMPLE:                   false
      ROLE:                          <空>
      RSINSTALLMODE:                 DefaultNativeMode
      RSSHPINSTALLMODE:              DefaultSharePointMode
      RSSVCACCOUNT:                  <空>
      RSSVCPASSWORD:                 <空>
      RSSVCSTARTUPTYPE:              Automatic
      SAPWD:                         <空>
      SECURITYMODE:                  <空>
      SQLBACKUPDIR:                  <空>
      SQLCOLLATION:                  Chinese_PRC_CI_AS
      SQLSVCACCOUNT:                 NT Service\MSSQLSERVER
      SQLSVCPASSWORD:                <空>
      SQLSVCSTARTUPTYPE:             Automatic
      SQLSYSADMINACCOUNTS:           WEISHENGJI\goldxp
      SQLTEMPDBDIR:                  <空>
      SQLTEMPDBLOGDIR:               <空>
      SQLUSERDBDIR:                  <空>
      SQLUSERDBLOGDIR:               <空>
      SQMREPORTING:                  false
      TCPENABLED:                    1
      UIMODE:                        Normal
      UpdateEnabled:                 true
      UpdateSource:                  MU
      X86:                           false

      Configuration file:            C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20120629_215518\ConfigurationFile.ini

    Detailed results:
      Feature:                       数据库引擎服务
      Status:                        失败: 请查看日志了解详细信息
      Reason for failure:            在此功能的安装过程中出错。
      Next Step:                     使用以下信息解决错误,卸载此功能,然后再次运行安装过程。
      Component name:                SQL Server 数据库引擎服务实例功能
      Component error code:          0x84BB0001
      Error description:             此访问控制列表格式不规范,因此无法修改。
      Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.2100.60&EvtType=0xEE30244D&EvtType=0xEE30244D

      Feature:                       SQL Server 复制
      Status:                        失败: 请查看日志了解详细信息
      Reason for failure:            该功能的某个依赖项出错,导致该功能的安装过程失败。
      Next Step:                     使用以下信息解决错误,卸载此功能,然后再次运行安装过程。
      Component name:                SQL Server 数据库引擎服务实例功能
      Component error code:          0x84BB0001
      Error description:             此访问控制列表格式不规范,因此无法修改。
      Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.2100.60&EvtType=0xEE30244D&EvtType=0xEE30244D

    Rules with failures:

    Global rules:

    Scenario specific rules:

    Rules report file:               C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20120629_215518\SystemConfigurationCheck_Report.htm

    2012年6月29日 14:06
  • Check this link: http://social.msdn.microsoft.com/Forums/zh/sqlexpress/thread/2e3abed4-f7a0-4c71-8d30-58f83d88b990

    Did you logon as local admin? Checked other log files under C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20120629_215518?

    2012年6月29日 15:44
  • 文章看过了,访问权限和安装文件应该没有问题,我使用的是本地管理员账户进行安装的。同样的安装文件有同事安装成功过。其他的日志我应该看哪个呢?以下是文件列表:

    Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_"            
    Registry_SOFTWARE_Microsoft_MSSQLServer.reg_"                     
    Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_"
    Settings.xml"                                                     
    Settings_ComponentUpdate.xml"                                     
    Settings_GlobalRules.xml"                                         
    sql_engine_core_inst_Cpu32_1.log"                                 
    sql_engine_core_inst_loc_Cpu32_2052_1.log"                        
    SqlSupport_KatmaiRTM_Cpu32_1.log"                                 
    Summary_ibm77_20120629_215518.txt"                           
    Summary_ibm77_20120629_215518_ComponentUpdate.txt"           
    Summary_ibm77_20120629_215518_GlobalRules.txt"               
    SystemConfigurationCheck_Report.htm"                              
    ibm77_20120629_215518_Watson.txt"                            
    Datastore"                                                        
    Datastore_ComponentUpdate"                                        
    Datastore_GlobalRules"                                            
    resources"                                                        
    Watson_4"                                                         
    ConfigurationFile.ini"                                            
    Detail.txt"                                                       
    Detail_ComponentUpdate.txt"                                       
    Detail_GlobalRules.txt"                                           
    LogSet_ibm77_20120629_215518.cab"                            


    2012年6月30日 1:13
  • Check .log and .txt files.
    2012年6月30日 3:09
  • 这位高人,能不能给我留一个邮箱,我把相关日志发给你,帮给看看,个人能力有限,没看出什么门道。谢谢
    2012年6月30日 4:26
  • 你好,

    请问在安装SQL Server 2012是选择的service account是那些? 在选择这些 service account 时,可以参考下下面帖子。

    http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/be49f504-2bae-4df1-8f6b-42a7658dc893/

    Thanks.


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

    2012年7月2日 3:22
    版主
  • LZ也是图片不能显示出来,我也是这样的情况,不知道论坛怎麽搞的?

    给我写信: QQ我:点击这里给我发消息

    2012年7月2日 8:27