SQL SERVER – FIX – Error 1402. Could not open key: UNKNOWN\Components. System error 5

While installing Service Pack 3 for SQL Server, I was welcomed by a strangeĀ error about UNKNOWN\Components.

Line 2421: MSI (s) (C8:98) [22:31:05:835]: Product: Microsoft SQL Server System CLR Types (x64) – Update ‘Service Pack 3 for SQL Server System CLR Types (64-bit) (KB2979597)’ could not be installed. Error code 1603. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20160105_195913\TFSDEV01\SQLSysClrTypes_Cpu64_1.log.

When I checked SQLSysClrTypes_Cpu64_1.log file, I found below error.

Line 2063: Error 1402. Could not open key: UNKNOWN\Components\0F02D6F45ECC29410AF18C3B9B1A1EE8\EDED107488810E94AB5E58875729C42A. System error 5. Verify that you have sufficient access to that key, or contact your support personnel.

Before attempting solutions, please take a backup of the registry. Microsoft’s built-in backup program allows for the ‘system state’ to be selectively backed up. You can also backup the Windows\System32\Config’ directory while taking backup.

SOLUTION

Step 1

Try KB

This is a long KB and take a lot of time to find what exactly we need to run.

SECEDIT /CONFIGURE /CFG %WINDIR%\INF\DEFLTBASE.INF /DB DEFLTBASE.SDB /VERBOSE /AREAS REGKEYS

SQL SERVER - FIX - Error 1402. Could not open key: UNKNOWN\Components.  System error 5 unknown-comp-01

If above doesn’t work, then go to step 2

Step 2

I have used the psexec tool to grant permission on the components folder for logged in account, after granting the permission SP3 installation completed successfully. Here are the steps:

  1. Close registry editor, if opened.
  2. Download and install psexec utility from the following link http://technet.microsoft.com/en-us/sysinternals/bb897553.aspx
  3. Open a command prompt using ‘run as administrator’
  4. In the command prompt Navigate to the folder where PSEXEC is installed.
  5. Execute the following from the command prompt.

psexec -i -s cmd.exe

  1. The above command will open another command prompt running under ā€˜Local System’
  2. On the new command prompt, open Registry Editor by typing ā€œregeditā€ and hitting the enter key.
  3. In registry editor, navigate to the following hive HKLM\Software\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components

SQL SERVER - FIX - Error 1402. Could not open key: UNKNOWN\Components.  System error 5 unknown-comp-02

  1. Add the user account used to run the installation under permissions for the above hive and grant ā€˜Full control’ for that user.
  2. Click on Advanced.

SQL SERVER - FIX - Error 1402. Could not open key: UNKNOWN\Components.  System error 5 unknown-comp-03

  1. Under the Advanced security settings for Components choose the user and check the ā€œReplace all existing inheritable permissionsā€¦ā€¦ā€¦ā€¦ā€ check box as shown below and click OK

I could move forward by following step # 2.

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL Error Messages, SQL Server, SQL Server Security
Previous Post
SQL SERVER – FIX: Error 19456: None of the IP Addresses Configured for the Availability Group Listener can be Hosted by the Server
Next Post
SQL SERVER – FIX: Msg 7356, Level 16 – The OLE DB provider “ASEOLEDB” for linked server “SYBASESERVER” supplied inconsistent metadata for a column

Related Posts

8 Comments. Leave new

Leave a Reply