A reader hit MissingRegistryKeyException during a service pack, but my earlier fix did not help. Here is another cause of the missing registry key and the fix.
SQL SERVER – The Automatically Saved Settings file NewSettings.vssettings Cannot be Found
After cleaning up some data from my user profile, when I launched SQL Server Management Studio 17.4, I got an error. related to automatically saved settings.
SQL SERVER – Service Pack Failure: MissingRegistryKeyException
Patching my lab failed with MissingRegistryKeyException for the MSSQLSERVER Performance key. Here is how I read detail.txt and fixed it.
SQL SERVER – Configuration Manager – Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable
SQL Server Configuration Manager said: cannot connect to WMI provider, you do not have permission or the server is unreachable. Here is the fix.
SQL SERVER – Login Failed. The Login is From an Untrusted Domain and Cannot be Used with Windows Authentication
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. Here is how the ERRORLOG led me to the cause.
SQL SERVER – Microsoft.SqlServer.Management.Sdk. Sfc.EnumeratorException: Failed to Retrieve Data for This Request
Installing a service pack on a clustered instance failed with EnumeratorException: Failed to retrieve data for this request. Detail.txt showed the cause.
SQL SERVER – Errorlog The Server was Unable to Initialize Encryption Because of a Problem with a Security Library
SQL Server would not start, and the ERRORLOG said the server was unable to initialize encryption because of a problem with a security library.