Upgrade Error – SQL 2016 Installer Unable to Open Registry Key

Upgrade Error – SQL 2016 Installer Unable to Open Registry Key

July 14, 2016

Today I was working on an in-place upgrade from SQL Server 2014 to SQL Server 2016. I had earlier run the Upgrade Advisor 2016 to determine the compatibility of the existing databases with SQL Server 2016. They passed.

I should  mention here that at the end of running Upgrade Advisor you have to export the report to a file to see details of the issues identified by the tool. This is something easy to miss.

UpgradeAdvisor

Now back to my upgrade. The upgrade process is as simply as selecting the the option Installation >Upgrade from a previous version of SQL Server from the SQL Server Installation  Center options. The fact that my environment was clustered did not complicate the in-place upgrade in any way.

However, close to the end of the process the following error occured:

The following error has occurred:

Attempted to perform an unauthorized operation.

Click ‘Retry’ to retry the failed action, or click ‘Cancel’ to cancel this action and continue setup.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.1601.5&EvtType=0x48BB60BC%25400xBB814387

On examining the detailed install log I discovered the installer could not open the a certain registry key. The error stack follows below:

The following error has occurred:

(01) 2016-07-14 14:01:10 Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException

(01) 2016-07-14 14:01:10 Slp: Message:

(01) 2016-07-14 14:01:10 Slp: Attempted to perform an unauthorized operation.

(01) 2016-07-14 14:01:10 Slp: HResult : 0x84bb0001

(01) 2016-07-14 14:01:10 Slp: FacilityCode : 1211 (4bb)

(01) 2016-07-14 14:01:10 Slp: ErrorCode : 1 (0001)

(01) 2016-07-14 14:01:10 Slp: Data:

(01) 2016-07-14 14:01:10 Slp: WatsonData = HKEY_LOCAL_MACHINE@System\CurrentControlSet\Services\LanmanServer\Parameters\FsctlAllowList

(01) 2016-07-14 14:01:10 Slp: DisableRetry = true

(01) 2016-07-14 14:01:10 Slp: Inner exception type: System.UnauthorizedAccessException

(01) 2016-07-14 14:01:10 Slp: Message:

(01) 2016-07-14 14:01:10 Slp: Attempted to perform an unauthorized operation.

(01) 2016-07-14 14:01:10 Slp: HResult : 0x80070005

(01) 2016-07-14 14:01:10 Slp: Stack:

(01) 2016-07-14 14:01:10 Slp: at Microsoft.SqlServer.Configuration.Sco.InternalRegistryKey.OpenSubKey(String subkey, RegistryAccess requestedAccess)

(01) 2016-07-14 14:01:10 Slp:

I checked this key and also noticed I, an administrator on the server, could not add permissions to this key either. After troubleshooting the registry permissions for ages, one of the System Admins pointed out to me the possibility that the antivirus Access Protection feature had blocked this modification of the registry. Behold this was exactly the case.

 

Igiri Books © Copyright 2016. All Rights Reserved. Site Credits: AppWorld