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.