none
SQL Server 2016 Upgrade Fails to start RRS feed

  • Question

  • Trying to upgrade our production sql server enterprise instance today and get the following error.
    I've rebooted and tried a repair install but got the same error. The Engine Service is failing to start and throwing this in the event logs. Not sure what other info to provide

    OS : Server 2012 R2

    Upgrading from SQL Server 2014 Enterprise SP1

        Windows cannot access the file  for one of the following reasons: there is a problem with the network connection, the disk that the file is stored on, or the storage drivers installed on this computer; or the disk is missing. Windows closed the program SQL Server Windows NT - 64 Bit because of this error.

        Program: SQL Server Windows NT - 64 Bit
        File: 

        The error value is listed in the Additional Data section.
        User Action
        1. Open the file again. This situation might be a temporary problem that corrects itself when the program runs again.
        2. If the file still cannot be accessed and
    - It is on the network, your network administrator should verify that there is not a problem with the network and that the server can be contacted.
    - It is on a removable disk, for example, a floppy disk or CD-ROM, verify that the disk is fully inserted into the computer.
        3. Check and repair the file system by running CHKDSK. To run CHKDSK, click Start, click Run, type CMD, and then click OK. At the command prompt, type CHKDSK /F, and then press ENTER.
        4. If the problem persists, restore the file from a backup copy.
        5. Determine whether other files on the same disk can be opened. If not, the disk might be damaged. If it is a hard disk, contact your administrator or computer hardware vendor for further assistance.

        Additional Data
        Error value: 00000000
        Disk type: 0


    Here is the log

        Overall summary:
          Final result:                  User canceled
          Exit code (Decimal):           -2068119551
          Start time:                    2017-07-15 13:14:01
          End time:                      2017-07-15 13:37:21
          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 IS:              SQL Server Setup was canceled before completing the operation. Try the setup process again.
          Next step for RS:              SQL Server Setup was canceled before completing the operation. Try the setup process again.
          Next step for AS:              Use the following information to resolve the error, and then try the setup process again.
          Next step for Browser:         SQL Server Setup was canceled before completing the operation. Try the setup process again.
          Next step for Writer:          SQL Server Setup was canceled before completing the operation. Try the setup process again.


        Machine Properties:
          Machine name:                  SQLCLUSTER4
          Machine processor count:       30
          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 2014                                                          SSMS                                     1033                 Enterprise Edition   12.1.4487.0     No         Yes       
          SQL Server 2014                                                          Adv_SSMS                                 1033                 Enterprise Edition   12.1.4487.0     No         Yes       
          SQL Server 2014                                                          Integration Services                     1033                 Enterprise Edition   12.1.4487.0     No         Yes       
          SQL Server 2016      MSSQLSERVER          MSSQL13.MSSQLSERVER            Database Engine Services                 1033                 Enterprise Edition   13.1.4001.0     No         Yes       
          SQL Server 2016      MSSQLSERVER          MSSQL13.MSSQLSERVER            SQL Server Replication                   1033                 Enterprise Edition   13.1.4001.0     No         Yes       
          SQL Server 2016      MSSQLSERVER          MSSQL13.MSSQLSERVER            Full-Text and Semantic Extractions for Search 1033                 Enterprise Edition   13.1.4001.0     No         Yes       
          SQL Server 2016      MSSQLSERVER          MSSQL13.MSSQLSERVER            Data Quality Services                    1033                 Enterprise Edition   13.0.1601.5     No         Yes       
          SQL Server 2016      MSSQLSERVER          MSAS13.MSSQLSERVER             Analysis Services                        1033                 Enterprise Edition   13.1.4001.0     No         Yes       
          SQL Server 2016      MSSQLSERVER          MSRS13.MSSQLSERVER             Reporting Services - Native              1033                 Enterprise Edition   13.1.4001.0     No         Yes       
          SQL Server 2016                                                          Integration Services                     1033                 Enterprise Edition   13.1.4001.0     No         Yes       

        Package properties:
          Description:                   Microsoft SQL Server 2016 
          ProductName:                   SQL Server 2016
          Type:                          RTM
          Version:                       13
          SPLevel:                       0
          Installation location:         N:\x64\setup\
          Installation edition:          Enterprise

        User Input Settings:
          ACTION:                        Repair
          AGTDOMAINGROUP:                <empty>
          AGTSVCACCOUNT:                 synovia\willd
          AGTSVCPASSWORD:                <empty>
          AGTSVCSTARTUPTYPE:             Manual
          ASCONFIGDIR:                   Config
          ASSVCACCOUNT:                  NT Service\MSSQLServerOLAPService
          ASSVCPASSWORD:                 <empty>
          ASTELSVCACCT:                  NT Service\SSASTELEMETRY
          ASTELSVCPASSWORD:              <empty>
          ASTELSVCSTARTUPTYPE:           Automatic
          CLTSTARTUPTYPE:                0
          CLTSVCACCOUNT:                 <empty>
          CLTSVCPASSWORD:                <empty>
          CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20170715_131401\ConfigurationFile.ini
          CTLRSTARTUPTYPE:               0
          CTLRSVCACCOUNT:                <empty>
          CTLRSVCPASSWORD:               <empty>
          ENU:                           true
          EXTSVCACCOUNT:                 <empty>
          EXTSVCPASSWORD:                <empty>
          FAILOVERCLUSTERGROUP:          <empty>
          FAILOVERCLUSTERNETWORKNAME:    <empty>
          FTSVCACCOUNT:                  NT Service\MSSQLFDLauncher
          FTSVCPASSWORD:                 <empty>
          HELP:                          false
          IACCEPTROPENLICENSETERMS:      false
          INDICATEPROGRESS:              false
          INSTANCENAME:                  MSSQLSERVER
          ISSVCACCOUNT:                  NT Service\MsDtsServer130
          ISSVCPASSWORD:                 <empty>
          ISSVCSTARTUPTYPE:              Automatic
          ISTELSVCACCT:                  NT Service\SSISTELEMETRY130
          ISTELSVCPASSWORD:              <empty>
          ISTELSVCSTARTUPTYPE:           Automatic
          MRCACHEDIRECTORY:              
          QUIET:                         false
          QUIETSIMPLE:                   false
          SQLSVCACCOUNT:                 NT Service\MSSQLSERVER
          SQLSVCPASSWORD:                <empty>
          SQLTELSVCACCT:                 NT Service\SQLTELEMETRY
          SQLTELSVCPASSWORD:             <empty>
          SQLTELSVCSTARTUPTYPE:          Automatic
          SUPPRESSPRIVACYSTATEMENTNOTICE: false
          UIMODE:                        Normal
          X86:                           false

          Configuration file:            C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20170715_131401\ConfigurationFile.ini

        Detailed results:
          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:          0x80004005
          Error description:             The service did not respond to the start or control request in a timely fashion.
          Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.4001.0&EvtType=0xDC112D1C%400xDC80C325&EvtType=0xDC112D1C%400xDC80C325

          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:          0x80004005
          Error description:             The service did not respond to the start or control request in a timely fashion.
          Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.4001.0&EvtType=0xDC112D1C%400xDC80C325&EvtType=0xDC112D1C%400xDC80C325

          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:          0x80004005
          Error description:             The service did not respond to the start or control request in a timely fashion.
          Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.4001.0&EvtType=0xDC112D1C%400xDC80C325&EvtType=0xDC112D1C%400xDC80C325

          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:          0x80004005
          Error description:             The service did not respond to the start or control request in a timely fashion.
          Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.4001.0&EvtType=0xDC112D1C%400xDC80C325&EvtType=0xDC112D1C%400xDC80C325

          Feature:                       Integration Services
          Status:                        Failed: see logs for details
          Reason for failure:            Setup was canceled for the feature.
          Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

          Feature:                       Reporting Services - Native
          Status:                        Failed: see logs for details
          Reason for failure:            Setup was canceled for the feature.
          Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

          Feature:                       Analysis 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 Analysis Services
          Component error code:          0x84BB0001
          Error description:             The service did not respond to the start or control request in a timely fashion.
          Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.4001.0&EvtType=0xDC112D1C%400xDC80C325&EvtType=0xDC112D1C%400xDC80C325

          Feature:                       SQL Browser
          Status:                        Failed: see logs for details
          Reason for failure:            Setup was canceled for the feature.
          Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

          Feature:                       SQL Writer
          Status:                        Failed: see logs for details
          Reason for failure:            Setup was canceled for the feature.
          Next Step:                     SQL Server Setup was canceled before completing the operation. Try the setup process again.

          Feature:                       SQL Client Connectivity
          Status:                        Passed

          Feature:                       SQL Client Connectivity SDK
          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\130\Setup Bootstrap\Log\20170715_131401\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:

        Service SID support has been enabled on the service.


                                                                                                                                                       
    • Edited by dougleu Saturday, July 15, 2017 7:30 PM
    Saturday, July 15, 2017 7:27 PM

All replies

  • Hi dougleu,

    >>Windows cannot access the file  for one of the following reasons:

    Could you please also post the file name? And if the file name is not in the log, could you please locate and upload the corespondding SQL Server installation log to OneDrive and post the link here? 

    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.


    Monday, July 17, 2017 4:57 AM
    Moderator