Forum Discussion

rmantel62's avatar
rmantel62
Copper Contributor
Dec 21, 2020

SQL Server 2019 Upgrade - Problem

I have a problem server it appears. It had MSSQL 2016 Dev and I was able to upgrade it 2017 Dev. However in the process of going to 2019 Dev, I got an error;

 

TITLE: Microsoft SQL Server 2019 Setup
------------------------------
The following error has occurred:


An error occurred while installing extensibility feature with error message: AppContainer Creation Failed with error message ENABLE_LOOPBACK_CONNECTIONS, state Exception of type 'System.Exception' was thrown..

 

For help, click: https://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&Evtsrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=0x1AFE2C68%25400xC1FAF19F%25401392%25406

 

Log file has this;

(01) 2020-12-20 15:56:44 SQLEngine: EnableLoopBackConnections failed with error code 0.

(01) 2020-12-20 15:56:44 SQLEngine: Removing firewall rules for appcontainer pool.

(01) 2020-12-20 15:56:44 SQLEngine: Failed to remove firewall rule 'Block network access for AppContainer-00 in SQL Server instance SQL2019'. Exception occurred. (Exception from HRESULT: 0x80020009 (DISP_E_EXCEPTION)).

(01) 2020-12-20 15:56:44 Slp: Configuration action failed for feature AdvancedAnalytics during timing ConfigNonRC and scenario ConfigNonRC.

(01) 2020-12-20 15:56:44 Slp: An error occurred while installing extensibility feature with error message: AppContainer Creation Failed with error message ENABLE_LOOPBACK_CONNECTIONS, state Exception of type 'System.Exception' was thrown..

(01) 2020-12-20 15:56:44 Slp: Exception has been categorized, so don't overwrite the current value

(01) 2020-12-20 15:56:44 Slp: Configuration action failed for feature AdvancedAnalytics during timing ConfigNonRC and scenario ConfigNonRC.

(01) 2020-12-20 15:56:44 Slp: Microsoft.SqlServer.Configuration.Extensibility.ExtensibilitySetupException: An error occurred while installing extensibility feature with error message: AppContainer Creation Failed with error message ENABLE_LOOPBACK_CONNECTIONS, state Exception of type 'System.Exception' was thrown..

 

There were several attempts to install as a result of other problems. I cannot find anything specific to this error on the web. Does anyone have an idea of where I need to look or a solution? BTW I did a new install on the same server and although SQL Server is running, the R and Machine Language failed to install.

 

Thanks

  • sreemace's avatar
    sreemace
    Copper Contributor
    Jul 26, 2022
    I am stuck with the same issue! Did you find a solution for this issue?
    • olafhelper's avatar
      olafhelper
      Bronze Contributor
      Jul 27, 2022

      sreemace , this post is two years old.

       

      Start a new, own thread and describe your issues detailed.

       

      Olaf

      • sreemace's avatar
        sreemace
        Copper Contributor
        Jul 27, 2022
        Ok Olaf, will do. But I went in depth a bit more and I doubt windows firewall is disabled on win 2019 and it fails @ below step. I will try enabling windows firewall and see how it goes.

        (01) 2022-07-22 10:29:17 SQLEngine: Failed to remove firewall rule 'Block network access for AppContainer-00 in SQL Server instance MSSQLSERVER'. Exception occurred. (Exception from HRESULT: 0x80020009 (DISP_E_EXCEPTION)).

        Thanks,
        -SreejitG

Resources