Setting database connection

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

1. Go to the DB tab on the settings panel of the State statistics object (1).
   
2. Click the Connection dialog button (2). The SQL Server Login window opens.
   

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

   Note

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

   Note

   When you work in the distributed configuration, you must specify the computer name where the database is located, without using the (local) value. For example, "WS1\SQLEXPRESS", where WS1 is the name of the computer where the database is located.

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

   Note

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

5. 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), enter the application name (the default one is Axxon PSIM).
   4. In the WorkStation ID field (7), enter the computer name (the default one is the computer identifier in Windows OS).

6. Click OK to save the settings.

   Note

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

Setting up the database connection is complete.