SQL Server – Query/Command to check the nodes of SQL Cluster Instance

To check the current node/Active Node where the SQL Instance is running, you can execute the below query.

select serverproperty(‘ComputerNamePhysicalNetBIOS’)

1

 

To find out all the nodes of the SQL Cluster, you can use the below DMV.

select * from sys.dm_os_cluster_nodes

2

 

To find out if the instance is clustered, you can use below query, if it returns 1, then the instance is clustered

select ‘IsClustered’, serverproperty(‘IsClustered’)

3

 

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.

SQL Server – Adding Node to SQL Server 2012 cluster

Adding Node to SQL Server 2012 cluster

This is part 2 of earlier post. Installing SQL Server 2012 Cluster

https://exploresqlserver.wordpress.com/2014/11/11/sql-server-installing-sql-server-2012-cluster/

 

 

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

2

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

 

23

3. Make sure nothing has failed in Setup Support Rules. Then Click Next.

 

4

4. Enter the product Key and click Next

 

5

5. Accept License Terms and click Next.

 

 

6

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

 

7

 

8

7. Enter Service account credentials and click NEXT.

 

9

8. Click Next

 

 

10

9. Make sure nothing had failed in Add Node Rules check. Then click Next.

 

 

11

10. click Install.

 

 

 

12 13

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

 

 

 

14

 

 

 

SQL Server – How to configure MSDTC in Windows Server 2012 Cluster

Below are the steps to configure MSDTC in Windows Server 2012 Cluster:

1. Open Failover Cluster Manager and Right-click on Roles and pick the “Configure Role” option.

1

2. Choose the option “Distributed Transaction Coordinator (DTC)” from the list. Click  “Next”.

2

 

3. Provide Name and IP for new role selected (Distributed Transaction Coordinator)

3

 

4. Select the Disk to be used for MSDTC

4

 

5. Review the configuration and confirm by clicking next.

5

 

6. The installation will run and in the last step you will show summary report. Click “Finish”.

6

 

7. Now you will be able to see a DTC role in the Failover Cluster Manager.

7

 

 

Hope this was helpful !!!