SQL Server – Uninstall /Remove SQL Server 2012 Failover Cluster Instance

Procedure to uninstall a SQL Server failover clustered instance

To update or remove a SQL Server failover cluster, you must be a local administrator with permission to login as a service on all nodes of the failover cluster.

 

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.
  2. 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.
  3. The System Configuration Checker will run a discovery operation on your computer. To continue, Click OK. .
  4. After you click install on the Setup Support Files page, the System Configuration Checker verifies the system state of your computer before Setup continues. After the check is complete, click Next to continue.
  5. 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.
  6. The Ready to Remove Node page displays a tree view of options that were specified during Setup. To continue, click Remove.
  7. During the remove operation, the Remove Node Progress page provides status.
  8. 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.

 

Screenshots: 

1 2 3 4 5 6 7

 

 

Repeat above steps on all nodes used for the SQL Server clustered instance. Make sure you uninstall the active node last.

Note:    Remove Passive Nodes First and Active node Last.

Advertisements

SQL Server – Installing SQL Server 2012 Cluster

Microsoft Cluster

A Microsoft cluster is a high-availability system designed to keep the database up as much as possible. It does this by resuming processing on the secondary server in the event of a failure on the principal server. Since the data resides on a shared disk, a Microsoft cluster will not survive a data corruption.  This technology is high availability, not disaster recovery. All data resides in the same data center and on the same disk. A cluster can be used with other technologies, such as database mirroring.

 

architechture

 

 

In order to Install SQL Server Cluster, we need to have Windows cluster ready as a base with some other pre-requisites as well. [ Installing Windows Cluster is out of scope of this article.]

1- Windows Cluster

2- DTC

3- SQL

 

prerequisites

 

We then need to setup 2 Network Interfaces to be used in production and the other as a heartbeat.

Once the setup is ready to install SQL Server Cluster. Please follow the below steps to configure 2 Node Active/Passive Cluster[SQL Server 2012].

Installation:

Steps to be performed on Node 1.

1. With the SQL Server installation binaries available, right click “Setup” and run as administrator:

1

 

2

 

2.  Click “Installation” in the left menu, then select “New SQL Server Failover Cluster Installation”

 

3

 

3. A check will run in order to find possible constraints when installing the SQL Server Setup support files. At the end of the check, click “OK”

 

4

 

4. Provide product key for your media. Then Next

5

 

5. Accept License Agreement (and the other check if you would like). Then Next

6

6.  Wait for Setup Support Rules check. Once done make sure no failed task. Evaluate warnings for your environment . Then click Next

 

7

 

7. click SQL Server Feature Installation and click Next.

8

 

8. Select Features to install and click NEXT. I have selected all Features.

9

9. Make sure feature Rule check complete with no Failed status. Then Next

 

 

 

10

10. Provide Network and Instance names. Then Next

 

 

 

11

11. Click Next

 

12

12. Click Next

 

 

13

13. Select Disk needed for the resource group . Then Click Next

 

14

14.  Enable IP4 and provide IP address. Then Next

 

15

 

15. Provide Service Accounts (and Collation if different than default – SQL_Latin1_General_CP1_Cl_AS). Then Next

16 17

16. Now we need to choose the authentication mode of our instance.The options are either “Windows Authentication”, which will take benefit from domain and local server logins, or “Mixed Mode”, which accepts Domain/Windows logins as well as logins created and managed by SQL Server.If you pick “Mixed Mode” a login called “sa”, member of the “Sysadmin” role will be enabled. For this reason we need to specify the password for this login.In the box bellow, we need to add all domain/Windows users that have access to the instance and will be part of the “Sysadmin” fixed server role. You need to use the three buttons to add/remove logins from this list:

 

18

17. Select data directories accordingly for Datafile, log file, tempdb files and backup files and click next.

 

19

18. If you have selected analysis features then on this screen add the administrator account and data directory for analysis service. Then click next

 

20

 

 

21

 

19. Select install only for reporting services and Click Next. You can configure reporting services later.

 

 

 

22

20. Check the error report and click NEXT.

 

 

23

21. Make sure no clusters rules failed. Then Next

 

24

22. Click Install.

 

25 26

 

29

23. Click Close to complete the installation.

 

 

30

 

Check the Failover Cluster Manger. And you would see SQL Service and other dependent resources running under it.

 

31

 

 

Adding Node to cluster will be covered in next post.

https://exploresqlserver.wordpress.com/2014/11/11/sql-server-adding-node-to-sql-server-2012-cluster/

 

 Hope this was helpful !!!

 

Installing SQL Server 2008 R2 Cluster

https://exploresqlserver.wordpress.com/2014/08/17/installing-sql-server-2008-r2-cluster/

 

 

Installing SQL Server 2008 R2 Cluster

Microsoft Cluster

A Microsoft cluster is a high-availability system designed to keep the database up as much as possible. It does this by resuming processing on the secondary server in the event of a failure on the principal server. Since the data resides on a shared disk, a Microsoft cluster will not survive a data corruption.  This technology is high availability, not disaster recovery. All data resides in the same data center and on the same disk. A cluster can be used with other technologies, such as database mirroring.

Below is the SQL Cluster Architechture:

Architechture

 

 

 

In order to Install SQL Server Cluster, we need to have Windows cluster ready as a base with some other pre-requisites as well. [ Installing Windows Cluster is out of scope of this article.]

1- Windows Cluster

2- DTC

3- SQL

Below IPs needs to be reserved well in advance to save yourself some time. IP Addresses and Hostnames can be of your choice.

Prerequisites

 

We then need to setup 2 Network Interfaces to be used in production and the other as a heartbeat.

Once the setup is ready to install SQL Server Cluster. Please follow the below steps to configure 2 Node Active/Passive Cluster[SQL Server 2008 R2].

 

Installation:

Steps to be performed on Node 1.

  1. Run setup.exe from the installation media to launch SQL Server Installation Center. Click on the Installationlink on the left-hand side1
  2. Click the New SQL Server failover cluster installation link. This will run the SQL Server 2008 R2 Setup wizard2

 

3. In the Setup Support Rules dialog box, validate that the checks return successful results and click Next.

3

4. In the Product Key dialog box, enter the product key and click Next.

4

5. In the License Terms dialog box, click the I accept the license terms check box and click Next.

5

6. In the Setup Support Rules dialog box, click Install. Validate that the checks return successful results. If the checks returned a few warnings, make sure you fix them before proceeding with the installation.

8

7. Select the features to install and click Next.

9

 

8. Configure the Network Name ( this is going to be the DB cluster name ) and instances

10

 

9. In the Disk Space Requirements dialog box, check that you have enough space on your local disks to install the SQL Server binaries and click Next.

11

10. Choose your Cluster Resource Group ( or leave to default )

12

 

11. In the Cluster Disk Selection dialog box, select the available disk groups that are on the cluster for SQL Server to use.

13

 

12. In the Cluster Network Configuration dialog box, enter the IP address and subnet mask.

14

 

13. In the Cluster Security Policy dialog box, accept the default value of Use service SIDs (recommended).

15

14. In the Server Configuration dialog box, enter the credentials that you will use for your SQL Server service accounts in the Service Accounts tab. Configure the Service accounts Users and Password as per best practices.

16

 

15.  Select the appropriate Authentication Mode. If you want to add the currently logged on user to be a part of the SQL Server administrators group, click the Add Current User button.

17

16. On the Data Directories tab, enter the path where your system and user database files will be created.

18

17. Install, But do not configure is the only option available as we haven’t installed the pre-requisites for Reporting Service.

19

 

18. Make Sure everything passes on the Cluster installation Rules

21

 

19. Review your install Summary and Click Install

22

 

20. Now wait for the installation to finish

23

 

21. In the Complete dialog box, click Close. Cluster Installation on Node 1 is finished.

24

 

 

Now, start installation on Node 2.

1. Run setup.exe and Click the Add node to a SQL Server failover cluster link

25

2.  Install Support rules and Make Sure all passes.  Few steps are similar to Node 1 Installation

26

27

28

 

30

 

 

31

 

3. You will see that setup has detected the current Single node cluster from above, click Next

 

32

 

4. Enter the same credentials and click Next.

 

33

 

5. Make sure everything is green.

 

 

35

 

6. In the Ready to Update dialog box, verify that all configurations are correct and click Install.

 

36

 

7. In the Complete dialog box, click Close. This concludes installing the passive node of a SQL Server 2008 R2 Failover Cluster

 

39

 

Verifying The Cluster

 

FailoverCluster

 

 

Hope this was helpful.