Go to documentation repository
Page History
...
- Run the setup.exe installation package.
- Click Next in the welcome window of setup wizard.
- 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.
Info title Note. Later it's possible to move the database of Intellect Web Report System to another SQL server. The changes should be made in <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"/>
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.
To continue the installation process click Next.
A window will appear in which it is necessary to set the connection string of the Intellect Web Report System to the main Intellect database, to the POS Intellect receipts database, and to the Auto Intellect databases. The connected databases will serve as a 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).
To set connection string to the main Intellect database, 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 the main Intellect database 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.Info title 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 main Intellect database is completed.- In the same way, set the connection string to the POS Intellect database of receipts (the default database name is pos).
- Click the Next button to proceed to setting up the connection to the Auto Intellect databases.
- In the same way, set the connection string to the Traffic Detection database (the default database name is traffic_db).
In the same way, set the connection string to the License Plate Recognizer database (the default database name is lprex).
Set the connection string to the Intellect Detector Pack database (the default database name is detectorpack) using Web.config configuration file.
Info title Note. You can set the connection strings to the databases using the <Intellect installation directory>\Modules\Wt2\Web.config file. Examples of connection strings are given below:
<connectionStrings>
- <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="DtDB" connectionString="Provider=SQLOLEDB.1;Data Source=(local)\SQLEXPRESS2014;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=dt" />
- <add name="ReportSystemConnectionString" connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ReportSystem;Data Source=(local)\SQLEXPRESS2014;" providerName="System.Data.SqlClient" />
- <add name="Analytics" connectionString="Server=localhost;Port=15432;User id=postgres;Password=Analytics_default_DB_4;Database=analytics;CommandTimeout=600;" providerName="Npgsql" />
- <add name="lprex" connectionString="Provider=SQLOLEDB.1;Data Source=(local)\SQLEXPRESS2014;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=lprex" />
- <add name="detectorpack" connectionString="Provider=SQLOLEDB.1;Data Source=(local)\SQLEXPRESS2014;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=detectorpack;" />
- To continue installation, click Next. As a result of this operation installation starts.
- Message that Intellect Web Report System installation is finished is displayed in a new dialog box.
...