Editing the Synergy.cfg file

Modified on Sun, 19 Apr at 11:55 PM

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.

Attachments (6)

worddave345f96c97be7a0294454208e1332d18.png
22.6 KB

worddave708a0cd7b60c1973552254de471a3b5.png
15.4 KB

worddaved7b28e12f56e95f89281d01855a5d49.png
9.61 KB

69e1f15376d31.Windows_Explorer_-_navigate_to_the_Synergetic_directory.gif
11 KB

69e1f15376d33.Windows_Explorer_-_open_Synergycfg.gif
29.1 KB

69e1f15376d34.Synergy_cfg_Notepad.gif
24.3 KB