Modules > System > Setup > Settings – Database > Connection setting
This page allows you to change the database connection mode between AppRole and SQL Login for Exact Synergy Enterprise.
To change the database connection setting, the Administrator role and Administrator rights for Exact Synergy Enterprise and the relevant databases are required.
Note:
The information in this document is applicable to product update 257 and higher. If you have versions lower than this, certain features explained here will not be applicable.
It is recommended that you back up the Exact Synergy Enterprise SQL server database in case any of the following steps encounters errors.
Click this to exit.
Click this to save the changes.
This setting determines how Exact Synergy Enterprise will access the database. Select any of the following:
Note: If the SQL Login option is selected, the Modules ? System ? Setup ? Settings – Database ? Update database password menu path will be displayed. For more information, see Changing database passwords.
This section specifies the user account that is used to log in to the database so that the database connection setting can be changed. The user account must have the Administrator rights to the database.
Select this check box to use the integrated security. This is the type of authentication that will be used to access the database. If this check box is not selected, SQL authentication is required.
Type the user name of the SQL Login user.
Note: This is enabled only if the Integrated security check box is not selected.
Type the password of the SQL Login user.