Upgrading SQL Server can sometimes be a challenging task, especially when encountering errors during the process. In this article, we will discuss a common error that users may face while upgrading SQL Server 2008 R2 with service pack 2 – Error: 0x80070422.

When encountering this error, the first step is to gather the setup logs from the C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\ folder. These logs contain valuable information that can help identify the cause of the failure.

Upon reviewing the logs, we found the following error message in the Summary.txt file:


The patch installer has failed to update the following instance: MSSQLSERVER. To determine the reason for failure, review the log files. Exit code (Decimal): -2068052415 Exit facility code: 1212 Exit error code: 1601 Exit message: The patch installer has failed to update the following instance: MSSQLSERVER. To determine the reason for failure, review the log files.


Additionally, the log mentioned a failure in updating the shared features:


The patch installer has failed to update the shared features. To determine the reason for failure, review the log files. Exit code (Decimal): -2068052415 Exit facility code: 1212 Exit error code: 1601 Exit message: The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.


Further investigation led us to the SQLSysClrTypes_Cpu64_1.log file, where we found the following error:


Failed to connect to server. Error: 0x80070422


The error code 0x80070422 translates to “ERROR_SERVICE_DISABLED,” indicating that the Windows Installer service was disabled. This disabled state of the service was the root cause of the upgrade failure.

To resolve this issue, we enabled the “Windows Installer” service and retried the upgrade, which was successful.

If you have encountered a similar installation issue or have any questions, please leave a comment below.