Configuring the use of external database

By default, the PROTOCOL_INC_SERVER table is used to store the events of the incident server in the Axxon PSIM database.

If you want to use the database for the incident server, which is different from the default one in Axxon PSIM, you must configure the connection to it in the following way:

1. Set the Use checkbox (1) on the settings panel of the Incident server object.
   
   
2. Set the connection parameters in one of the following ways:
   1. Click the Configure button (2) and set the connection parameters to the external database using the standard dialog window, see Configuring connection to external database in dialog mode.

   2. In the Connection string field (3), set manually the connection parameters separated by a semicolon without spaces.

      Parameter	Possible values
      Provider	SQLOLEDB.1 when you use the MS SQL Server database format; Microsoft.Jet.OLEDB.4.0 when you use the MS Access database format
      Integrated Security	SSPI when you log in on the MS SQL server using the Windows OS account. If you use the MS SQL server and this parameter is missing, then username (login) and password are used for authentication. When you use the MS Access database format, this parameter isn't required
      Persist Security Info	True—permission to save the password for automatic connection to the database; False—prohibition to save the password for automatic connection to the database
      Data Source	The name of the MS SQL server used to manage the database, or the path to the MDB file of the MS Access database format

      All parameters, except for Integrated Security, are mandatory. Example:
      Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;Data Source=SQLEXPRESS2019
3. Click the Apply button (4).

As a result, the specified database is used for the incident server.