Thank you for posting in Microsoft Q&A forum.
- Yes, we could build the structure. Please remember the following prerequisites are included in it:
The site database server must be remote from the site server;
The computer account of the site server has Administrators permission in this cluster.
SSL/TLS and PKI certificates requirements when you use a failover cluster instance for the site database.
Please refer the following SQL configure article for more details:
use-a-sql-server-cluster-for-the-site-database - Install an additional site server in passive mode for a standalone primary site. The site server in passive mode is in addition to your existing site server in active mode. A site server in passive mode is available for immediate use, when needed. To make the site server in passive mode become active, you manually promote it. This action switches the site server in active mode to be the site server in passive mode. The site system roles that are available on the original active mode server remain available so long as that computer is accessible. Only the site server role is switched between active and passive modes.
For more details, please refer to this article:
deploy-configure-site-server-high-availability
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.