sodcalculator

10 Tech How-To

Fix SQL Error 0x80070643 on Windows

Guide 10-39923 · Updated · Step by step

SQL installation or update failures on Windows can show error 0x80070643, a general Windows Installer error that does not identify one specific cause. These steps help you find the failing SQL component, repair the installer or existing installation, and retry safely without deleting databases.

What You’ll Need

  • A Windows account with administrator permissions.
  • The original SQL Server installer or setup media, if available, and a reliable internet connection if you need to download it again.
  • A backup of important databases and a note of the SQL Server instance name before making changes.
  • The setup log from the failed attempt; it usually identifies the component and more specific cause.

Step-by-Step

  1. Record what failed. Note whether the error appeared while installing SQL Server, applying an update, installing SQL Server Management Studio (SSMS), or installing another application that includes SQL components. These are separate products and need different installers. Write down the full message, the product name, and any component or package named beside the code. Restart Windows once if a previous installation was interrupted, then try the operation again only if it is safe to do so.
  2. Find the detailed setup log. For SQL Server setup, check %ProgramFiles%\Microsoft SQL Server\<version>\Setup Bootstrap\Log. On a 64-bit system, also check %ProgramFiles(x86)%\Microsoft SQL Server\<version>\Setup Bootstrap\Log if present. You can paste each path into File Explorer’s address bar, substituting the version folder that exists. Open the newest timestamped folder and inspect Summary.txt first. Then search the accompanying detail log for error, failed, and 0x80070643. Look for the first meaningful failure, not just the final rollback message. If a different product failed, use its setup log location or click the installer’s log link.
  3. Check which component is affected. The log may point to a specific SQL Server feature, a Microsoft Visual C++ runtime, a .NET component, Windows Installer, insufficient disk space, or a pending restart. Do not remove every SQL entry because one component failed. If the log names a prerequisite, address that prerequisite first. Confirm the system drive has free space and that Windows has completed any pending restart.
  4. Use the correct installer and run it elevated. Obtain the installer from the software publisher’s official download source, matching the product and architecture you need. Right-click the installer and select Run as administrator. Avoid reusing an old setup file when the log suggests its package is damaged or incomplete. If the failure is an update, verify that it applies to your installed SQL Server version and edition before retrying.
  5. Repair an existing installation when appropriate. Open Settings > Apps > Installed apps (called Apps & features on some Windows versions). Find the SQL Server product or the specific application named in the log. If its menu offers Modify or Repair, choose that option and follow the setup wizard. For SQL Server, launch the matching SQL Server setup program and select its maintenance or repair option if available. Do not choose uninstall as a first repair step.
  6. Run Windows Update and restart. Open Settings > Windows Update, select Check for updates, and install applicable updates. Restart if prompted. Retry the SQL setup once Windows is back up. This can resolve an incomplete prerequisite or files waiting to be replaced, but it will not fix every SQL-specific failure.
  7. Retry once, then compare logs. Run the installer again as administrator. If it fails, open the newly created log folder and compare its first specific error with the earlier one. If the same package fails, stop repeating the installation and follow the package-specific message. If the code changes, use the new error and log details to choose the next action.
  8. Escalate with the relevant details. If repair does not work, contact the software publisher or your IT administrator with the exact product, Windows version, SQL version, failed component, and relevant log files. Remove or reinstall SQL components only when the log or support instructions identify them and you have confirmed backups and instance details.

Common Mistakes

  • Treating the code as a diagnosis. 0x80070643 is a broad installation failure code. The setup log’s earlier, component-specific message is usually more useful.
  • Deleting SQL folders or database files. Manual deletion can leave Windows Installer records inconsistent or destroy data. Use the product’s installer maintenance options instead.
  • Removing shared prerequisites indiscriminately. Other applications may rely on a runtime or framework. Repair or update only the component the log identifies.
  • Retrying with mismatched media. An installer for a different SQL version, edition, architecture, or update can cause additional failures.
  • Ignoring a pending restart or partial install. Setup may fail again until Windows finishes replacing files or a previous installer operation completes.

Tips

  • Copy the complete first error message from the detail log, including the component name and any additional code.
  • Keep setup logs before attempting cleanup; a later run may create a new folder and make the earlier failure harder to find.
  • Back up databases using an appropriate SQL backup method, and verify which instance and data directories are in use before changing an installation.
  • Close applications that may be using the SQL component, but do not disable security software or Windows services as a routine fix. Follow your organization’s IT guidance if a security product is specifically implicated.

Troubleshooting

No SQL Server log folder exists: The failed program may be SSMS, a SQL driver, or another product rather than SQL Server Database Engine. Check the installer’s own log link or its publisher’s documentation, and identify the exact product before repairing anything.

The log reports access denied: Confirm you are using an administrator account and run the installer elevated. If the computer is managed, permissions may be controlled by your organization; ask IT rather than changing ownership or permissions of Windows folders.

The log reports a missing or damaged package: Download a fresh copy of the correct installer from the publisher and retry. If setup requests source media, point it to matching installation media rather than a different release.

Repair is unavailable or fails: Record the new error, restart if requested, and check the newest log for the first specific failure. Do not force-remove the product with registry edits or cleanup utilities. Seek support with the logs if the cause is unclear or the instance contains important data.

The error returns after a successful install: Determine whether a later update or another application triggered it. Check Windows Update history and the new setup log; do not assume the SQL Server engine itself is broken if the failed item is a separate tool or prerequisite.

Frequently Asked Questions

What does SQL error 0x80070643 mean?
It means an installation or update operation failed, but the code alone does not say why. The detailed setup log identifies the component and often the underlying error.

Is 0x80070643 always a SQL Server error?
No. It is a general Windows Installer failure code and can appear for SQL Server, SSMS, prerequisites, or unrelated software.

Will repairing SQL Server delete my databases?
A repair is intended to fix installation files, but you should still back up important databases first and verify the instance and data locations. Avoid uninstalling or deleting files as a substitute for repair.

Should I uninstall all SQL Server components?
No. Multiple components may be shared by applications or instances. Remove a component only when the setup log or qualified support guidance identifies it, after backing up data and checking dependencies.

Can I fix the error by reinstalling Windows Installer?
Usually, start with the SQL setup log, Windows Update, a restart, and the correct installer. Replacing Windows Installer files manually is not a safe general fix.

What should I send to support?
Provide the product and SQL version, Windows version, exact error text, failed feature, and the newest setup summary and detail logs. Remove sensitive information before sharing logs outside your organization.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →