none
Uninstall SQL Server 2008 R2;

    Question

  • Hi How do i go about UNinstalling SQL 2008 R2 from a node in a 2 node cluster completely? The first install on the node failed for a bad SQL Server ip address and when I try to install it again , I noticed the SQL Server Services in the service control panel, and Installer logs says SQL Server Database engine is installed on the node.

    However SQL Installed fine on the secondary node. Any help is greatly appreciated.

    Thanks

     

    This is from Details_Componentupgrade.txt

    2011-07-13 17:40:24 Slp: Skipping Action: FinishPage

    2011-07-13 17:40:24 Slp: Action is being skipped due to the following restrictions: 

    2011-07-13 17:40:24 Slp: Condition "Is the user's scenario set to EditionUpgrade" did not pass as it returned false and true was expected.

    2011-07-13 17:40:24 Slp: ----------------------------------------------------------------------

    2011-07-13 17:40:24 Slp: Skipping property RequireMode of class: StopAction

    2011-07-13 17:40:24 Slp: Input of property will not be set due to the following failed restriction(s): 

    2011-07-13 17:40:24 Slp: Condition "Is the user's scenario set to ComponentUpdate" did not pass as it returned true and false was expected.

    2011-07-13 17:40:24 Slp:

     

    Overall summary:

      Final result:                  Passed

      Exit code (Decimal):           0

      Exit message:                  Passed

      Start time:                    2011-07-13 17:38:02

      End time:                      2011-07-13 17:39:41

      Requested action:              RunRules

     

    Cluster properties:

      Machine name: MACHINEONE

      Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered 

      Sql Server 2008 R2   A                    MSSQL10_50.A                Database Engine Services                    1033                 Enterprise Edition   10.50.1600.1    No        

      Sql Server 2008 R2   A                 MSSQL10_50.A                SQL Server Replication                         1033                 Enterprise Edition   10.50.1600.1    No        

      Sql Server 2008 R2   A                    MSSQL10_50.A                Full-Text Search                            1033                 Enterprise Edition   10.50.1600.1    No        

      Sql Server 2008 R2                                                       Management Tools - Basic                 1033                 Enterprise Edition   10.50.1600.1    No        

      Sql Server 2008 R2                                                       Management Tools - Complete              1033                 Enterprise Edition   10.50.1600.1    No        

      Sql Server 2008 R2                                                       Client Tools Connectivity                1033                 Enterprise Edition   10.50.1600.1    No        

      Sql Server 2008 R2                                                       Client Tools Backwards Compatibility     1033                 Enterprise Edition   10.50.1600.1    No        

      Sql Server 2008 R2                                                       Client Tools SDK                         1033                 Enterprise Edition   10.50.1600.1    No        

      Sql Server 2008 R2                                                       Integration Services                                          Enterprise Edition   10.50.1600.1    No        

     

      Machine name: MACHINETWO

      Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered 

      Sql Server 2008 R2   A                 MSSQL10_50.A                Database Engine Services                                      Enterprise Edition   10.50.1600.1    Yes       

      Sql Server 2008 R2   A MSSQL10_50.A                SQL Server Replication                                        Enterprise Edition   10.50.1600.1    Yes       

      Sql Server 2008 R2   A                 MSSQL10_50.A               Full-Text Search                                              Enterprise Edition   10.50.1600.1    Yes       

      Sql Server 2008 R2                                                       Management Tools - Basic                 1033                 Enterprise Edition   10.50.1600.1    No        

      Sql Server 2008 R2                                                       Management Tools - Complete              1033                 Enterprise Edition   10.50.1600.1    No        

      Sql Server 2008 R2                                                       Client Tools Connectivity                1033                 Enterprise Edition   10.50.1600.1    No        

      Sql Server 2008 R2                                                       Client Tools Backwards Compatibility     1033                 Enterprise Edition   10.50.1600.1    No        

      Sql Server 2008 R2                                                       Client Tools SDK                         1033                 Enterprise Edition   10.50.1600.1    No        

      Sql Server 2008 R2                                                       Integration Services                     1033                 Enterprise Edition   10.50.1600.1    No        

     

    Machine Properties:

      Machine name:                  MACHINEONE

      Machine processor count:       24

      OS version:                    Windows Server 2008 R2

      OS service pack:               

      OS region:                     United States

      OS language:                   English (United States)

      OS architecture:               x64

      Process architecture:          64 Bit

      OS clustered:                  Yes

     

    Product features discovered:

      Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered 

      Sql Server 2008 R2   A                 MSSQL10_50.A                Database Engine Services                 1033                 Enterprise Edition   10.50.1600.1    No        

      Sql Server 2008 R2   A                 MSSQL10_50.A                SQL Server Replication                   1033                 Enterprise Edition   10.50.1600.1    No        

      Sql Server 2008 R2   A                 MSSQL10_50.A                Full-Text Search                         1033                 Enterprise Edition   10.50.1600.1    No        

      Sql Server 2008 R2                                                       Management Tools - Basic                 1033                 Enterprise Edition   10.50.1600.1    No        

      Sql Server 2008 R2                                                       Management Tools - Complete              1033                 Enterprise Edition   10.50.1600.1    No        

      Sql Server 2008 R2                                                       Client Tools Connectivity                1033                 Enterprise Edition   10.50.1600.1    No        

      Sql Server 2008 R2                                                       Client Tools Backwards Compatibility     1033                 Enterprise Edition   10.50.1600.1    No        

      Sql Server 2008 R2                                                       Client Tools SDK                         1033                 Enterprise Edition   10.50.1600.1    No        

      Sql Server 2008 R2                                                       Integration Services                                          Enterprise Edition   10.50.1600.1    No        

     

    Package properties:

      Description:                   SQL Server Database Services 2008 R2

      ProductName:                   SQL Server 2008 R2

      Type:                          RTM

      Version:                       10

      SPLevel:                       0

      Installation location:         \\venus\dba\SQL2K8_R2\x64\setup\

      Installation edition:          ENTERPRISE

     

    User Input Settings:

      ACTION:                        RunRules

      CONFIGURATIONFILE:             

      ENU:                           True

      FARMACCOUNT:                   <empty>

      FARMADMINPORT:                 0

      FARMPASSWORD:                  *****

      FEATURES:                      

      HELP:                          False

      IACCEPTSQLSERVERLICENSETERMS:  False

      INDICATEPROGRESS:              False

      INSTANCENAME:                  <empty>

      PASSPHRASE:                    *****

      QUIET:                         False

      QUIETSIMPLE:                   False

      RULES:                         GlobalRules

      UIMODE:                        Normal

      X86:                           False

     

      Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110713_173800\ConfigurationFile.ini

     

    Detailed results:

     

    Rules with failures:

     

    Global rules:

     

    There are no scenario-specific rules.

     

    Rules report file:               C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110713_173800\SystemConfigurationCheck_Report.htm

     

    Thanks

     

    Thursday, July 14, 2011 1:09 AM

Answers

  • Try this link http://msdn.microsoft.com/en-us/library/ms191545(v=SQL.105).aspx

    To remove a node from an existing SQL Server failover cluster

    1. Insert the SQL Server installation media. From the root folder, double-click setup.exe. To install from a network share, navigate to the root folder on the share, and then double-click Setup.exe. If the Microsoft SQL Server 2008 Setup dialog box appears, click OK to install the prerequisites, then click Cancel to quit the SQL Server installation.

    2. Windows Installer 4.5 is required, and may be installed by the Installation Wizard. If you are prompted to restart your computer, restart and then start SQL Server Setup.exe again.

    3. When prerequisites are installed, the Installation Wizard launches the SQL Server Installation Center. To remove a node to an existing failover cluster instance, click Maintenance in the left-hand pane, and then select Remove node from a SQL Server failover cluster.

    4. The System Configuration Checker will run a discovery operation on your computer. To continue, click OK. Setup log files have been created for your installation. For more information about log files, see How to: View and Read SQL Server Setup Log Files.

    5. The Installation Wizard installs SQL Server prerequisites if they are not already on the computer. They include the following:

      • SQL Server Setup Support Files

      To install prerequisites, click Install.

    6. The System Configuration Checker verifies the system state of your computer before Setup continues. After the check is complete, click Next to continue.

    7. On the Cluster Node Configuration page, use the drop-down box to specify the name of the SQL Server failover cluster instance to be modified during this Setup operation. The node to be removed is listed in the Name of this node field.

    8. The Ready to Remove Node page displays a tree view of options that were specified during Setup. To continue, click Remove.

    9. During the remove operation, the Remove Node Progress page provides status.

    10. The Complete page provides a link to the summary log file for the remove node operation and other important notes. To complete the SQL Server remove node, click Close. For more information about Setup log files, see How to: View and Read SQL Server Setup Log Files.


    Regards, Ashwin Menon My Blog - http:\\sqllearnings.wordpress.com
    • Marked as answer by SQL_Jay Monday, July 18, 2011 1:46 PM
    Monday, July 18, 2011 6:56 AM

All replies

  • you removed the resources by the cluster administrator or the SQL Server installer?
    MCP | MCTS | MCITP - DBA SQL Server Sênior www.dbaninja.com | www.cleverdata.com.br
    Thursday, July 14, 2011 2:45 PM
  • I tried from SQL Server Installer.
    Friday, July 15, 2011 6:56 PM
  • Try this link http://msdn.microsoft.com/en-us/library/ms191545(v=SQL.105).aspx

    To remove a node from an existing SQL Server failover cluster

    1. Insert the SQL Server installation media. From the root folder, double-click setup.exe. To install from a network share, navigate to the root folder on the share, and then double-click Setup.exe. If the Microsoft SQL Server 2008 Setup dialog box appears, click OK to install the prerequisites, then click Cancel to quit the SQL Server installation.

    2. Windows Installer 4.5 is required, and may be installed by the Installation Wizard. If you are prompted to restart your computer, restart and then start SQL Server Setup.exe again.

    3. When prerequisites are installed, the Installation Wizard launches the SQL Server Installation Center. To remove a node to an existing failover cluster instance, click Maintenance in the left-hand pane, and then select Remove node from a SQL Server failover cluster.

    4. The System Configuration Checker will run a discovery operation on your computer. To continue, click OK. Setup log files have been created for your installation. For more information about log files, see How to: View and Read SQL Server Setup Log Files.

    5. The Installation Wizard installs SQL Server prerequisites if they are not already on the computer. They include the following:

      • SQL Server Setup Support Files

      To install prerequisites, click Install.

    6. The System Configuration Checker verifies the system state of your computer before Setup continues. After the check is complete, click Next to continue.

    7. On the Cluster Node Configuration page, use the drop-down box to specify the name of the SQL Server failover cluster instance to be modified during this Setup operation. The node to be removed is listed in the Name of this node field.

    8. The Ready to Remove Node page displays a tree view of options that were specified during Setup. To continue, click Remove.

    9. During the remove operation, the Remove Node Progress page provides status.

    10. The Complete page provides a link to the summary log file for the remove node operation and other important notes. To complete the SQL Server remove node, click Close. For more information about Setup log files, see How to: View and Read SQL Server Setup Log Files.


    Regards, Ashwin Menon My Blog - http:\\sqllearnings.wordpress.com
    • Marked as answer by SQL_Jay Monday, July 18, 2011 1:46 PM
    Monday, July 18, 2011 6:56 AM