SQL Server 2008 installation fails when you try to install SQL Server a second time

Article translations Article translations
Article ID: 955404 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

When you try to install Microsoft SQL Server 2008 on a server, the installation fails. When you try to reinstall the same copy of SQL Server 2008 on the same server, this installation also fails.

CAUSE

This problem occurs because after the first installation fails, a partly installed instance of SQL Server 2008 exists on the server. The SQL Server 2008 Setup program does not roll back the installation if the installation fails. The partly installed instance does not include the edition of SQL Server 2008 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 cannot determine which version of SQL Server 2008 to install. Therefore, the installation fails.

RESOLUTION

To resolve this issue, you must uninstall the previous instance of SQL Server 2008 before you try to install SQL Server 2008 again on the same server.

Uninstall SQL Server 2008

To uninstall SQL Server 2008 by using Add or Remove Programs, follow these steps.

Windows Server 2003

  1. Click Start, click Run, type appwiz.cpl, and then press ENTER.
  2. In the list of installed programs, click Microsoft SQL Server 2008, and then click Uninstall.
  3. Follow the instructions that appear on the screen to uninstall SQL Server 2008.

Windows Server 2008

  1. Click Start, type appwiz.cpl in the Start Search box, and then press ENTER.
  2. In the list of installed programs, click Microsoft SQL Server 2008, and then click Uninstall.
  3. Follow the instructions that appear on the screen to uninstall SQL Server 2008.

Manually uninstall SQL Server 2008

To manually uninstall SQL Server 2008, follow these steps:
  1. At a command prompt, type the following command, and then press ENTER:
    CD %ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\Release
  2. Type the following command, and then press ENTER:
    setup.exe /ACTION=uninstall /FEATURES=Feature_List /INSTANCENAME=Instance_Name
    Note In this command, the Feature_List placeholder represents a no-space, comma-separated list of feature values, such as "AS,SQL,RS,Tools." The Instance_Name placeholder represents the named instance of the SQL Server 2008 that was installed. If you did not use a named instance, you can use "MSSQLSERVER" for the named instance.
The following table lists all the parent values and the child values for the /FEATURE parameter:
Collapse this tableExpand this table
Parent FeatureChild Feature Description
SQLInstalls the SQLEngine component, the Replication component, and the Fulltext component.
SQLEngineInstalls only the SQLEngine component.
ReplicationInstalls the Replication component. The SQLEngine component is needed.
FullTextInstalls the Replication component. The SQLEngine component is needed.
ASInstalls all AS components.
RSInstalls all RS components.
ISInstalls all SSIS components.
ToolsInstalls the ToolsClient component and the BOL component.
BCInstalls the Backward-compatibility (BC) tool.
BOL Installs SQL Server Books Online.
BIDSInstalls Business Intelligence Development Studio.
ConnInstalls the Connectivity components.
SSMSInstalls SQL Server Management Studio.
ADV_SSMS
SDKInstalls the Software Development Kit.
For example, if you installed all SQL components, AS, SQL Server Books Online, and SQL Management Studio, you would use the following command:
setup.exe /ACTION=uninstall /FEATURES=SQL,AS,BOL,SSMS /INSTANCENAME=MSSQLSERVER

Properties

Article ID: 955404 - Last Review: March 19, 2009 - Revision: 2.0
APPLIES TO
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Express with Advanced Services
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Standard Edition for Small Business
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
Keywords: 
sql2008relnoteinstallation sql2008relnote kbsetup kbinstallation kbexpertiseinter kbtshoot kbprb KB955404

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com