Rockwell Automation FactoryTalk Report Expert User Guide - Manual (Page 144)

Chapter 9 Administering Report Expert
144 Rockwell Automation Publication RPTEXP-UM001H-EN-P-June 2014
4. Select the RptSetting table and open it for editing.
5. Under Value, modify the values of the settings as specified in
"Configuring Report Expert Settings (page 138)".
6. Restart the Internet Information Services (IIS):
1. In the Command Prompt window, type
iisreset
.
Wait until the services are restarted.
7. Restart SQL Server Reporting Services (SSRS):
1. Go to Start > Run. The Run dialog box appears.
2. Type services.msc. The Services dialog box appears.
3. Find the following service:
• SQL Server Reporting Services (<SQL Server instance
name>)
4. Right-click it, and then select Restart.
Wait until the service is restarted.
During the installation of Report Expert, communication between
Report Expert and SQL Server Reporting Services (SSRS) is
configured in the following way:
• Report Expert communicates with SSRS that are installed and
configured on the same computer, on which you have installed
Report Expert.
• The URL of the Report Server Web Service is created. It
consists of the following elements:
http:/
/<MSRSHost>:<MSRSPortNumber>/ReportServer?/<
MSRSReportFolder>
To change this configuration, use the settings described in the table
below. The settings are stored in the RptSetting (page 138) table of
the FactoryTalk Metrics database.
Communicating With SQL
Server Reporting Services
(SSRS)