SQL server - Patch installation failure

Error Cause Resolution
Unknown error code: 1856439871 Reboot Pending Reboot is pending on some client machines, restart these machines and re-deploy the patches.
Unknown error code: -2067723326 Reboot pending Reboot is pending on the client machines, restart these machines and re-deploy the patches.
Unknown error code: -2067919922 This is a cluster issue caused due to inactive clusters Follow the steps below:
  • Open Windows Power shell in the administrator mode and execute the 3 commands given below
  • Get-WindowsFeature RSAT-Cluster*
  • Install-WindowsFeature -Name RSAT-Clustering-AutomationServer
  • Get-WindowsFeature RSAT-Cluster*
  • If the issue persists, try manual installation of the update. If manual installation also fails, contact Microsoft support.
Unknown error code: -2067529717 This issue is due to Another Instance Running Reboot the machine once and deploy this patch. If the issue persists, contact our support team with agent logs and SQL server logs
Unknown error code: -2146233080 This issue is due to not being able to access the dll. It may happen when dll files related to SQL server is locked. Contact our support team with the agent logs and SQL server logs for finding the locked dll.
Unknown error code: -2061893565 This issue is due to some registry key related to the SQL server having been changed/modified in the machine or due to the default user database and log directories not properly being defined in the registry. Reboot the machine and then try deployment. If the issue persists, repair the SQL server application and try again.
Error code: - 2067919934 System requires reboot due to possible pending file operations or other system changes requiring a restart Restart your computer up to two times to ensure all pending operations have completed. After restarting, run the installation again. If the issue persists, you can modify or delete the registry keys referenced below, which may contain orphaned values that are preventing you from installing your product.
  • Open the Windows Registry Editor (click Start, Run, type regedit, and click Enter):
  • Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager.
  • Right-click the PendingFileRenameOperations value and select Delete from the context menu. When prompted, click Yes to confirm the delete operation.
  • Close Registry Editor
  • Restart your computer and attempt to run the installation again.
Error code: 2068119551 Anti-Virus software is blocking deployment Exclude the respective folders from Anti-Virus scans or disable Anti-Virus and deploy the patches.
Error code: 2145124330, 2068054016, 2068054016 Pending reboot Reboot is pending in the client machine, Restart the machine and re-deploy the patches.
Error code: 2068709374 Windows installer cache files missing

Procedure 1

  • Download FixMissingMSI tool OR FindSQLInstalls.vbs script from Github Repository.
  • Use either the tool OR script to identify missing MSI files from Windows Installer Cache.
  • Take from source media and re-add missing files into Cache.

Procedure 2

  • Manually identify missing files using error messages, setup log files or registry entries.
  • Download the patch package from corresponding KB article from support.microsoft.com
  • Add contents of the patch package to Windows Installer Cache.
Error code: 2061893607 Database engine not in online
  • Uninstall SQL server completely using add/remove programs. All components from failed installation attempts should also be deleted.
  • Navigate to the SQL Installation Directory and locate the setup.exe file. Start a fresh installation.
Function could not be executed Issue with application Repair the application in client machine and deploy the patches