How to install Always On SQL Server on a cluster after setting up a separate cluster on Windows Server 2022?

Question

Hello All!

Without using Active Directory, I need to deploy a separate cluster environment to deploy SQL Server Always On. According to the documentation, I first changed the suffixes of the two servers to the same domain name such as xxx.com. There are two machines, A.xxx.com and B.xxx.com, and I added DNS resolution on the DNS server (firewall), and they can access each other through the machine name + suffix. Then I added their respective administrator user passwords to each other’s Credential Manager-Windows Credentials, and turned on Lan Manager authentication, with the level set to send LM & NTLM - negotiable for NTLMv2. After running the Test-WSMan -ComputerName <> and Enter-PSSession -ComputerName <> commands in PowerShell respectively, both were successful, indicating that they already have administrator privileges on each other’s servers. I created a separate cluster using the New-Cluster -Name YunLengCluster -Node A, B -StaticAddress 10.50.56.20 -NoStorage -AdministrativeAccessPoint DNS command (according to the documentation, a separate cluster can only be created using PowerShell). After successfully creating the cluster, I opened the SQL SERVER 2022 installer and used “New SQL Server Failover Cluster Installation”. During the check for installation conditions, it reported “Cluster_VerifyForErrors”, indicating “The cluster has not been verified or errors or failures have been reported in the verification report. Please refer to KB953748 or SQL Server Books Online for details.”. How do I deploy SQL SERVER 2022 Always On in a non-Active Directory environment?

Answer 1

You can install always on with workgroup. Install Windows cluster with your two servers, joined the same workgroup and ınstall always on