Note: Requires 14.5R5, or higher.
By default, the Connexion installer will perform the following database operations that require sysadmin access to the database server:
...
- Manually create the configuration database. The database name must start with 'CXN_' (default is CXN_Connexion):
| Info | ||
|---|---|---|
| ||
Note that by default, Connexion uses the SIMPLE recovery model. You may wish to modify your databases to use SIMPLE instead of FULL as point-in-time recovery is typically not required. |
- Manually create the message database.
...
| Code Block | ||||
|---|---|---|---|---|
| ||||
Use [CXN_Connexion] <-- enter the name of the config database you created GRANT EXECUTE TO [NICKWORK-PC\__cxne_user__] <-- enter the name of the Connexion service account Use [CXN_Connexion_Default] <-- enter the name of the message database you created GRANT EXECUTE TO [NICKWORK-PC\__cxne_user__] <-- enter the name of the Connexion service account |
| Info | ||
|---|---|---|
| ||
Please also note that the backup and maintenance routines require higher permissions. It is expected that you will be taking over these operations and disabling them within Connexion by unchecking the backup / maintenance routines in the 'Server Connections' screen (second icon from top-left). |
...