Versions Compared

Old Version 2

changes.mady.by.user Evgeniya Kononova

Saved on

compared with

New Version 3

changes.mady.by.user Darya Andryieuskaya

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Store the Configuration database on the MS SQL server. If the MS Access is used to store the database, it is strongly recommended to install the MS SQL server and to convert the database from MS Access to MS SQL format.

    Info
    titleNote

    It is recommended to configure the automatic backup of Axxon PSIM database in MS SQL Server, for example, once a week (by default, the automatic backup is not configured).


  2. The Servers and Remote Admin Workstation databases should be synced with the Administration server database.
  3. If long-term centralized storage is necessary for registered system events, then it is recommended to apply Axxon PSIM software configuration on the Servers and the Remote Admin Workstations in order to store the events in the Events log database separately from the Configuration database.

  4. In case the Dynamic Host Configuration Protocol (DHCP) is used, make sure that the TCP/IP protocol priority for local databases is the highest. Otherwise, when the network cable is disconnected, the communication between the Axxon PSIM and its local database located on the same computer where Axxon PSIM is installed can be lost. To view and prioritize the network protocols, use the SQL Server Configuration Manager utility:

    1. Run the SQL Server Configuration Manager utility (Start -> All Programs -> Microsoft SQL Server Express 2014 -> Configuration Tools).

    2. In the right part of the utility's interface window, click the header of the SQL Native Client Configuration list, and then select the Client Protocols item in the drop-down list. In the left part of the window, right-click any protocol in the list and select the Order item in the context menu that appears.
      Image Modified

    3. In the Client Protocols Properties dialog box that appears, the list of client protocols for the local SQL databases in descending priority order is displayed in the Enabled Protocols field. Make sure that the TCP/IP item is located at the very top of the Enabled Protocols list. Also make sure that the Enable Shared Memory Protocol checkbox is set.
      Image Modified
    4. If the TCP/IP item is not at the very top of the Enabled Protocols list, use the Up button to move it to the top of the list.
      Image Modified