Add SQL Server Named Instance To SQL Server Failover Cluster: Now we have to add the Node 2 (SQLB) to our cluster, so in this article we will see how to add this Node 3 (SQLABFCI) to our Node 2 (SQLB) cluster. What is does is, suppose if the SQLB Node is down then the SQLABFCI Node will server all the request without any issue/interruption.
SQL Server Failover Cluster
Step 1: Open and run the setup file to go on installation page and select the option “Add node to a SQL Failover Cluster” to add SQL Server Named Instance.
Step 2: Select the license type, I don’t have one so I will go with “Developer“
Step 3: Agree to all the terms and conditions of this page.
Step 4: Skip the software update if you have downloaded the latest one and hit next.
Step 5: All the checks and trust will be performed for any error or exceptions; in my case it looks good so I will hit next!
Step 6: Now this is very important to understand, here you will see SQL Server instance name which is “SQLBDB from Node 2 (SQLB)” and Name of the node is “SQLABFCI (SQLABFCI is host name of this node/machine)” so it says that SQLABFCI will be added to SQLB Node as Failover cluster.
Note: I my case the SQLB Node Server is on NAMED instance so you can see this as SQLBDB, if you have installed as DEFAULT instance then you will see “MSSQLSERVER“, which we already we saw in our previous article when we created failover cluster for our first Node (SQLA).
Step 7: The IP will be visible which we have already configured when installing the SQLB Node SQL Server, so you can’t change anything because it is already configured in the cluster, and we are adding this Node 3 (SQLABFCI).
Step 8: The SQL Service account will be configured already as we are adding this node to the cluster, so we have to just specify the password for those accounts.
Step 9: All the steps and option we selected will be visible, just hit next and proceed further.
Step 10: Once the installation is done you will see this below message and if you see any kind of error, then this tick box will not be present, and you have to check the logs files for any short of errors and later fix it.
Step 11: Now, I have installed the SSMS in this node as well and I will connect to the SQLBDB cluster which is our SQL Cluster network name.
This time if I type just the SQLB machine/Node name it will not work because it is not defaulting instance hence, we have to specify SQL Server hostname followed by slash and then SQLBDB Cluster Network Name, as show in the below image.
Testing Our SQLFCI
Now we have successfully installed the SQL Server failover cluster, and it is ready to be tested. If you want to test it, then turn off your Node 2 (SQLB) and connect to the SQL Cluster name (SQLBDB) and you will see the owner will change to SQLABFCI in the Failover Cluster Node. For more about SQL FCI click here!
In this below image you can see that when I turned off my SQLB Node it moved the SQLABFCI.
When I again turned on the SQLB Node it moved back to SQLB. This ends the article for Adding SQL Server Named Instance To Failover Cluster.
END OF SQL SERVER Failover Cluster Configuration
TSG’s
- The Job Failed. Unable To Determine If The Owner (KTTsvc_ssrs19) Of Job
- Port Number For Analysis Services – Find Ports For SSAS? (kingfishertechtips.in)
- SMTP Server In SSRS/PBIRS |Subscribe To Email Problem/Issue (kingfishertechtips.in)
- SQL Server 2022 Download, Install, Connect Using SSMS Tool (kingfishertechtips.in)
- Creating Tabular Project & Deploy Model To Analysis Service (kingfishertechtips.in)
- Deploy Tabular Project To Azure Analysis Service – SSDT Tool (kingfishertechtips.in)
- SSRS/PBIRS – Install And Configure The Report Server On-Prem (kingfishertechtips.in)
- Could Not Load Folder Contents In Portal URLs – SSRSPBIRS (kingfishertechtips.in)
- SSRS/PBIRS – Install And Configure The Report Server On-Prem (kingfishertechtips.in)
- SQL Server 2022 Download, Install, Connect Using SSMS Tool (kingfishertechtips.in)
- Capture Fiddler Trace for Debugging the Network Traffic (kingfishertechtips.in)
- On-Premises Gateway: Configure/Map SQL DB To Power Bi (kingfishertechtips.in)
- Fixed Column/Row Header Make Visible In Any Report (kingfishertechtips.in)
- Self-Signed Certificate: Configure SSRS/PBIRS With SSL (kingfishertechtips.in)
- Create Local User Account/Local Admin User In Windows 10/11 (kingfishertechtips.in)
- Login With AAD/Domain/Microsoft Account To Azure VM’s/RDP (kingfishertechtips.in)
