Connection to the Tariscope system
The first window that a user meets when launching the Tariscope program, both for the Tariscope Enterprise edition and for the Tariscope Provider edition, is the Connect to Tariscope server window (Figure 1).
Figure 1
Depending on the configuration of the Tariscope system, there may be various features when you make such a connection.
Consider the basic configurations that are used by Tariscope users.
1. All applications on the single server.
This is the most common configuration among users when all Tariscope applications: Tariscope server, Microsoft SQL Server, Tariscope program and other programs are installed on the single server.
If the Tariscope installation was performed with the default settings, first it concerns the SQL server, then no additional settings are required to connect to the Tariscope server. If you are satisfied with Windows authentication, then simply click on the OK button. The Tariscope program connects to the Tariscope server and the SQL server and is ready to work.
If you want to use SQL Server authentication, then select it in the Authentication list and in the User name and Password boxes, enter the login and password of the SQL server user, with which Tariscope will connect to the SQL server.
By default, Microsoft SQL Server use the name: MSSQLSERVER.
If you do not remember the name of your SQL server, you can see it. To do this, run the SQL Server Configuration Manager program. In the program window that appears, select SQL Server Services in its left part of window and define what will be displayed in the right part in the SQL Server value (Figure 2). As you can see in this figure, the name is used: SQLDEVELOPER.
For the case when the name of your SQL server is different from the default one, you need to make changes to the Tariscope server configuration file. This file is named mail.xml and is in the folder: [system disk]:\ProgramData\Tariscope
Figure 2
Open this file with a text editor. This text editor should run with administrator rights, because it must have rights to save changes of the configuration file.
The main.xml configuration file contains a list of parameters used by the Tariscope system. Among these parameters is the SQL server connection string, enclosed in the tags <ConnectionString> and </ConnectionString>. The SQL server name is set after the parameter: Data Source =. For example, the SQL server is called SoftpiSQL. In this case, correct the part of the configuration line to: Data Source = .\ SoftpiSQL
The dot after the equal sign means that the SQL server is located on the same computer where the Tariscope server is running.
Next, save the main.xml file and reload the Tariscope server so that it uses the already updated configuration file.
Tariscope server works as a Windows service. Therefore, open the Services window in Windows, find the Tariscope main service (TSMAIN) service and restart it. After that, you can enter in the Tariscope program.
2. The Tariscope server and Microsoft SQL Server were installed a single server, and the Tariscope program was installed on one or several separate computers.
In this case, you need to make changes to the configuration file of the Tariscope server. It was described for the previous configuration of the Tariscope system how the file is named and where it is located.
In the SQL server connection string for the Data Source, you must specify the IP address of the computer on which the SQL server was installed.
For example, we use the SQL server named SoftpiSQL on a computer with an IP address of 10.10.0.77. Then we need to fix the connection string by writing in it: Data Source = 10.10.0.77\SoftpiSQL
Save the file. Reload the Tariscope main service.
In the Server name box of the Connect to Tariscope server window (Figure 1), enter IP address of computer where the Tariscope server works. This is 10.10.0.77 for the specified example.
This means that the Tariscope program will contact the Tariscope server at this address, and it will return to it the connection string specified in the configuration file.
3. The Tariscope server was installed on a server, Microsoft SQL Server was installed on another server, and the Tariscope program was installed on one or several separate computers.
For this configuration of Tariscope applications, you also initially need to make changes to the connection string in the Tariscope server configuration file.
Suppose that the Tariscope server was installed in the computer with the IP address 10.10.0.77, Microsoft SQL Server was installed on the computer with the IP address 10.10.0.123, and the Tariscope program was installed on the computer with the IP address 10.10.0.55.
Then we find the configuration file of the Tariscope server on the computer with IP address 10.10.0.77. The file is stored in the folder:
[system drive]:\ProgramData\Tariscope
In the connection string to the SQL server, you need to specify its IP address, and if it does not have a default name, then you should also specify its name. Suppose the SQL server name is: SoftpiSQL. In this case, the following value should be set for the data source:
Data Source = 10.10.0.123\ SoftpiSQL
Then we save the file and reload the Tariscope server that it applies the new connection string.
For the Tariscope program installed on the computer with the IP address 10.10.0.55, in the Connect to Tariscope server window (Figure 1), set the IP address of the Tariscope server. For this example, this should be the address: 10.10.0.77. The Tariscope program will contact the Tariscope server at the specified address. It will return the connection string to it, which will contain the location of the SQL server.
Links
1. Tariscope 4.x. Administrator's guide
