In some cases it is not possible to install Connexion using a user with 'sysadmin' privileges. Under this condition, the following manual steps must be performed to configure Connexion:
- Manually create the configuration database. The database name must start with 'CXN_' (default is CXN_Connexion):
- Manually create the message database.
(a) The database name should be the name of the configuration database with '_Default' appended. For example, 'CXN_Connexion_Default'.
(b) You must add an index filegroup named exactly 'INDEX'
- Create / edit your installer user. This is the user you will use to run the Configuration Wizard (this wizard configures/upgrades Connexion and the various databases). This user should have db_owner permissions on the two databases you've created.
- Create / edit your service user. This is the user you will use to run the Configuration service. This user should have reader/writer permissions on the two databases you've created.
Run the Configuration Wizard (under the Install user's account). On the database connections tab, ensure that the 'Install User' account matches the install user account you setup in the database. Ensure that the 'Don't Create...' checkbox is checked.
Windows Authentication
If you are using Windows Authentication, the ConfigurationWizard must be run from the Windows Domain Account that has db_owner permissions on the database. Alternatively, you can use the runas command to impersonate this user. Run the following from a Windows command prompt:
runas /user:MyUser ConfigurationWizard.exe
The configuration wizard should now proceed as normal and configure and start the Connexion service.