none
SQL Server 2016 - Error code: 0x8131500 when installing SQL 2016 SP1

    Question

  • Overall summary:
      Final result:                  The patch installer has failed to update the following instance: MSSQLSERVER. To determine the reason for failure, review the log files.
      Exit code (Decimal):           -2146233088
      Start time:                    2016-12-29 14:39:58
      End time:                      2016-12-29 15:00:07
      Requested action:              Patch
    
    Instance MSSQLSERVER overall summary:
      Final result:                  The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.
      Exit code (Decimal):           -2146233088
      Start time:                    2016-12-29 14:52:12
      End time:                      2016-12-29 15:00:02
      Requested action:              Patch
    
    Machine Properties:
      Machine name:                  ADR-DEV-DB-SQL2
      Machine processor count:       2
      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:                  No
    
    Product features discovered:
      Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered  Configured
      SQL Server 2016      MSSQLSERVER          MSSQL13.MSSQLSERVER            Database Engine Services                 1033                 Standard Edition     13.0.1601.5     No         Yes       
      SQL Server 2016      MSSQLSERVER          MSSQL13.MSSQLSERVER            SQL Server Replication                   1033                 Standard Edition     13.0.1601.5     No         Yes       
      SQL Server 2016      MSSQLSERVER          MSSQL13.MSSQLSERVER            Full-Text and Semantic Extractions for Search 1033                 Standard Edition     13.0.1601.5     No         Yes       
      SQL Server 2016      MSSQLSERVER          MSSQL13.MSSQLSERVER            Data Quality Services                    1033                 Standard Edition     13.0.1601.5     No         Yes       
      SQL Server 2016      MSSQLSERVER          MSSQL13.MSSQLSERVER            R Services (In-Database)                 1033                 Standard Edition     13.0.1601.5     No         Yes       
      SQL Server 2016      MSSQLSERVER          MSSQL13.MSSQLSERVER            sql_inst_mr                              1033                 Standard Edition     13.0.1601.5     No         Yes       
      SQL Server 2016      MSSQLSERVER          MSAS13.MSSQLSERVER             Analysis Services                        1033                 Standard Edition     13.0.1601.5     No         Yes       
      SQL Server 2016      MSSQLSERVER          MSRS13.MSSQLSERVER             Reporting Services - Native              1033                 Standard Edition     13.0.1601.5     No         Yes       
      SQL Server 2016                                                          SSMS                                     1033                 Standard Edition     13.0.15000.23   No         Yes       
      SQL Server 2016                                                          Client Tools Connectivity                1033                 Standard Edition     13.0.14500.10   No         Yes       
      SQL Server 2016                                                          Client Tools Backwards Compatibility     1033                 Standard Edition     13.0.14500.10   No         Yes       
      SQL Server 2016                                                          Client Tools SDK                         1033                 Standard Edition     13.0.14500.10   No         Yes       
      SQL Server 2016                                                          Data Quality Client                      1033                 Standard Edition     13.0.1601.5     No         Yes       
      SQL Server 2016                                                          Integration Services                     1033                 Standard Edition     13.0.1601.5     No         Yes       
      SQL Server 2016                                                          Reporting Services - SharePoint                                                    13.0.1601.5     No         Yes       
    
    Package properties:
      Description:                   Microsoft SQL Server 2016 
      ProductName:                   SQL Server 2016
      Type:                          RTM
      Version:                       13
      SPLevel:                       1
      KBArticle:                     KB3182545
      KBArticleHyperlink:            http://support.microsoft.com/?kbid=3182545
      PatchType:                     SP
      AssociatedHotfixBuild:         0
      Platform:                      x64
      PatchLevel:                    13.1.4001.0
      ProductVersion:                13.0.1601.5
      GDRReservedRange:              13.0.1700.0:13.0.1899.0;13.0.3200.0:13.0.3499.0
      Installation location:         c:\c96a13945e7218fc9e71\x64\setup\
    
    Updated product edition:
      Instance             Edition             
      MSSQLSERVER          Standard            
    
    User Input Settings:
      ACTION:                        Patch
      ALLINSTANCES:                  false
      CLUSTERPASSIVE:                false
      CONFIGURATIONFILE:             
      ENU:                           true
      HELP:                          false
      IACCEPTROPENLICENSETERMS:      false
      IACCEPTSQLSERVERLICENSETERMS:  true
      INDICATEPROGRESS:              false
      INSTANCEID:                    <empty>
      INSTANCENAME:                  <empty>
      MRCACHEDIRECTORY:              
      QUIET:                         false
      QUIETSIMPLE:                   false
      SUPPRESSPRIVACYSTATEMENTNOTICE: false
      UIMODE:                        Normal
      X86:                           false
    
    Rules with failures:
    
    Global rules:
    
    There are no scenario-specific rules.
    
    Rules report file:               C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20161229_143957\SystemConfigurationCheck_Report.htm
    


    I realise there is another thread on this subject but i could not reply to it, i guess because it has been answered ?


    I deployed an AWS pre-built instance that runs Windows 2012R2 and SQL 2016. I thought i would run SQL2016 SP1 before a dacpac but received the error above.

    SP1 managed to update all services apart from 'R Services (In-database)'

    The link in the screenshot (and below) does take you to a Microsoft page to buy an Xbox:)

     http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.4001.0&EvtType=0x25C2E45A%400xC68B78F0&EvtType=0x25C2E45A%400xC68B78F0 

    The code block about is the SP1 summary log.

    I don't have the reg key mentioned in a similar thread on this forum.

    Does anyone know how to fix it?


    Thursday, December 29, 2016 3:50 PM

All replies

  • I meet the problem too, but seems the program upgrading is completed.


    Jay MSN: zhaojiemail@126.com


    • Edited by zhaojie2012 Thursday, December 29, 2016 4:32 PM
    Thursday, December 29, 2016 4:19 PM
  • Hi ac427,

    Based on your information, it seems everything else is fine except for the R service. In this case, I would suggest you locate and upload Rsetup.log it to pastebin then share the link here so we can have a better understanding about the issue. According to your screenshot, the file could be found under ‘C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20161229_143957\’.

    Also, based on my past experience, it’s possible that you are facing network issues here as there are two files needs to be downloaded during installation\update process of R service. I would suggest you re-install the service pack after some time see if the issue goes away.

    If you have any other questions, please let me know.

    Regards,
    Lin

    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.

    Friday, December 30, 2016 4:48 AM
    Moderator