beautypg.com

Report expert prerequisites, Chapter 2 – Rockwell Automation FactoryTalk Report Expert User Guide User Manual

Page 17

background image


Rockwell Automation Publication RPTEXP-UM001H-EN-P-June 2014

17

Chapter 2

Report Expert Prerequisites

Before you install Report Expert, keep the following in mind:

• Report Expert must be installed on the same computer as SQL

Server Reporting Services (SSRS).

• Make sure you have configured your System DSN (Data

Source Name) in your ODBC Data Source Administrator.
If you have RSBizWare installed, you may already have System

DSN configured.

To verify the System DSN configuration on Microsoft Windows
Server:

1. In the file explorer, go to the following directory:

%windir%\SysWOW64\

2. Double-click odbcad32.exe.

The ODBC Data Source Administrators (32-bit) dialog box

appears.

3. Click the System DSN tab.

If the system DSN is configured, your RSBizWare database is
listed under System Data Sources.
If the System DSN is not configured, create a DSN for the
RSBizWare database on the server containing the Report

Expert web site. For more information on creating a DSN, see
the Report Expert Release Notes, section "Prerequisites for
Windows Server 2012 for FactoryTalk Metrics and Report
Expert".