Page History

By default, the Axxon PSIM local database is used as a data source for to display the State state statistics displaying. In order If you want to use a remote database, configure the connection to it as followsin the following way:

1. Go to the the DB tab on the settings panel of the State statistics object settings panel (1).
   Image Removed.
   Image Added
2. By default, statistics are updated once every 60 seconds. If necessary, you can change the update frequency by entering a new value in seconds in the Statistics update frequency (s) field. We don't recommend setting the frequency to less than 5 seconds.
3. Click the Connection dialog button. As a result, the SQL Server Login window opens.
   Image Added Image AddedClick the Connection dialog button (2). The SQL Server Login window will open.
   Image Removed Image Removed

4. In the Server list, specify the SQL server to which you want to connect to (1).

   title

   Info
   title Note
   If the Server list contains the required SQL server, then no further connection configuration is neededrequired.
   Info
   	Note	When working you work in a distributed configuration, it is necessary to you must specify the computer name where name of the computer on which the database is located , without using the value (local) value. For example, "WS1\SQLEXPRESS", where WS1 is the name of the computer where on which the database is located.

5. If it is necessary you want to enter the login and password for the SQL server authorization, unset clear the Use trusted connection checkbox (2)Trusted Connection checkbox. As a result, the Login ID and Password fields will become editable.

   Info
   title Note
   If you set the Use trusted connection check box is setTrusted Connection checkbox, then the SQL server authorization will be is performed using the with Windows credentials.

6. To specify the additional connection parameters, click the Options >> button (3).
   In the opened field, from
   1. From the Database drop-down list
   (4)
   2. , select the database where the events
   should
   3. must be stored.
   4. From the Language drop-down list (5), select the language of the SQL server system messages.
   5. In the Application Name field (6) field, enter the application name (the default one value is Axxon PSIM).
   6. In the Workstation WorkStation ID field (7), enter the computer name (the default one value is the computer identifier in Windows OS).

7. Click the OK button to save the settings.

   Info
   title Note
   For the help information about the Login to the SQL Server dialog boxLogin window, click the Help button.

Setting up database connection Configuring connection to the database is complete.