SQL Server

This section describes the configuration of SQL Server as the backend database storage solution for RegScale.

Version Support

RegScale is officially tested and guaranteed to run without issue on the following versions of SQL Server:

• SQL Server 2019
• SQL Server 2017

RegScale should technically work on SQL Server versions 2012, 2014, and 2016 but this is not a supported RegScale configuration. In addition, the following editions of SQL Server are supported:

• Express - recommended for Proof of Concept or small installations. This is the free tier of SQL Server. This is not recommended for large deployments or Production use cases.
• Standard - recommended for Production use cases. Enterprise Edition is also supported but is not generally required except in extremely large deployments (10k+ concurrent users).
• Azure SQL Server - recommended for Production use cases where cloud is desired. The Basic or higher tier should be used when setting up the database.

Recommended Configurations

• Backups/Replicas - recommended to establish backups based on organizational risk tolerance and potentially replicas in other regions/data centers for failover, recommended for Production
• Transparent Data Encryption - enable for encryption of all database data
• Azure SQL Defender - enable for advanced vulnerability assessment and threat detection (only available in Azure), recommended for Production use cases
• Azure Automatic Tuning - enable for automated performance tuning (only available in Azure), recommended for Production use cases

Connecting

Once setup, obtain a SQL Server connection string to allow access from the container/web server of RegScale to the database. If you are unable to connect, ensure that the SQL Server firewall allows traffic from the IP hosting the container/web server.