Previous page Settings panel of the Access level object  Appendix 4. Creating additional fields for the User object Next page


The Access Manager module gets the objects required for its operation directly from the SQL Server database of the Intellect Server. This causes some issues for the module operation in distributed systems, based on a variety of combinations between the Intellect Server, the Remote Administrator's workstation, and the Remote Client (see Configuration of distributed architecture).

In particular, when you try to run the Access Manager module remotely from a computer with a Remote Client, the Access Manager will not display the objects, which are loaded from the database of the Intellect Server, e.g. the lists of users and departments. In order to eliminate this issue, when configuring the distributed system, the administrator should do the following:

  1. On the computer with the installed Remote Client:
    1. Install the OLE DB Driver for SQL SERVER driver by selecting the msoledbsql file that is located in the redist folder in the installation directory according to the language and bitness of the Remote Client, or fully install the SQL Server. Thus, the SQL Server on the computer with the installed Remote Client will be able to connect to the SQL Server on the computer with the Intellect Server.
    2. Ensure the SQL Server authentication through the base sa account.
    3. Ensure uninterrupted connection of the SQL Server on the computer with the installed Remote Client to the SQL Server on the computer with the installed Intellect Server.

  2. On the computer with the installed Intellect Server and the Access Manager module:
    1. Configure the SQL Server to allow remote connections.
    2. Ensure the SQL Server authentication through the base sa account.
    3. Configure the Intellect Server connection to its database using the idb.exe utility. For this, do the following:
      1. Run the utility from the Intellect Server installation directory.
      2. In the utility interface, click the Configure button (1). The database connection window will open.

      3. In the Select or enter a server name field (2), enter the name or the IP address of the SQL server used to for database management.

        Note

        Note that you must specify the explicit name or the IP address of the machine on which the database is installed. The format (local)\ SQLEXPRESS would be incorrect.

      4. In the Enter the information to log on to the server settings section (3), select the Use a specific user name and password radio button. In the User name field enter sa. In the Password field, enter the password for the sa user.

        Note

        Note that user names other than sa are not allowed.

      5. Set the Allow saving password checkbox (4).

        Note

        This step is mandatory.

      6. Select the Select the database on the server radio button and select intellect from the drop-down list (5).
      7. Click the OK button to save the connection parameters (6). The parameters will be displayed in the Connection string field (7) in the idb.exe utility interface.
      8. Click the OK button (8) in the idb.exe utility interface to save the changes.

Configuring the correct operation of the Access Manager module in a distributed system is complete.

  • No labels