Understanding the permission needed to create an Agility database

This feature is available in all editions

Question

For my on-premise installation of Agility, what database rights are required if my DBA creates our database?

Answer

When installing Agility with an existing database, the Windows/SQL account used for setup needs fewer SQLServer rights, as it does not need to create a new database. To allow setup to create Agility database schema, modify database configuration settings (see below), and populate it with application data, the account used (either the individual running setup or a SQL login specified during setup) must be a user on the Agility database and a member of the db_owner database role.

Note that any upgrades to Agility also require that the account used during setup be db_owner on the Agilitydatabase.

Agility Database Configuration

The Agility application requires its database to be configured as follows:

ALTER DATABASE [{database}] SET
ARITHABORT ON,
CONCAT_NULL_YIELDS_NULL ON,
QUOTED_IDENTIFIER ON,
ANSI_NULLS ON,
ANSI_PADDING ON,
ANSI_WARNINGS ON,
NUMERIC_ROUNDABORT OFF

If not already set to these values, they will be updated when the setup executes.