Page History

When When Axxon PSIM software is  is installed, it is configured to operate with the Axxon PSIM MS SQL server database.

To connect the Axxon PSIM software  Configuration database, do the following:

1. Make sure that MS SQL Server software operates.
2. Start the idb.exe utility in the root of the Axxon PSIM software installation  installation directory (for example, C:\Program Files (x86)\Axxon PSIM). The dialog window of the idb.exe utility dialog box is displayedopens.
   
3. Choose the Basic data item in the Select data source list.
4. Set the Use checkbox, if not set before.
5. Click the Configure button.
6. The Data Link Properties dialog box is displayedwindow opens. Go to the Provider tab in the Data Link Properties dialog boxwindow.
   
7. Select Microsoft OLE DB Provider for SQL Server in the OLE DB Provider(s) list.
8. Click the Next button.
9. As soon as After you click the Next button is clicked, go , you are automatically redirected to the Connection tab is automatically performed.
   

10. In the 1.Select or enter a server name line, select in from the list or type-in enter the name of MS SQL server which that is used to store the database to be connectedwhich you want to connect.

    Info
    title Note.
    In case of you use dynamic host configuration protocol (DHCP) use for the local database, set «127127.0.0.1» 1 IP address (without using computer names and "local" value) in the 1.Select or enter a server name.   Set «127Set 127.0.0.1» 1 value when the static IP address is useused. Otherwise, there is disconnection of Axxon PSIM software is disconnected with its local database when network cable is disconnected.  If Axxon PSIM™ PSIM is connected to remote database configuration at by IP address (e.g.for example, 192.168.0.68\SQLEXPRESS), you cannot change and save Axxon PSIM™ software PSIM settings when there is a network connection break. If event protocol is extracted into an individual database, use any functioning way to specify a server name.

11. The 2.Enter information to log on to the server group is used to specify the type and authentication parameters of the MS SQL server connection. MS SQL server authentication is performed through the user account, authorized in Windows OS, or by user name (login) and password that protect the MS SQL server connection.
    The method and parameters of authentication at the MS SQL server are set during MS SQL server installation.
    Different parameters are to must be specified with different authentication techniques for MS SQL server connection:
    

    1. If MS SQL server authentication is performed through the user Windows OS account, switch to the Use Windows NT Integrated security position.

       Info
       title Note.
       If converting conversion is performed via the remote SQL server, the computer with MS SQL server installed must show the current user account. And the user is logged on under this account at the computer that performs the database connection.

       
       

    2.  If MS SQL server authentication is performed through the user login and password, do the following:
       
       1. Switch to the Use a specific user name and password;
       2. Specify the user name (login) to connect to the MS SQL server in the User name field.
       3. If access to the MS SQL server is protected with a password, set clear the Blank password checkbox unchecked and specify the database access password in the Password field.
       4. Set the Allow saving password checkbox.

       5. Go to the All tab.
          

       6. In the Persist Security Info field, set the True value. This is necessary to correctly save the user password.

          Info
          title Note
          Each time you change the server connection parameters, you must set the Persist Security Info field value to True.

12. Click the Test Connection button.
13. If MS SQL server is successfully connected, then the Test connection succeeded message is displayed.
    
    Click the OK button to close the boxwindow.
14. If the MS SQL server name and/or authentication parameters of the MS SQL server connection were erroneousspecified incorrectly, the error message will appear.
    
15. Click the the OK button to close the boxwindow. Then specify the correct password and try the MS SQL server connection again.
16. Select the name of the database that you want to be connected connect in the Select the database on the server list.
    

    Info
    title Note
    You must select a database at this step. If you leave the database field blank, after you close the Data Link Properties window, the line "Database is not set in connection settings" appears in the database description window of the IDB.exe utility and the OK button to save changes is inactive.

17. Click the OK button in the Data Link Properties dialog boxwindow. The box window closes.

18. It is strongly recommended to update We strongly recommend updating the database structure after this. For this, click the Update database button in the idb.exe utility dialog boxwindow. If DB is not updated on at this step, the update is automatically performed at at Axxon PSIM start-up; , however, it might be difficult to track errors in this case.

    Note
    title ImportantAttention!
    If the Event Viewer is in the individual database (see Extracting event protocol into an individual database), then the Event Viewer database structure will be updated when updating the main database structure. So it is recommended to check we recommend checking the connection to the Event Viewer database before updating the main database structure in order to prevent any errors.

    

19. As a result, the database structure update process starts, and the corresponding messages appear in the Protocol table.
20. When the conversion process is successfully completed, the the Data Updating is completed! message appears in the Protocol table of the idb.exe utility.
21. Click the OKin the bottom right corner of the idb.exe utility button.

Axxon PSIM™ software PSIM database is now connected.