Required Sql Server Permissions

During installation Connexion normally requires administrative level permissions on the Sql Server instance to create databases, and set up some basic permissions. Below are a list of required permissions.

Connexion User Permissions on Server

1. If Connexion is managing its own backups

   1. VIEW SERVER STATE

   2. Member of db_datareader on msdb

   3. Member of db_backupoperator

2. Active/Passive Connexion Install (more than 1 Application Server)

   1. EXECUTE on sp_getapplock and sp_releaseapplock stored procedures

Conneixon User Permissions on Connexion Databases

1. db_owner (preferred), or db_datareader/db_datawriter