Documentation for Intellect Web Report System 3.4. Documentation for other versions of Intellect Web Report System is available too.

Previous page Intellect Web Report System installation and removal  Repairing Next page

The Intellect Web Report System is installed as a part of the Intellect software. Information about compatibility of the Intellect software versions and Intellect Web Report System is presented by link: Obsolete. General information about product releases and versions compatibility.

Important!

The Intellect Web Report System should be installed only on Server/Remote administrator workplace (for details, see Intellect software. Administrator's Guide).

To install Intellect Web Report System do the following:

  1. Run the setup.exe executable file in the distribution root directory. 
  2. To continue the installation process, click Next.
  3. Read the terms of the license agreement carefully. Then set the switch to I accept the terms of the License agreement position and click Next.

  4. Select MS SQL Server DB server and set the connection parameters (for details, see Installation of INTELLECT™ software as a Server/Remote administrator workplace). To continue the installation process, click Next.

    Note.

    The Intellect Web Report System database will be created on the selected SQL server.

    Later it's possible to move the database of Intellect Web Report System to another SQL server. After that, it is necessary to make changes to the <Intellect installation directory>\Modules\Wt2\Web.config file by correcting the ReportSystemConnectionString connection string:

    • <add name="ReportSystemConnectionString" connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ReportSystem;Data Source=(local)\SQLEXPRESS2014;" providerName="System.Data.SqlClient"/>


  5. Specify the connection strings to the main Intellect database and the POS Intellect receipts database. The connected databases will serve as a data source when creating reports.


  6. To set connection string to the main Intellect database, do the following:

    1. Click Connection to the main Intellect DB.

    2. As a result the Data link properties dialog box is displayed.

    3. In the Data provider tab select Microsoft OLE DB Provider for SQL Server. Click Next.

    4. As a result there will be an automatic switch to Connection.

    5. In 1. Select or enter a server name line select from the list or enter manually the name of SQL server where the main Intellect database is stored.

    6. To log on SQL server it is necessary to set authentication parameters. For this set switch into Use a specific user name and password position. In the User name and Password fields enter username (login) and password in order to connect to SQL server. Set the Allow saving password checkbox.

    7. To check connection to SQL server click Test connection.
      In case of successful connection the window with the Test connection succeeded message will be displayed.

      It's necessary to click ОК in the window of message and as a result the window will be shut down automatically.
      If the name of SQL server and/or authentication parameters that are used in order to connect to it were set wrong then the corresponding message is displayed.

      To shut down the window with the message, click       ОК. Then correct the data and check connection to SQL server once again.

    8. If check of connection to SQL server is successful, select from the Select database on server list the name of connected database.

    9. Click ОК in the Data connection properties dialog box. As a result of this operation the dialog box will shut down.
      Setting connection string to the main Intellect database is completed.

  7. In the same way, set the connection string to the POS Intellect database of receipts (the default database name is pos).

  8. In the same way, set the connection string to the Traffic Detection database (the default database name is traffic_db).

    Note.

    If you install POS Intellect and Auto Intellect after the Intellect Web Report System, it is necessary to connect the Intellect Web Report System database to the corresponding modules. To do this, start the repairing mode of the reporting subsystem and specify the appropriate connection strings (see Repairing).

    You can also set the connection strings to all databases through the <Intellect installation directory>\Modules\Wt2\Web.config file. Examples of connection strings are given below:

    • <add name="IntellectDB" connectionString="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=intellect;Data Source=(local)\SQLEXPRESS2014" />
    • <add name="PosDB" connectionString="Data Source=(local)\SQLEXPRESS2014;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=pos;Provider=SQLOLEDB.1" providerName="System.Data.SqlClient" />
    • <add name="TrafficDB" connectionString="Provider=SQLOLEDB.1;Data Source=(local)\SQLEXPRESS2014;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=traffic_db" />
    • <add name="ReportSystemConnectionString" connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ReportSystem;Data Source=(local)\SQLEXPRESS2014;" providerName="System.Data.SqlClient" />


  9. To continue the installation process, click Next. As a result, the copying of the necessary Intellect Web Report System files to the hard disk will start.

  10. After successful copying of the Intellect Web Report System components, a message about the completion of the installation process will be displayed. Then click Finish.

The installation of Intellect Web Report System is completed.

  • No labels