启动sql2016安装程序报错

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 ------------------------------

Answer 1

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 [e-mail]

Answer 2

谢谢，请帮忙给分析一下，谢谢
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)

Answer 3

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 [e-mail]

Answer 4

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

Answer 5

谢谢，原因已经找到就是这个remote registry 服务在集群内没有开启，导致一台无法查找到另一台的信息，导致无法启动安装程序，感觉

Answer 6

另外建议这个是英文论坛，如果你发中文，其他人看不懂，建议以后用英文提问。

---

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 [e-mail]