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.
Comments
Please sign in to leave a comment.