SQL Always On Availability Groups Part 4: Enable Always On + Create the Database
SQL Server is installed on both nodes (Part 2) and the WSFC is up (Part 3). Two more prerequisites before we can build the AG itself: Enable the Always On…
Tag: SSMS
SQL Always On Availability Groups Part 2: Install SQL Server 2022 + SSMS
With both VMs built and joined to the domain in Part 1, the next step is installing SQL Server 2022 + SQL Server Management Studio (SSMS) on both nodes. Identical…
SQL Server FCI Part 11 of 13: Installing SQL Server & SSMS on the Third Node
Node-03 is in the Windows cluster (Part 10) but has no SQL binaries. This part installs SQL Server in Add Node mode on Node-03 — functionally identical to Part 7…
SQL Server FCI Part 7 of 13: Adding the Second Node (Node-02) — Real HA Begins
SQL Server is installed on Node-01 only — that’s technically a single point of failure dressed up as a cluster. This part fixes that. We run the same setup.exe on…
SQL Server FCI Part 6 of 13: Installing FCI on Primary Node (Node-01)
The big moment. Five parts of plumbing — networks, SAN, initiators, cluster, validation — have led here. Now we install SQL Server itself, but in a special mode: Failover Cluster…