SQL SERVER – Service Pack Failure: MissingRegistryKeyException. The Registry Key is Missing

One of my blog readers contacted me and informed that he is getting the same error as mentioned in below blog SQL SERVER – Service Pack Failure: MissingRegistryKeyException. Note that it had the same error message, but that did not help him here. In this blog, we would learn how to fix MissingRegistryKeyException while installing SQL Server service pack. Let us fix the error registry key is missing.

Below is the trimmed version of log (Detail.txt)

Microsoft.SqlServer.Configuration.SqlEngine.MissingRegistryKeyException: The registry key System\CurrentControlSet\Services\MSSQLSERVER\Performance is missing.
Microsoft.SqlServer.Configuration.SqlEngine.Globals.GetSqlRegistryKeyHKLM
Microsoft.SqlServer.Configuration.SqlEngine.PerfmonRegistration.GetDLLNameFromRegistry
Microsoft.SqlServer.Configuration.SqlEngine.PerfmonRegistration.NeedToPatch
Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPrivate.PatchPerfmonCounters
Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPrivate.Patch
Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction
Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute
Exception: Microsoft.SqlServer.Configuration.SqlEngine.MissingRegistryKeyException.
Source: Microsoft.SqlServer.Configuration.SqlServer_ConfigExtension.

Since he already tried following my earlier blog, I was wondering what to do next. A thought of running a REPAIR of SQL Server instance came to my mind. I quickly checked what all actions do a REPAIR take care.

Solarwinds

One of the points mentioned in the above article was, And, this brought a smile on my face.

SQL SERVER - Service Pack Failure: MissingRegistryKeyException. The Registry Key is Missing MissRegKeyEx-01

Here is the repair option from LandingPage in setup. Below image is taken from SQL Server 2017 setup media bit option remains same (SQL 2008 onwards)

SQL SERVER - Service Pack Failure: MissingRegistryKeyException. The Registry Key is Missing MissRegKeyEx-02

SOLUTION/WORKAROUND

I suggested him to go ahead and use SQL Server REPAIR using the RTM Media and asked to re-run the patch. He sent me an email that he again tried to run the service pack after repair and it was completed without any errors.

Have you used Repair option in SQL Server setup? When did you use, and did it help? Please let me know via comments.

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

Solarwinds
, , , , ,
Previous Post
SQL SERVER – SharePoint not Working After Failover to Another Node
Next Post
SQL SERVER – Installation Error – Unable to Open Windows Installer File – 2147286960

Related Posts

Leave a Reply

Menu