Page History

To provide the effective and steady stable performance of the of Axxon PSIM system, take into account the following recommendations on using the database use below:

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

1. You must synchronize the databases of servers and Remote Administrator Workstations with the administration server database to provide the ability of the centralized administering of the video surveillance and audio control system.

   Info
   title Note

It is recommended to configure

2. We recommend configuring the automatic backup of the Axxon PSIM database in MS SQL Server, for example, once a week (by default, the automatic backup

is not

3. isn't configured).

4. The Servers and Remote Admin Workstation databases should be synced with the Administration server database.
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 
5. If you want to store the registered events in the system in a centralized way during the long-term period, we recommend configuring Axxon PSIM on servers and Remote Administrator Workstations to store events in the Events log database separately from the Configuration
 database.In case the Dynamic Host Configuration Protocol 
6. database (see Extracting event protocol into an individual database).

7. If you use the protocol of the dynamic host configuration (DHCP)

is used

8. , make sure that the TCP/IP protocol priority for local databases is the highest. Otherwise,

when

9. if you disconnect the network cable

is disconnected

10. , the communication

between the

11. between Axxon PSIM and its local database located on the same computer where Axxon PSIM

 is

12. is installed can be lost. To view and prioritize

the

13. network protocols, use

the

14. the SQL Server Configuration Manager utility:

    1. Run the SQL Server Configuration Manager utility (Start

-> All Programs ->

15. 1. → Microsoft SQL Server Express

2014 ->

16. 1. 2019 → Configuration Tools).

    2. In the

right

17. 1. left part of the utility's interface window, click the

header

18. 1. title of the SQL Native Client Configuration list, and then select the Client Protocols

 item

19. 1. item in the drop-down list. In the

left

20. 1. right part of the window, right-click any protocol in the list and select

the

21. 1. the Order item in the context menu that appears.
       Image Modified

    2. In the Client Protocols Properties
dialog box
22. 1. window that
appears
23. 1. opens, 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
24. 1. The TCP/IP
item is
25. 1. line must be located at the very top of the Enabled Protocols list. Also
make sure that
26. 1. , you must set the Enable Shared Memory Protocol checkbox
is set
27. 1. .
       Image Modified
    2. If the TCP/IP
item is not
28. 1. line isn't located at the very top of
the
29. 1. the Enabled Protocols list, use the Up button to move it
to the top of the list
30. 1. .
       Image Modified