Setting up IDERA TeamServer Database inSQL Server Availability Groups! – Part 1

by May 18, 2023

Setting up IDERA TeamServer Database in SQL Server Availability Groups! – Part 1

Howdy!! Folks!

As promised.. I have successfully managed to setup an HA SQL Server AlwaysOn Availability Group for our Flagship Solution, IDERA Team Server’s Repository Database using Microsoft SQL Server!

This setup is meant to be in a Lab / test environment only!

[Setup]

  1. VMware Workstation using Host Only Network
  2. Domain Controller VM with Windows Failover Clustering Enabled
  3. Two Windows Server 2022 VMs running SQL Server Enterprise Edition with Windows Failover Clustering Feature Enabled
  4. Just a little patience 😉

[DC Setup]

  1. Install Windows Server 2022
  2. Assign a Computer Name and static IP
  3. Promote it to a Domain Controller
  4. Reboot
  5. Login as the Domain Administrator
  6. Install Failover Clustering Feature

 

[SQL Node 1 and 2 Setup]

  1. Install Windows Server 2022
  2. Assign a Computer Name and static IP
  3. Join it to a Domain Controller
  4. Reboot
  5. Login as the Domain Administrator
  6. Install Failover Clustering Feature
  7. Reboot
  8. Install SQL Server 2022 on it with just the Database option feature
  9. Install SSMS
  10. Assign it a Windows only / Mixed Auth, your choice, I chose Windows Auth
  11. Launch SQL Server Configuration Manager and choose SQL Server Service –> Properties, Click on the Always On Availability Group tab and click on the Checkbox to enable it.
  12. Restart the SQL Server Services and Agent Services Add Port 1433 and 5022 Firewall Ports

 

[On DC –> Creating and Configuring the Cluster]

  1. Launch the Failover Cluster Manager and prepare the two SQLNodes to be joined.
  2. Follow the on screen instructions.
  3. Once the cluster is configured and completed, head over to SQL Node1

[Creating the AG on SQLNode1]

  1. Connect to the SQL Server box using your Auth of Choice, I have chosen Windows Authentication
  2. Restore the WideWorldImporters Database, you can find it on SQLServerSamples at Github
  3. Take a Full Backup –> It will be in Simple Recovery, Make sure it’s in Full Recovery
  4. Now we are ready to begin the AlwaysON Setup
  5. We will be using the AlwaysON Availability Group Wizard
  6. We will first make sure we can failover the WideWorldImporters Database

Run the Wizard and follow the onscreen instructions.

Once completed, refresh your AlwaysOn AG Folder to see the successful deployment

The WideWorldImporters database are on both Nodes.

Let us now perform a manual Failover.

Right Click on the SQLAG and choose Failover

It will prompt to prompt to failover from Node 1 to Node 2

 

Now failing back over to Node1 to complete Part 1 of this article.