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 dbo permissions on the two databases you've created. Please note that if you're using a Windows/Domain user, you will need to run the Configuration Wizard under this users account. You can do this by logging into the target machine using this user's credentials, or by launching an admin command prompt and using the runas /user:MyUser ConfigurationWizard.exe syntax.
- 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.
