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: General information about product releases and versions compatibility.
To install Intellect Web Report System do the following:
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.
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:
connectionString="Password=ITV;Persist Security Info=True;User ID=sa;Initial Catalog=ReportSystem;Data Source=(local)\SQLEXPRESS;"
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.
Windows Account information method is used in the following cases:
Method of using login and password is for the following cases:
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.
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.
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.
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.
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.
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:
Message that Intellect Web Report System installation is finished is displayed in a new dialog box.
Intellect Web Report System installation is finished and system is installed in C:\Program Files\Интеллект\Modules\Wt2 folder.
If there is no folder it will be created automatically.
After Intellect Web Report System installation it's necessary to restart Intellect software package.