如何在Sql Server 2012中修复这些错误 [英] How Do I Fix These Errors In Sql Server 2012

查看:382
本文介绍了如何在Sql Server 2012中修复这些错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我试图在Windows 8中安装sql server 2012 express后得到这个结果帮我在我的电脑上安装无错误的sql server 2012 :(



< pre lang =HTML> < blockquote class = FQ < span class =code-keyword>> < div class = FQA > 引用:< / div > 总体摘要:
最终结果:失败:请参阅以下详细信息
退出代码(十进制): - 2068578302
开始时间:2014-02-21 01:48:56
结束时间:2014-02-21 01:59:34
请求的操作:修复

安装完成后需要功能的动作。
这些功能的故障排除信息:
SQLEngine的下一步:使用以下信息解决错误,然后再次尝试设置过程。
DQ的下一步:使用以下信息解决错误,然后再次尝试设置过程。
FullText的下一步:使用以下信息解决错误,然后再次尝试设置过程。
复制的下一步:使用以下信息解决错误,然后再次尝试设置过程。
RS的下一步:使用以下信息解决错误,然后再次尝试设置过程。


机器属性:
机器名称:BAJPANGOSH
机器处理器数量:4
操作系统版本:未来Windows版本
OS服务包:
操作系统区域:美国
操作系统语言:英语(美国)
操作系统架构:x64
流程架构:64位
操作系统群集:否

发现的产品功能:
产品实例实例ID功能语言版本群集
SQL Server 2012 MSSQLSERVER MSSQL11.MSSQLSERVER数据库引擎服务1033企业版:基于核心的许可11.1.3128.0否
SQL Server 2012 MSSQLSERVER MSSQL11.MSSQLSERVER SQL Server R. eplication 1033企业版:基于核心的许可11.1.3128.0否
SQL Server 2012 MSSQLSERVER MSSQL11.MSSQLSERVER搜索1033企业版的全文和语义提取:基于核心的许可11.1.3000.0否
SQL Server 2012 MSSQLSERVER MSSQL11.MSSQLSERVER数据质量服务1033企业版:基于核心的许可11.1.3000.0否
SQL Server 2012 MSSQLSERVER MSAS11.MSSQLSERVER Analysis Services 1033企业版:基于核心的许可11.1.3128.0否
SQL Server 2012 MSSQLSERVER MSRS11.MSSQLSERVER Reporting Services - Native 1033 11.1.3128.0 No
SQL Server 2012管理工具 - 基本1033企业版:基于核心的许可11.1.3128.0否
SQL Server 2012管理工具 - 完整1033企业版:基于核心的许可11.1.3128.0否
SQL Server 2012客户端工具连接1033企业版:基于核心的许可11.1.3128.0否
SQL Server 2012 Integration Services 1033企业版:基于核心的许可11.1.3128.0否
SQL Server 2012 LocalDB 1033 Express Edition 11.1.3000.0否

包装特性es:
描述:Microsoft SQL Server 2012 Service Pack 1
ProductName:SQL Server 2012
类型:RTM
版本:11
SPLevel:0
安装位置:G:\New文件夹\ serverqlgt \ x64 \setup \
安装版:企业版:基于核心的许可

用户输入设置:
操作:修复
AGTDOMAINGROUP:< >
AGTSVCACCOUNT:< empty >
AGTSVCPASSWORD:< empty >
AGTSVCSTARTUPTYPE:手动
ASCONFIGDIR:配置
ASSVCACCOUNT:NT服务\ MSSQLServerOLAPService
ASSVCPASSWORD:< empty >
CLTSTARTUPTYPE:0
CLTSVCACCOUNT:< >
CLTSVCPASSWORD:< >
CONFIGURATIONFILE:C:\Program Files \ Microsoft SQL Server \110\Setup Bootstrap\Log\20140221_014759\ConfigurationFile.ini
CTLRSTARTUPTYPE:0
CTLRSVCACCOUNT:< >
CTLRSVCPASSWORD:< >
ENU:true
FAILOVERCLUSTERGROUP: < >
FAILOVERCLUSTERNETWORKNAME:< >
FTSVCACCOUNT:NT服务\ MSSQLFDLauncher
FTSVCPASSWORD:< empty >
HELP:false
IACCEPTSQLSERVERLICENSETERMS:false
INDICATEPROGRESS:false
INSTANCENAME:MSSQLSERVER
I SSVCACCOUNT:NT Service\MsDtsServer110
ISSVCPASSWORD:< empty >
ISSVCSTARTUPTYPE:自动
QUIET:false
QUIETSIMPLE:false
SQLSVCACCOUNT:NT Service \ MSSQLSERVER
SQLSVCPASSWORD:< >
UIMODE :正常
X86:false

配置文件:C:\Program Files \ Microsoft SQL Server \110\Setup Bootstrap\Log\20140221_014759\ConfigurationFile.ini

总体结果:
特点:管理工具 - 完成
状态:已通过

功能:客户端工具连接
状态:通过

功能:管理工具 - 基本
状态:通过

功能:SQL Server数据工具
状态:已通过

功能:数据库引擎服务
状态:失败:请参阅日志以获取详细信息
失败原因:功能设置过程中出错。
下一步:使用以下信息解决错误,然后再次尝试设置过程。
组件名称:SQL Server数据库引擎服务实例功能
组件错误代码:0x84B40002
错误说明:SQL Server功能SQL_Engine_Core_Inst未处于受支持状态以进行修复,因为它从不已成功配置。只能修复成功安装的功能。要继续,请删除指定的SQL Server功能。
错误帮助链接:http://go.microsoft.com/fwlink?LinkId = 20476& ProdName = Microsoft + SQL + Server& EvtSrc = setup.rll& EvtID = 50000& ProdVer = 11.0.3128.0& EvtType = 0x2841E06E%401204%402& EvtType = 0x2841E06E%401204%402

功能:数据质量服务
状态:失败:请参阅日志以获取详细信息
失败原因:发生错误对于功能的依赖性导致功能的设置过程失败。
下一步:使用以下信息解决错误,然后再次尝试设置过程。
组件名称:SQL Server数据库引擎服务实例功能
组件错误代码:0x84B40002
错误说明:SQL Server功能SQL_Engine_Core_Inst未处于受支持状态以进行修复,因为它从不已成功配置。只能修复成功安装的功能。要继续,请删除指定的SQL Server功能。
错误帮助链接:http://go.microsoft.com/fwlink?LinkId = 20476& ProdName = Microsoft + SQL + Server& EvtSrc = setup.rll& EvtID = 50000& ProdVer = 11.0.3128.0& EvtType = 0x2841E06E%401204%402& EvtType = 0x2841E06E%401204%402

功能:搜索的全文和语义提取
状态:失败:请参阅日志以获取详细信息
原因: failure:该功能的依赖项发生错误,导致该功能的安装过程失败。
下一步:使用以下信息解决错误,然后再次尝试设置过程。
组件名称:SQL Server数据库引擎服务实例功能
组件错误代码:0x84B40002
错误说明:SQL Server功能SQL_Engine_Core_Inst未处于受支持状态以进行修复,因为它从不已成功配置。只能修复成功安装的功能。要继续,请删除指定的SQL Server功能。
错误帮助链接:http://go.microsoft.com/fwlink?LinkId = 20476& ProdName = Microsoft + SQL + Server& EvtSrc = setup.rll& EvtID = 50000& ProdVer = 11.0.3128.0& EvtType = 0x2841E06E%401204%402& EvtType = 0x2841E06E%401204%402

功能:SQL Server复制
状态:失败:请参阅日志以获取详细信息
失败原因:发生错误对于功能的依赖性导致功能的设置过程失败。
下一步:使用以下信息解决错误,然后再次尝试设置过程。
组件名称:SQL Server数据库引擎服务实例功能
组件错误代码:0x84B40002
错误说明:SQL Server功能SQL_Engine_Core_Inst未处于受支持状态以进行修复,因为它从不已成功配置。只能修复成功安装的功能。要继续,请删除指定的SQL Server功能。
错误帮助链接:http://go.microsoft.com/fwlink?LinkId = 20476& ProdName = Microsoft + SQL + Server& EvtSrc = setup.rll& EvtID = 50000& ProdVer = 11.0.3128.0& EvtType = 0x2841E06E%401204%402& EvtType = 0x2841E06E%401204%402

功能:Integration Services
状态:已通过

功能:Reporting Services - Native
状态:失败:有关详细信息,请参阅日志
失败原因:功能设置过程中出错。
下一步:使用以下信息解决错误,然后再次尝试设置过程。
组件名称:SQL Server Reporting Services
组件错误代码:0x84B40002
错误说明:SQL Server功能RS_Server_Adv未处于受支持的状态以进行修复,因为它从未成功配置。只能修复成功安装的功能。要继续,请删除指定的SQL Server功能。
错误帮助链接:http://go.microsoft.com/fwlink?LinkId = 20476& ProdName = Microsoft + SQL + Server& EvtSrc = setup.rll& EvtID = 50000& ProdVer = 11.0.3128.0& EvtType = 0x2841E06E%401204%402& EvtType = 0x2841E06E%401204%402

功能:Analysis Services
状态:已通过

功能:SQL浏览器
状态:通过

功能:文档组件
状态:通过

功能:SQL编写者
状态:通过

功能: LocalDB
状态:通过

功能:SQL客户端连接
状态:通过

功能:SQL客户端连接SDK
状态:通过

功能:数据质量客户端
状态:通过

功能:设置支持文件
状态:通过

失败规则:

全局规则:

没有特定于场景的规则。

规则报告文件:C:\Program Files \ microsoft SQL Server \110\Setup Bootstrap\Log\20140221_014759\SystemConfigurationCheck_Report.htm

在SQL Server上配置设置时遇到以下警告。这些资源/设置已丢失或无效,因此在重新创建缺少的资源时使用了默认值。请检查以确保它们不需要为您的应用程序进一步自定义:

在系统上找不到SQL Server Browser服务。安装程序将其启动类型配置为已禁用。
在系统上找不到SQL Server Browser服务。安装程序将其启动类型配置为已禁用。
在系统上找不到SQL Server Browser服务。安装程序将其启动类型配置为已禁用。
< / blockquote >

解决方案

请参考以下内容:

安装SQL Server 2012的硬件和软件要求 [ ^ ]

从安装向导(安装程序)安装SQL Server 2012 [ ^ ]

安装SQL Server 2012 [ ^ ]

SQL Server 2012安装指南 [ ^ ]


am trying to install sql server 2012 express in windows 8 after i got this result help me to install error free sql server 2012 on my computer :(

<blockquote class="FQ"><div class="FQA">Quote:</div>Overall summary:
  Final result:                  Failed: see details below
  Exit code (Decimal):           -2068578302
  Start time:                    2014-02-21 01:48:56
  End time:                      2014-02-21 01:59:34
  Requested action:              Repair

Setup completed with required actions for features.
Troubleshooting information for those features:
  Next step for SQLEngine:       Use the following information to resolve the error, and then try the setup process again.
  Next step for DQ:              Use the following information to resolve the error, and then try the setup process again.
  Next step for FullText:        Use the following information to resolve the error, and then try the setup process again.
  Next step for Replication:     Use the following information to resolve the error, and then try the setup process again.
  Next step for RS:              Use the following information to resolve the error, and then try the setup process again.


Machine Properties:
  Machine name:                  BAJPANGOSH
  Machine processor count:       4
  OS version:                    Future Windows Version
  OS service pack:               
  OS region:                     United States
  OS language:                   English (United States)
  OS architecture:               x64
  Process architecture:          64 Bit
  OS clustered:                  No

Product features discovered:
  Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered 
  SQL Server 2012      MSSQLSERVER          MSSQL11.MSSQLSERVER            Database Engine Services                 1033                 Enterprise Edition: Core-based Licensing 11.1.3128.0     No        
  SQL Server 2012      MSSQLSERVER          MSSQL11.MSSQLSERVER            SQL Server Replication                   1033                 Enterprise Edition: Core-based Licensing 11.1.3128.0     No        
  SQL Server 2012      MSSQLSERVER          MSSQL11.MSSQLSERVER            Full-Text and Semantic Extractions for Search 1033                 Enterprise Edition: Core-based Licensing 11.1.3000.0     No        
  SQL Server 2012      MSSQLSERVER          MSSQL11.MSSQLSERVER            Data Quality Services                    1033                 Enterprise Edition: Core-based Licensing 11.1.3000.0     No        
  SQL Server 2012      MSSQLSERVER          MSAS11.MSSQLSERVER             Analysis Services                        1033                 Enterprise Edition: Core-based Licensing 11.1.3128.0     No        
  SQL Server 2012      MSSQLSERVER          MSRS11.MSSQLSERVER             Reporting Services - Native              1033                                      11.1.3128.0     No        
  SQL Server 2012                                                          Management Tools - Basic                 1033                 Enterprise Edition: Core-based Licensing 11.1.3128.0     No        
  SQL Server 2012                                                          Management Tools - Complete              1033                 Enterprise Edition: Core-based Licensing 11.1.3128.0     No        
  SQL Server 2012                                                          Client Tools Connectivity                1033                 Enterprise Edition: Core-based Licensing 11.1.3128.0     No        
  SQL Server 2012                                                          Integration Services                     1033                 Enterprise Edition: Core-based Licensing 11.1.3128.0     No        
  SQL Server 2012                                                          LocalDB                                  1033                 Express Edition      11.1.3000.0     No        

Package properties:
  Description:                   Microsoft SQL Server 2012 Service Pack 1
  ProductName:                   SQL Server 2012
  Type:                          RTM
  Version:                       11
  SPLevel:                       0
  Installation location:         G:\New folder\sql servergt\x64\setup\
  Installation edition:          Enterprise Edition: Core-based Licensing

User Input Settings:
  ACTION:                        Repair
  AGTDOMAINGROUP:                <empty>
  AGTSVCACCOUNT:                 <empty>
  AGTSVCPASSWORD:                <empty>
  AGTSVCSTARTUPTYPE:             Manual
  ASCONFIGDIR:                   Config
  ASSVCACCOUNT:                  NT Service\MSSQLServerOLAPService
  ASSVCPASSWORD:                 <empty>
  CLTSTARTUPTYPE:                0
  CLTSVCACCOUNT:                 <empty>
  CLTSVCPASSWORD:                <empty>
  CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20140221_014759\ConfigurationFile.ini
  CTLRSTARTUPTYPE:               0
  CTLRSVCACCOUNT:                <empty>
  CTLRSVCPASSWORD:               <empty>
  ENU:                           true
  FAILOVERCLUSTERGROUP:          <empty>
  FAILOVERCLUSTERNETWORKNAME:    <empty>
  FTSVCACCOUNT:                  NT Service\MSSQLFDLauncher
  FTSVCPASSWORD:                 <empty>
  HELP:                          false
  IACCEPTSQLSERVERLICENSETERMS:  false
  INDICATEPROGRESS:              false
  INSTANCENAME:                  MSSQLSERVER
  ISSVCACCOUNT:                  NT Service\MsDtsServer110
  ISSVCPASSWORD:                 <empty>
  ISSVCSTARTUPTYPE:              Automatic
  QUIET:                         false
  QUIETSIMPLE:                   false
  SQLSVCACCOUNT:                 NT Service\MSSQLSERVER
  SQLSVCPASSWORD:                <empty>
  UIMODE:                        Normal
  X86:                           false

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

Detailed results:
  Feature:                       Management Tools - Complete
  Status:                        Passed

  Feature:                       Client Tools Connectivity
  Status:                        Passed

  Feature:                       Management Tools - Basic
  Status:                        Passed

  Feature:                       SQL Server Data Tools
  Status:                        Passed

  Feature:                       Database Engine Services
  Status:                        Failed: see logs for details
  Reason for failure:            An error occurred during the setup process of the feature.
  Next Step:                     Use the following information to resolve the error, and then try the setup process again.
  Component name:                SQL Server Database Engine Services Instance Features
  Component error code:          0x84B40002
  Error description:             The SQL Server feature 'SQL_Engine_Core_Inst' is not in a supported state for repair, as it was never successfully configured. Only features from successful installations can be repaired. To continue, remove the specified SQL Server feature.
  Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.3128.0&EvtType=0x2841E06E%401204%402&EvtType=0x2841E06E%401204%402

  Feature:                       Data Quality Services
  Status:                        Failed: see logs for details
  Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
  Next Step:                     Use the following information to resolve the error, and then try the setup process again.
  Component name:                SQL Server Database Engine Services Instance Features
  Component error code:          0x84B40002
  Error description:             The SQL Server feature 'SQL_Engine_Core_Inst' is not in a supported state for repair, as it was never successfully configured. Only features from successful installations can be repaired. To continue, remove the specified SQL Server feature.
  Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.3128.0&EvtType=0x2841E06E%401204%402&EvtType=0x2841E06E%401204%402

  Feature:                       Full-Text and Semantic Extractions for Search
  Status:                        Failed: see logs for details
  Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
  Next Step:                     Use the following information to resolve the error, and then try the setup process again.
  Component name:                SQL Server Database Engine Services Instance Features
  Component error code:          0x84B40002
  Error description:             The SQL Server feature 'SQL_Engine_Core_Inst' is not in a supported state for repair, as it was never successfully configured. Only features from successful installations can be repaired. To continue, remove the specified SQL Server feature.
  Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.3128.0&EvtType=0x2841E06E%401204%402&EvtType=0x2841E06E%401204%402

  Feature:                       SQL Server Replication
  Status:                        Failed: see logs for details
  Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
  Next Step:                     Use the following information to resolve the error, and then try the setup process again.
  Component name:                SQL Server Database Engine Services Instance Features
  Component error code:          0x84B40002
  Error description:             The SQL Server feature 'SQL_Engine_Core_Inst' is not in a supported state for repair, as it was never successfully configured. Only features from successful installations can be repaired. To continue, remove the specified SQL Server feature.
  Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.3128.0&EvtType=0x2841E06E%401204%402&EvtType=0x2841E06E%401204%402

  Feature:                       Integration Services
  Status:                        Passed

  Feature:                       Reporting Services - Native
  Status:                        Failed: see logs for details
  Reason for failure:            An error occurred during the setup process of the feature.
  Next Step:                     Use the following information to resolve the error, and then try the setup process again.
  Component name:                SQL Server Reporting Services
  Component error code:          0x84B40002
  Error description:             The SQL Server feature 'RS_Server_Adv' is not in a supported state for repair, as it was never successfully configured. Only features from successful installations can be repaired. To continue, remove the specified SQL Server feature.
  Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.3128.0&EvtType=0x2841E06E%401204%402&EvtType=0x2841E06E%401204%402

  Feature:                       Analysis Services
  Status:                        Passed

  Feature:                       SQL Browser
  Status:                        Passed

  Feature:                       Documentation Components
  Status:                        Passed

  Feature:                       SQL Writer
  Status:                        Passed

  Feature:                       LocalDB
  Status:                        Passed

  Feature:                       SQL Client Connectivity
  Status:                        Passed

  Feature:                       SQL Client Connectivity SDK
  Status:                        Passed

  Feature:                       Data Quality Client
  Status:                        Passed

  Feature:                       Setup Support Files
  Status:                        Passed

Rules with failures:

Global rules:

There are no scenario-specific rules.

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

The following warnings were encountered while configuring settings on your SQL Server.  These resources / settings were missing or invalid so default values were used in recreating the missing resources.  Please review to make sure they don’t require further customization for your applications:

The SQL Server Browser service was not found on the system. Setup will configure its startup type to 'Disabled'.
The SQL Server Browser service was not found on the system. Setup will configure its startup type to 'Disabled'.
The SQL Server Browser service was not found on the system. Setup will configure its startup type to 'Disabled'.
</blockquote>

解决方案

Please refer these:
Hardware and Software Requirements for Installing SQL Server 2012[^]
Install SQL Server 2012 from the Installation Wizard (Setup)[^]
Install SQL Server 2012[^]
SQL Server 2012 Installation Guide[^]


这篇关于如何在Sql Server 2012中修复这些错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆