Page History

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 link: General information about product releases and versions compatibility.

To install Intellect Web Report System do the following:

1. Start Run the ReportSystem.msi installation package.
2. In the language dialog window select the language from the list.
   Image Removed
3. setup.exe executable file in the distribution root directory. 
4. To continue the installation process, click Next.
   Image Added
5. Click Next in the welcome window of setup wizard.
   Image Removed
   The dialog box of the License agreement is displayed.To continue the installation one should accept the terms of the License agreement by setting the switch into Read the terms of the license agreement carefully. Then set the switch to I accept the terms of the License agreement position. Then  and click Next.
   
6. The 

   Select MS SQL Server DB server

    window is displayed.

   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.

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

   From the Select DB Server from the drop-down list select SQL server where the database of the Intellect software package configuration is located. The database of Intellect Web Report System will be created on the same SQL server.

   Note

   Info

   title

   . Later it's possible to move the database of Intellect Web Report System to System to another SQL server. The changes should be made in C:\Program Files\Intellect After that, it is necessary to make changes to the <Intellect installation directory>\Modules\Wt2\Web.config file by correcting the following ReportSystemConnectionString connection string: <add <add name="ReportSystemConnectionString" connectionString=" Password Integrated Security= ITV SSPI;Persist Security Info= True;User ID=sa False;Initial Catalog=ReportSystem;Data Source=(local)\ SQLEXPRESS SQLEXPRESS2014;" providerName="System.Data.SqlClient"/> .

   
   

   Set the authentication method that will be used by the Intellect Web Report System while connecting to SQL server with the database of the Intellect software package configuration.
   Connecting by the Windows Account information method there is a confirmation of user identity by using current account information of Windows OS. Method of using specified user name and password allows confirming SQL server authenticity.

   Info
   title Note.
   Windows Account information method is used in the following cases: When SQL server where it's necessary to create Intellect Web Report System database and system itself are installed on one computer. When SQL server and Intellect Web Report System system are installed on different computers connected by TCP/IP and located in one network domain. An account for user that is authorized in Windows OS on computer where Intellect Web Report System is installed should be created in Windows OS on computer with installed SQL server.

   Info
   title Note.
   Method of using login and password is for the following cases: When SQL server where it's necessary to create Intellect Web Report System system database and system itself are installed on one computer. When SQL server and Intellect Web Report System system are installed on different computers connected by TCP/IP and located in one network domain. At the same time specified user name (login) and password should be the same as user name (login) and password that are used to SQL server access.

7. To continue the installation process click Next.
   The window where it is necessary to set connection string of Report System to the database of Time and attendance module, to POS Intellect database and/or AUTO Intellect database. Connected databases will be the data source when creating reports. 

   Info

   title	Note.

   If the POS Intellect software and the AUTO Intellect software are installed after the Intellect Web Report System installation, the connection of Intellect Web Report System database to the corresponding module is to be performed. Launch the Repairing mode of Intellect Web Report System and enter the corresponding connection strings (see Repairing section).

   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.

   
   

8. To set connection string to

   the database of Time and Attendancemodule do the

   the main Intellect database, do the following:

   8.1 Click

   1. Click Connection to the main Intellect DB.

   8.2

   1. As a result

   the

   1. the Data link properties

   dialog

   1.  dialog box is displayed.
      Image Modified

   8.3

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

   8.4

   1. As a result there will be an automatic switch to Connection.
      Image Modified

   8.5

   1. In 1. Select or enter a server name line select from the list or enter manually the name of SQL server where

   database of Time and Attendance module is

   1. the main Intellect database is stored.

   8.6

   1. 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.

   8.7

   1. 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.
      Image Modified
      It's necessary to

   click

   1. click ОК

   in

   1.  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.
      Image Modified
      To shut down the window with the message, click ОК. Then correct the data and check connection to SQL server once again.

   8.8

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

   Info
   title Note.
   Database of the Time and Attendance module coincides with the database of Intellect configuration (name by default is intellect).

   8.9 

   1. 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

   database of Time and Attendance module is

   1. main Intellect database is completed.

   To
9. In the same way, set the connection string to POS database do the following:
   9.1 Click Connection to POS DB.
   9.2 As a result of this operation the Data connection properties dialog box is displayed.
   9.3 Repeat 8.3-8.9 steps but connect POS database (name by default is pos).
   Setting connection string to POS database is completed.To set connection string to AUTO database do the following:
   10.1 Click Connection to Auto DB.
   10.2 As a result of this operation the Data connection properties dialog box is displayed.
   10.3 Repeat 7.3-7.9 steps but connect AUTO database (name by default is  POS Intellect database of receipts (the default database name is pos).

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

    
    Connection strings to databases are displayed in the Setting DB connection strings dialog box.
    Image Removed
    

    Info
    title 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).

    Click Next. If DB connection strings has not been set then the DB connection strings need setting dialog box will be displayed as a result.

    Info
    title Note.
    If DB connection strings has been set then installation will start as a result (see point 10).

    Image Removed
    

    This dialog box warns about failure of connection to DB that doesn't guarantee the operation of the system. 

    Info
    title Note.
    If there was installation without setting connection to DB then you can set the connection to DB using C:\Program Files\Интеллект\Modules\Wt2\Web.config file and adding connection strings 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; Password Integrated Security= itv SSPI;Persist Security Info= True;User ID=sa False;Initial Catalog=intellect;Data Source= WS2 (local)\ SQLEXPRESS SQLEXPRESS2014" /> <add name="PosDB" connectionString=" Server=.\SQLEXPRESS;Integrated Security=SSPI;Persist Security Info=False;Database Data Source=(local)\SQLEXPRESS2014;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=pos;Provider=SQLOLEDB.1" providerName="System.Data.SqlClient" /> <add name=" ReportSystemConnectionString TrafficDB" connectionString=" Password=itv Provider=SQLOLEDB.1;Data Source=(local)\SQLEXPRESS2014;Persist Security Info =True;User ID=sa =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)\ SQLEXPRESS SQLEXPRESS2014;" providerName="System.Data.SqlClient" />

    
    

11. To continue the installation process, click Next. As  As a result of this operation installation starts.
    Image Removed
    

Message that Intellect Web Report System installation is finished is displayed in a new dialog box.

Image Removed

Intellect Web Report System installation is finished and system is installed in C:\Program Files\Интеллект\Modules\Wt2 folder.

...

1. , the copying of the necessary Intellect Web Report System files to the hard disk will start.
   Image Added
   
2. 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.
   Image Added

The installation of Intellect Web Report System is completed

...

.