Upgrade to SQL Server 2016 - Unauthorized operation - Cannot Open Reg SubKey

• Kenneth Igiri

  SSCertifiable

  Points: 5005

  More actions

  July 14, 2016 at 9:28 am

  #319904

  I am working on an in-place upgrade from SQL 2014 to SQL 2016. The environment is clustered. I get the following error close to the end:

  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.

  (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.

  Is there a workaround for this please?

  Br. Kenneth Igiri
  https://kennethigiri.com
  All nations come to my light, all kings to the brightness of my rising

• Kenneth Igiri

  SSCertifiable

  Points: 5005

  More actions

  July 14, 2016 at 9:36 am

  #1890140

  Oh my goodness! I can't believe it. It was McAfee again!!! Been at this all day. Thank so much.

  Br. Kenneth Igiri
  https://kennethigiri.com
  All nations come to my light, all kings to the brightness of my rising