SQL Server 2019 Upgrade - Problem

Copper Contributor

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&EvtI...

 

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

4 Replies
I am stuck with the same issue! Did you find a solution for this issue?

@sreemace , this post is two years old.

 

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

 

Olaf

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
So that's it! enable firewall and install. All good for me now.

Thanks,
-SreejitG