Editing the Synergy.cfg file

You can configure aspects of Synergetic to suit your organisation's needs, including the:

name and location of the databases Synergetic uses
username, password and server name for Crystal Reports
authentication method for Synergetic
menu background colour.

Important: Never alter configuration files unless you know the full implications of doing so. Changing these configurations incorrectly can cause Synergetic to stop functioning. \

Note: It is strongly recommended that you edit the configuration file within Synergetic. See Edit Synergetic Configuration File [Synergy.cfg] window.

To edit the Synergy.cfg file:

Open Windows Explorer and navigate to the Synergetic directory on the server where Synergetic is installed.
Tip: You can find the directory by selecting Help > About in Synergetic and navigating to the directory displayed in the SynMain.exe Path field.
Right click on the Synergy.cfg file and select Open with....
Select Notepad or Wordpad from the list of programs to open the file with.
The Synergy.cfg file is displayed.
Edit the fields in the table below.

Note: An asterisk ( *** ) at the start of a line tells Synergetic to ignore that line. Make sure you don't add or remove asterisks from important lines.

Synergy.cfg key fields
Note: Make sure you do not change the field names when editing the file.

Field	Description
DATABASE_SERVER	Name of the main database server.
DATABASE_NAME	Name of the main database.
DATABASE_SERVER_ODBC	Name of the main database connector. Note: This information can be found in Windows Control Panel > Administrative Tools > Data Sources (ODBC) of the server that runs Synergetic.
DATABASE_SERVER_PHOTO	Name of the media database server.
DATABASE_NAME_PHOTO	Name of the media database.
DATABASE_SERVER_FINANCE	Name of the finance database server.
DATABASE_NAME_FINANCE	Name of the finance database.
DATABASE_SERVER_ODBC_FINANCE	Name of the finance database connector. Note: This information can be found in Windows Control Panel > Administrative Tools > Data Sources (ODBC) of the server that runs Synergetic.
USER_DATABASE_ODBC_RESERVED	Username to access the reserved server. Note: This information can be found in Windows Control Panel > Administrative Tools > Data Sources (ODBC) of the server that runs Synergetic.
DATABASE_SERVER_ODBC_RESERVED	Name of the reserved server.
NO_APPLICATION_ROLE	If there is no asterisk at the start of this field, do not use SQL Server application roles defined within Synergetic in the finance database. Note: To turn off this field, put an asterisk * at the start of the line. For example: NO_APPLICATION_ROLE. Either this field or the SET_FINANCE_APPLICATION_ROLE* field must have an asterisk at the start.
SET_FINANCE_APPLICATION_ROLE	If there is no asterisk at the start of this field, use roles defined within Synergetic in the finance database. Note: To turn off this field, put an asterisk * at the start of the line. For example: SET_FINANCE_APPLICATION_ROLE. Either this field or the NO_APPLICATION_ROLE* field must have an asterisk at the start.
AUTHENTICATION_METHOD	Authentication mode used by Synergetic: W - Windows Authentication S - SQL Authentication B - Either Windows or SQL Authentication WP - Windows Authentication with password BP - Either Windows or SQL Authentication with password.
SCREEN_BACKGROUND_COLOUR	Background colour of Synergetic menu. See Changing the main menu background colour. Note: To return the menu to its default colour, use the value clBtnFace.
[MESSAGE]	Message to display when logging into Synergetic. Tip: For more flexible messages, including time sensitive messages, see Maintaining system messages.