Versions Compared

Key

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

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

  1. On Go to the DB tab on the settings panel of the State statistics object, go to the DB tab.
    Image Modified
  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. The As a result, the SQL Server Login window opens.
    Image Modified Image Removed Image Added
  4. In the Server list, specify the SQL server to which you want to connect (1).

    Info
    titleNote

    If the Server list contains the required SQL server, then no further connection configuration is neededrequired.

    When you work in a distributed configuration, you must specify the 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 on which the database is located.

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

    Info
    titleNote

    If you set the Use Trusted Connection checkbox, then the SQL server authorization is performed with the Windows credentials.

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

    Info
    titleNote

    For the help information about the the SQL Server Login window, click the Help button.

Configuration of Configuring connection to the database connection is complete.