Run the SQL Server and database on a separate server

Milestone recommends that you make the SQL Server and database redundant. This reduces the risk of real or perceived downtime.

To support Windows Server Failover Clustering (WSFC), Milestone recommends that you run the SQL Server and database on a separate server, and not on the management server.

SQL Server must run in WSFC setup, and the management and event servers must run in a Microsoft Cluster setup (or similar technology). For more information about WSFC, see Windows Server Failover Clustering (WSFC) with SQL Server (https://msdn.microsoft.com/en-us/library/hh270278.aspx).

Learn more

The following control(s) provide additional guidance:

• NIST 800-53 SC-7 Boundary Protection
• NIST 800-53 CM-9 Configuration Management Plan