SQL Server 2019 Upgrade - Problem

%3CLINGO-SUB%20id%3D%22lingo-sub-2006568%22%20slang%3D%22en-US%22%3ESQL%20Server%202019%20Upgrade%20-%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2006568%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20problem%20server%20it%20appears.%20It%20had%20MSSQL%202016%20Dev%20and%20I%20was%20able%20to%20upgrade%20it%202017%20Dev.%20However%20in%20the%20process%20of%20going%20to%202019%20Dev%2C%20I%20got%20an%20error%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETITLE%3A%20Microsoft%20SQL%20Server%202019%20Setup%3CBR%20%2F%3E------------------------------%3CBR%20%2F%3EThe%20following%20error%20has%20occurred%3A%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EAn%20error%20occurred%20while%20installing%20extensibility%20feature%20with%20error%20message%3A%20AppContainer%20Creation%20Failed%20with%20error%20message%20ENABLE_LOOPBACK_CONNECTIONS%2C%20state%20Exception%20of%20type%20'System.Exception'%20was%20thrown..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20help%2C%20click%3A%20%3CA%20href%3D%22https%3A%2F%2Fgo.microsoft.com%2Ffwlink%3FLinkID%3D20476%26amp%3BProdName%3DMicrosoft%2520SQL%2520Server%26amp%3BEvtsrc%3Dsetup.rll%26amp%3BEvtID%3D50000%26amp%3BProdVer%3D15.0.4013.40%26amp%3BEvtType%3D0x1AFE2C68%2525400xC1FAF19F%2525401392%2525406%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgo.microsoft.com%2Ffwlink%3FLinkID%3D20476%26amp%3BProdName%3DMicrosoft%2520SQL%2520Server%26amp%3BEvtsrc%3Dsetup.rll%26amp%3BEvtID%3D50000%26amp%3BProdVer%3D15.0.4013.40%26amp%3BEvtType%3D0x1AFE2C68%2525400xC1FAF19F%2525401392%2525406%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELog%20file%20has%20this%3B%3C%2FP%3E%3CP%3E(01)%202020-12-20%2015%3A56%3A44%20SQLEngine%3A%20EnableLoopBackConnections%20failed%20with%20error%20code%200.%3C%2FP%3E%3CP%3E(01)%202020-12-20%2015%3A56%3A44%20SQLEngine%3A%20Removing%20firewall%20rules%20for%20appcontainer%20pool.%3C%2FP%3E%3CP%3E(01)%202020-12-20%2015%3A56%3A44%20SQLEngine%3A%20Failed%20to%20remove%20firewall%20rule%20'Block%20network%20access%20for%20AppContainer-00%20in%20SQL%20Server%20instance%20SQL2019'.%20Exception%20occurred.%20(Exception%20from%20HRESULT%3A%200x80020009%20(DISP_E_EXCEPTION)).%3C%2FP%3E%3CP%3E(01)%202020-12-20%2015%3A56%3A44%20Slp%3A%20Configuration%20action%20failed%20for%20feature%20AdvancedAnalytics%20during%20timing%20ConfigNonRC%20and%20scenario%20ConfigNonRC.%3C%2FP%3E%3CP%3E(01)%202020-12-20%2015%3A56%3A44%20Slp%3A%20An%20error%20occurred%20while%20installing%20extensibility%20feature%20with%20error%20message%3A%20AppContainer%20Creation%20Failed%20with%20error%20message%20ENABLE_LOOPBACK_CONNECTIONS%2C%20state%20Exception%20of%20type%20'System.Exception'%20was%20thrown..%3C%2FP%3E%3CP%3E(01)%202020-12-20%2015%3A56%3A44%20Slp%3A%20Exception%20has%20been%20categorized%2C%20so%20don't%20overwrite%20the%20current%20value%3C%2FP%3E%3CP%3E(01)%202020-12-20%2015%3A56%3A44%20Slp%3A%20Configuration%20action%20failed%20for%20feature%20AdvancedAnalytics%20during%20timing%20ConfigNonRC%20and%20scenario%20ConfigNonRC.%3C%2FP%3E%3CP%3E(01)%202020-12-20%2015%3A56%3A44%20Slp%3A%20Microsoft.SqlServer.Configuration.Extensibility.ExtensibilitySetupException%3A%20An%20error%20occurred%20while%20installing%20extensibility%20feature%20with%20error%20message%3A%20AppContainer%20Creation%20Failed%20with%20error%20message%20ENABLE_LOOPBACK_CONNECTIONS%2C%20state%20Exception%20of%20type%20'System.Exception'%20was%20thrown..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20were%20several%20attempts%20to%20install%20as%20a%20result%20of%20other%20problems.%20I%20cannot%20find%20anything%20specific%20to%20this%20error%20on%20the%20web.%20Does%20anyone%20have%20an%20idea%20of%20where%20I%20need%20to%20look%20or%20a%20solution%3F%20BTW%20I%20did%20a%20new%20install%20on%20the%20same%20server%20and%20although%20SQL%20Server%20is%20running%2C%20the%20R%20and%20Machine%20Language%20failed%20to%20install.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

0 Replies