Content Comparison

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):

• Manually create the message database.

...

If the user currently running the Configuration wizard has DBO access to the Connexion database(s) you have created, then you can use the "Current User" option in the 'Database Connexions' tab:

...

If your current user does not have DBO access to the Connexion database(s), you can provide the credentials of a Windows/Domain account which does. Please note that this account must be valid on the current machine (meaning that if it's a Windows user, this user must exist locally. If you provide a domain user, the current machine must be joined to the domain).

You can alternately provide SQL Server credentials via the 'SQL Server Authentication' option.

Once the configuration wizard has successfully run, YOU MUST GRANT STORED PROCEDURE EXECUTE PERMISSIONS TO THE SERVICE USER MANUALLY. The following statement will do this:

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

Image Added