Configuring the eG Agent to Connect to the Report Server Database

To connect to the SQL report server database and run queries, the eG agent requires the name of the report server database, the IP address of the server hosting the report server database, and the port number/instance name of the report server database. To provide these values to the eG agent, you need to configure eG tests with valid values for the following parameters:

  1. Report Server Database IP: If the report server is installed with the Microsoft SQL server that hosts the SQL report server database, then the value of this parameter will be the same as that of the Host parameter of the tests. On the other hand, if the report server is installed on one host and the SQL report server database is available on another, then this parameter should be configured with the IP address of the host where the SQL report server database resides.
  2. Report Server Database Port: By default, the value of this parameter is 1433. This is because, the SQL report server database typically resides on a Microsoft SQL server, and the default port number of a Microsoft SQL Server is 1433. You can override this default value only when both the following conditions apply:

    • if the Microsoft SQL Server hosting the SQL report server database is not using named instances;
    • if the Microsoft SQL Server hosting the SQL report server database listens on a different port. In this case, first determine the correct port number, and then change the value of the Report Server Database Port parameter. To know the correct Report Server Database Port, do the following:

      • Open the SQL Server Configuration Manager.
      • In the tree-structure in the left panel of the SQL Server Configuration Manager, expand the SQL Server Network Configuration node, and click on the Protocols for <SQLINSTANCENAME> sub-node (see Figure 1). Make sure that the <SQLINSTANCENAME> is that of the SQL server instance in which the SQL report server database is available.

        Figure 1 : Determining the database port number

      • Then, double-click on the TCP/IP protocol in the left panel to open the Properties dialog box.

      • Switch to the IP Addresses tab page of the dialog box. Then, scroll down the tab page until the TCP Port property comes into view. The port number displayed against TCP Port is the database port.

  3. Report Database Server Name: Specify the name of the SQL report server database that the report server uses. To determine the database name, do the following:

    • Login to the system hosting the report server and open the Report Configuration Manager.
    • When Figure 2 appears, click on the Database option in the left panel. Then, check the value displayed against Database Name in the right panel. This is the name of the report server database.

      Figure 2 : Determining the name of the SQL report server database

  4.  

  5. Instance: By default, the value of this parameter is set to default. However, if the Microsoft SQL Server hosting the SQL report server database uses named instances, then do the following:

    • Configure the Instance parameter with the name of the SQL Server instance that hosts the report server database.
    • Do not change the default value of the Port parameter.