Installation

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.

To install Intellect Web Report System do the following:

Start the ReportSystem.msi installation package.
In the language dialog window select the language from the list.
Click Next in the welcome window of setup wizard.

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 I accept the terms of the License agreement position. Then click Next.

The Select DB server window is displayed.
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.
Later it's possible to move the database of Intellect Web Report System to another SQL server. The changes should be made in C:\Program Files\Intellect\Modules\Wt2\Web.config file by correcting the following connection string:
<add
name="ReportSystemConnectionString"
connectionString="Password=ITV;Persist Security Info=True;User ID=sa;Initial Catalog=ReportSystem;Data Source=(local)\SQLEXPRESS;"
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.
Note.
Windows Account information method is used in the following cases:
1. When SQL server where it's necessary to create Intellect Web Report System database and system itself are installed on one computer.
2. 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.
Note.
Method of using login and password is for the following cases:
1. When SQL server where it's necessary to create Intellect Web Report System system database and system itself are installed on one computer.
2. 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.
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.
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).
To set connection string to the database of Time and Attendancemodule do the following:
8.1 Click Connection to the main Intellect DB.
8.2 As a result the Data link properties dialog box is displayed.

8.3 In the Data provider tab select Microsoft OLE DB Provider for SQL Server. Click Next.
8.4 As a result there will be an automatic switch to Connection.

8.5 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 stored.
8.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.
8.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.8 If check of connection to SQL server is successful, select from the Select database on server list the name of connected database.
Note.
Database of the Time and Attendance module coincides with the database of Intellect configuration (name by default is intellect).
8.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 database of Time and Attendance module is completed.
To set 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 traffic_db).
Connection strings to databases are displayed in the Setting DB connection strings dialog box.
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.
Note.
If DB connection strings has been set then installation will start as a result (see point 10).

This dialog box warns about failure of connection to DB that doesn't guarantee the operation of the system.
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. Examples of connection strings are given below:
1. <add name="IntellectDB" connectionString="Provider=SQLOLEDB.1;Password=itv;Persist Security Info=True;User ID=sa;Initial Catalog=intellect;Data Source=WS2\SQLEXPRESS"/>
2. <add name="PosDB" connectionString="Server=.\SQLEXPRESS;Integrated Security=SSPI;Persist Security Info=False;Database=pos;Provider=SQLOLEDB.1"/>
3. <add name="ReportSystemConnectionString" connectionString="Password=itv;Persist Security Info=True;User ID=sa;Initial Catalog=ReportSystem;Data Source=(local)\SQLEXPRESS;"/>
To continue installation, click Next. As a result of this operation installation starts.