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

  • 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%5B/i%5D

    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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply