Training
Module
Perform post-installation configuration of Windows Server - Training
Perform post-installation configuration of Windows Server
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
This article describes the procedure to remove a partial installation of SQL Server.
Original product version: SQL Server
Original KB number: 955404
When you try to reinstall an instance of SQL Server after it fails to install the first time on the same server, you may notice that the second attempt also results in failure.
This problem occurs because after the first installation fails, a partly installed instance of SQL Server exists on the server. The SQL Server Setup program doesn't roll back the installation if the installation fails. The partly installed instance doesn't include the edition of SQL Server that you were trying to install, such as the Enterprise edition, the Standard edition, or the Evaluation edition. When you try to install the same version on the same server, the Setup program finds the existing instance. However, the Setup program can't determine which version of SQL Server to install. Therefore, the installation fails.
Use the following procedure to resolve the problem:
Ensure you have valid backups of databases for each of the SQL instance on the system.
Navigate to Summary.Txt file setup log file and note down the setup command suggested by the setup program.
Using an elevated command prompt, navigate to the location of 'setup.exe' for <SQL Version upgrading to> installation media directory and execute the command from Step 2.
Note
It's very important to ensure you are running the commands against the right instance or else you may end up uninstalling a working instance.
Launch the Installation Center wizard GUI from either the SQL Server Program group or by rerunning the setup program.
Navigate to the Tools menu and select the Installed SQL Server features discovery report and verify there are no more <instance name>.INACTIVE instances shown in the report.
Retry the setup program that was originally failing to complete.
Note
If you still see inactive instances in the discovery report even after the above procedure, use the procedure documented in the How to Fix a failed SQL 2005, 2008, R2 or 2012 Install/Upgrade - MSSQLSERVER.INACTIVE to fix the partial SQL Server installation on the system.
Training
Module
Perform post-installation configuration of Windows Server - Training
Perform post-installation configuration of Windows Server
Documentation
Uninstall a Cumulative Update from SQL Server - SQL Server
This article describes how to remove a Cumulative Update from a stand-alone instance of SQL Server.
View and Read SQL Server Setup Log Files - SQL Server
This article describes the log files that SQL Server Setup creates. Log files are placed in a dated and time-stamped folder.
Repair a failed SQL Server installation - SQL Server
Follow these steps to repair an installation of SQL Server Standard, Developer, and Enterprise edition.