Unauthorized operation.

SQL Installation Error

Attempted to perform an unauthorized operation.

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

During SQL Setup, the above error occurs due to permission issue the ways it gets update in the registry keys and sql server instance directory installed.

To Resolve this, try the below steps.

1)      Do not install the named instance on the shared directory that has the default instance already.

2)      Turn off UAC in windows and restart the computer

3)      Type Regedit and navigate to the registry key machines as per below run order

4)      Located HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server in registry

5)      Right click and go to Permission

6)      Click on Advance

7)      Tick on both check box (I. Inherit from parent the permission... II. Replace permission entries on all child objects...), click OK

8)      Click OK again

9)      If any user has read permission, provide full control access. i.e. if you add current user for the sql server installation.

10)  Uninstall the named instance sql server

11)  Restart the Windows and re-try the installation that should overcome the installation error.