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

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".