I have this requirement to Create a SQL Cluster in the DMZ environment , from what my understanding is for setting up a SQL cluster , the primary requiremnt is that the 2 nodes should be a part of the Domain to set up the cluster , also
the Cluster service accounts should be a part of Domain . is there a possibiliy to create a SQL Cluster in DMZ environment if so is there some documentation that can give some guidance in setting it up?
It is possible to deploy the SQL Server cluster instance within a domain in the DMZ environment. One thing you may pay attention to is to open a series of firewall ports to allow the communication between the perimeter network and the internal domain. For
more information, please have a look at this blog:
RD Gateway deployment in a perimeter network & Firewall rules.