Installation
Prerequisites
SQL Server Requirements
7 min
this section outlines the core requirements and recommendations for microsoft sql server when hosting the activate database meeting these requirements ensures reliable performance, full functionality, and compatibility with activate components sql server activate uses microsoft sql server to store configuration data, workflows, and historical information sql server can be installed locally on the activate server or hosted remotely on shared database infrastructure, provided the connection offers reliable performance a supported version of sql server must be available—either installed locally or provided as part of a shared sql server instance for test or uat environments, sql server express is an appropriate and lightweight option sql server access the sql server host requires configuration to allow either the activate administrators group connection access to the activate db and\or direct connection rights granted to activate orchestrator account activate web service account activate administrators ad accounts for information on using azure sql database please refer to docid\ g593bjsgldqmgvdxpyx4r sql server version supported sql server versions are {{supportedsqlversions}} database configuration – identity cache setting activate requires sql server 2017 or newer after creating the activate database, run the following command to disable identity caching alter database scoped configuration set identity cache = off this change prevents gaps in identity values that can occur if the sql server service restarts unexpectedly continuous identity sequences are required for activate’s data integrity and internal processes this setting is mandatory for all activate installations on sql server 2017 or above sql server express smaller organisations may choose to use microsoft sql express – please refer to microsoft’s knowledge article on the limits of sql express activate is supported on sql express provided the database size limits are not exceeded this is not recommended for organisations with large folder structures or other large data sets sql server database sql connection rights the activate orchestrator and web service accounts (see the active directory requirements section above) must be able to remotely connect to the sql server and the activate database these active directory accounts must have sql connection rights to the sql server hosting the activate database the database can be created in two ways pre created the database is pre created on the sql server prior to the installer being run the activate database collation must match the collation of the tempdb on the sql server hosting the activate db activate recommends that the account used to install activate have explicit dbo rights to the sql database automatically created the database is automatically created using default settings during the installation the installation account must have sql rights to create a database on the selected sql server during the activate installation, a sql database role will be created for the activate database named activate administrator and the selected ad group for activate administrators during the installation wizard will be added as a member of this role sql server management studio please ensure the microsoft sql server management studio is installed on the activate provisioning server