none
启动sql2016安装程序报错 RRS feed

  • Question

  • windows2012R2服务器上已经安装了sql2014的数据库实例,另外新增安装sql2016实例时报如下错误,且在使用sql2014sp3升级包升级已存在实例时同样报以上错误,不知如何排查了,请教该如何分析呢,谢谢

    SQL Server Setup has encountered the following error: Failed to retrieve data for this request.. For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&EvtType=0xE8A0C283%25400xAC7B1A58%25401233%254053 ------------------------------ BUTTONS: OK ------------------------------


    Sunday, October 13, 2019 4:08 AM

Answers

  • Hi JHT793,

     

    你这台服务器是群集中的一个节点把,建议你启用remote registry service在尝试安装

     

     

     

     

    Best regards,

    Dedmon Dai


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Marked as answer by JHT793 Tuesday, October 15, 2019 8:39 AM
    Tuesday, October 15, 2019 3:04 AM

All replies

  • Hi JHT793,

     

    请你将安装日志中的错误信息展示出来方便我们进一步分析,安装日志的默认地址:C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\Summary.txt

     

    Best regards,

    Dedmon Dai


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, October 14, 2019 2:58 AM
  • 谢谢,请帮忙给分析一下,谢谢
    Overall summary:
      Final result:                  Failed: see details below
      Exit code (Decimal):           -2146233088
      Exit facility code:            19
      Exit error code:               5376
      Exit message:                  Failed to retrieve data for this request.
      Start time:                    2019-10-14 16:53:20
      End time:                      2019-10-14 16:53:44
      Requested action:              Install
      Exception help link:           http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.1601.5&EvtType=0xE8A0C283%400xAC7B1A58%401233%4053&EvtType=0xE8A0C283%400xAC7B1A58%401233%4053
    Machine Properties:
      Machine name:                  SPOADB11
      Machine processor count:       40
      OS version:                    Microsoft Windows Server 2012 R2 Standard (6.3.9600)
      OS service pack:              
      OS region:                     United States
      OS language:                   English (United States)
      OS architecture:               x64
      Process architecture:          64 Bit
      OS clustered:                  Yes
    Product features discovered:
      Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered  Configured
      SQL Server 2014      MSSQLSERVER          MSSQL12.MSSQLSERVER            Database Engine Services                 1033                 Enterprise Edition   12.1.4237.0     No         Yes      
      SQL Server 2014      MSSQLSERVER          MSSQL12.MSSQLSERVER            SQL Server Replication                   1033                 Enterprise Edition   12.1.4237.0     No         Yes      
      SQL Server 2014      MSSQLSERVER          MSSQL12.MSSQLSERVER            Full-Text and Semantic Extractions for Search 1033                 Enterprise Edition   12.0.2000.8     No         Yes      
      SQL Server 2014      MSSQLSERVER          MSSQL12.MSSQLSERVER            Data Quality Services                    1033                 Enterprise Edition   12.1.4237.0     No         Yes      
      SQL Server 2014                                                          SSMS                                     1033                 Enterprise Edition   12.1.4237.0     No         Yes      
      SQL Server 2014                                                          Adv_SSMS                                 1033                 Enterprise Edition   12.1.4237.0     No         Yes      
      SQL Server 2014                                                          Client Tools Connectivity                1033                 Enterprise Edition   12.1.4237.0     No         Yes      
      SQL Server 2014                                                          Client Tools Backwards Compatibility     1033                 Enterprise Edition   12.1.4237.0     No         Yes      
      SQL Server 2014                                                          Client Tools SDK                         1033                 Enterprise Edition   12.1.4237.0     No         Yes      
      SQL Server 2014                                                          Data Quality Client                      1033                 Enterprise Edition   12.1.4237.0     No         Yes      
      SQL Server 2014                                                          Integration Services                     1033                 Enterprise Edition   12.1.4237.0     No         Yes      
      SQL Server 2014                                                          Reporting Services - SharePoint                                                    12.1.4237.0     No         Yes      
      SQL Server 2014                                                          Master Data Services                     1033                 Enterprise Edition   12.1.4100.1     No         Yes      
    Package properties:
      Description:                   Microsoft SQL Server 2016
      ProductName:                   SQL Server 2016
      Type:                          RTM
      Version:                       13
      SPLevel:                       0
      Installation location:         C:\SQL2016\sql2016\x64\setup\
      Installation edition:          Enterprise
    Product Update Status:
      None discovered.
    User Input Settings:
      ACTION:                        Install
      ADDCURRENTUSERASSQLADMIN:      false
      AGTSVCACCOUNT:                 <empty>
      AGTSVCPASSWORD:                <empty>
      AGTSVCSTARTUPTYPE:             Manual
      ASBACKUPDIR:                   Backup
      ASCOLLATION:                   Latin1_General_CI_AS
      ASCONFIGDIR:                   Config
      ASDATADIR:                     Data
      ASLOGDIR:                      Log
      ASPROVIDERMSOLAP:              1
      ASSERVERMODE:                  MULTIDIMENSIONAL
      ASSVCACCOUNT:                  <empty>
      ASSVCPASSWORD:                 <empty>
      ASSVCSTARTUPTYPE:              Automatic
      ASSYSADMINACCOUNTS:            <empty>
      ASTELSVCACCT:                  <empty>
      ASTELSVCPASSWORD:              <empty>
      ASTELSVCSTARTUPTYPE:           0
      ASTEMPDIR:                     Temp
      BROWSERSVCSTARTUPTYPE:         Disabled
      CLTCTLRNAME:                   <empty>
      CLTRESULTDIR:                  <empty>
      CLTSTARTUPTYPE:                0
      CLTSVCACCOUNT:                 <empty>
      CLTSVCPASSWORD:                <empty>
      CLTWORKINGDIR:                 <empty>
      COMMFABRICENCRYPTION:          0
      COMMFABRICNETWORKLEVEL:        0
      COMMFABRICPORT:                0
      CONFIGURATIONFILE:            
      CTLRSTARTUPTYPE:               0
      CTLRSVCACCOUNT:                <empty>
      CTLRSVCPASSWORD:               <empty>
      CTLRUSERS:                     <empty>
      ENABLERANU:                    false
      ENU:                           true
      EXTSVCACCOUNT:                 <empty>
      EXTSVCPASSWORD:                <empty>
      FEATURES:                     
      FILESTREAMLEVEL:               0
      FILESTREAMSHARENAME:           <empty>
      FTSVCACCOUNT:                  <empty>
      FTSVCPASSWORD:                 <empty>
      HELP:                          false
      IACCEPTROPENLICENSETERMS:      false
      INDICATEPROGRESS:              false
      INSTALLSHAREDDIR:              D:\sql\
      INSTALLSHAREDWOWDIR:           D:\sql_x86\
      INSTALLSQLDATADIR:             <empty>
      INSTANCEDIR:                   C:\Program Files\Microsoft SQL Server\
      INSTANCEID:                    <empty>
      INSTANCENAME:                  <empty>
      ISSVCACCOUNT:                  NT AUTHORITY\Network Service
      ISSVCPASSWORD:                 <empty>
      ISSVCSTARTUPTYPE:              Automatic
      ISTELSVCACCT:                  <empty>
      ISTELSVCPASSWORD:              <empty>
      ISTELSVCSTARTUPTYPE:           0
      MATRIXCMBRICKCOMMPORT:         0
      MATRIXCMSERVERNAME:            <empty>
      MATRIXNAME:                    <empty>
      MRCACHEDIRECTORY:             
      NPENABLED:                     0
      PBDMSSVCACCOUNT:               <empty>
      PBDMSSVCPASSWORD:              <empty>
      PBDMSSVCSTARTUPTYPE:           0
      PBENGSVCACCOUNT:               <empty>
      PBENGSVCPASSWORD:              <empty>
      PBENGSVCSTARTUPTYPE:           0
      PBPORTRANGE:                   <empty>
      PBSCALEOUT:                    false
      PID:                           *****
      QUIET:                         false
      QUIETSIMPLE:                   false
      ROLE:                         
      RSINSTALLMODE:                 DefaultNativeMode
      RSSHPINSTALLMODE:              DefaultSharePointMode
      RSSVCACCOUNT:                  <empty>
      RSSVCPASSWORD:                 <empty>
      RSSVCSTARTUPTYPE:              Automatic
      SAPWD:                         <empty>
      SECURITYMODE:                  <empty>
      SQLBACKUPDIR:                  <empty>
      SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS
      SQLSVCACCOUNT:                 <empty>
      SQLSVCINSTANTFILEINIT:         false
      SQLSVCPASSWORD:                <empty>
      SQLSVCSTARTUPTYPE:             Automatic
      SQLSYSADMINACCOUNTS:           <empty>
      SQLTELSVCACCT:                 <empty>
      SQLTELSVCPASSWORD:             <empty>
      SQLTELSVCSTARTUPTYPE:          0
      SQLTEMPDBDIR:                  <empty>
      SQLTEMPDBFILECOUNT:            0
      SQLTEMPDBFILEGROWTH:           -1
      SQLTEMPDBFILESIZE:             -1
      SQLTEMPDBLOGDIR:               <empty>
      SQLTEMPDBLOGFILEGROWTH:        -1
      SQLTEMPDBLOGFILESIZE:          -1
      SQLUSERDBDIR:                  <empty>
      SQLUSERDBLOGDIR:               <empty>
      SUPPRESSPRIVACYSTATEMENTNOTICE: false
      TCPENABLED:                    0
      UIMODE:                        Normal
      UpdateEnabled:                 true
      UpdateSource:                  MU
      USEMICROSOFTUPDATE:            false
      X86:                           false
      Configuration file:            C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20191014_165319\ConfigurationFile.ini
    Rules with failures:
    Global rules:
    Scenario specific rules:
    Rules report file:               The rule result report file is not available.
    Exception summary:
    The following is an exception stack listing the exceptions in outermost to innermost order
    Inner exceptions are being indented
    Exception type: Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorException
        Message:
            Failed to retrieve data for this request.
        HResult : 0x80131500
        Data:
          HelpLink.ProdName = Microsoft SQL Server
          HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink
          HelpLink.LinkId = 20476
          HelpLink.EvtType = 0xE8A0C283@0xAC7B1A58@1233@53
          DisableWatson = true
        Stack:
            at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryDatastoreInterface.LoadData(IEnumerable`1 machineNames, String discoveryDocRootPath, String clusterDiscoveryDocRootPath)
            at Microsoft.SqlServer.Configuration.SetupExtension.RunDiscoveryAction.ExecuteAction(String actionId)
            at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
            at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.<>c__DisplayClasse.<ExecuteActionWithRetryHelper>b__b()
            at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)
        Inner exception type: Microsoft.SqlServer.Configuration.Sco.SqlRegistryException
            Message:
                    The network path was not found.
                   
            HResult : 0x84d10035
                    FacilityCode : 1233 (4d1)
                    ErrorCode : 53 (0035)
            Data:
              WatsonData = Microsoft.SqlServer.Configuration.Sco.SqlRegistryException@Win32Error
            Stack:
                    at Microsoft.SqlServer.Configuration.Sco.SqlRegistry.CreateBaseKey(ServiceContainer ctx, String machineName, IntPtr hKey, String keyName, RegistryAccess access, RegistryView view)
                    at Microsoft.SqlServer.Configuration.Sco.SqlRegistry.GetLocalMachine(ServiceContainer ctx, String machineName, RegistryAccess access, RegistryView view)
                    at Microsoft.SqlServer.Discovery.DiscoveryUtils.Util.GetLocalMachineRootKey(ServiceContainer ctx, String machineName, RegistryView registryView)
                    at Microsoft.SqlServer.Discovery.DiscoveryUtils.Util.GetLocalMachineSubKey(ServiceContainer ctx, String machineName, RegistryView regView, String regPath, RegistryAccess registryAccess)
                    at Microsoft.SqlServer.Discovery.RegistryKeyExistsPropertyValueProvider.GetPropertyValue(Object[] context)
                    at Microsoft.SqlServer.Discovery.DiscoveryEnumObject.GetPropertyValueFromProvider(IPropertyValueProvider propertyValueProvider, String machineName, Object[] context)
                    at Microsoft.SqlServer.Discovery.ObjectInstanceSettings.IsObjectFound(String machineName, String idFilter)
                    at Microsoft.SqlServer.Discovery.Product.FilterObjectSet(ArrayList objects, String idFilter)
                    at Microsoft.SqlServer.Discovery.Product.GetData(EnumResult erParent)
                    at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData()
                    at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData(Request req, Object ci)
                    at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object connectionInfo, Request request)
                    at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)
    Tuesday, October 15, 2019 2:23 AM
  • Hi JHT793,

     

    你这台服务器是群集中的一个节点把,建议你启用remote registry service在尝试安装

     

     

     

     

    Best regards,

    Dedmon Dai


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Marked as answer by JHT793 Tuesday, October 15, 2019 8:39 AM
    Tuesday, October 15, 2019 3:04 AM
  • This thread should Ideally be moved to forum having Chinese language

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Tuesday, October 15, 2019 6:56 AM
    Moderator
  • 谢谢,原因已经找到就是这个remote registry 服务在集群内没有开启,导致一台无法查找到另一台的信息,导致无法启动安装程序,感觉
    Tuesday, October 15, 2019 8:39 AM
  • 另外建议这个是英文论坛,如果你发中文,其他人看不懂,建议以后用英文提问。

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Tuesday, October 15, 2019 8:42 AM