Security Framework Service and SQL Database

The Security Framework Service (SFS) uses SQL database. ControlSuite supports SQL Server, SQL Express, Azure SQL, and SQLite for certain cases. Depending on your needs, SFS and ControlSuite components can be deployed on a single server for small installations or distributed across multiple servers and geographies to ensure a highly available solution.

Single SFS node deployment

For small deployments, a single node is recommended with SFS and SQL resources located on the same node. In this case, SQL Express or SQLite can be used. Some ControlSuite configurations require SFS but do not need the full SQL capabilities, so an internal SQLite database is recommended.

Multi SFS node deployment

For medium-sized configurations, a multi-node deployment is recommended. In this case, one node with SFS is sufficient, and the SQL resources can be located on the same node as SFS or on different node.

For large and multi-geographic configurations, a multiple SFS node deployment is recommended. In this case, all SFS nodes work with a single SQL resource. SQL Server or Azure SQL are recommended in such cases.