Rockwell Automation FactoryTalk Historian SE 4.0 Installation and Configuration Guide - Manual (Page 56)

Chapter 4 Post-Installation Tasks
56 Rockwell Automation Publication HSE-IN025A-EN-E–September 2013
The SQL Server scripts and the
GO.bat
file are placed in the
..\PIPC\AF\SQL
folder. The
GO.bat
file contains the commands
that execute the deployed SQL Server scripts manually.
Upon execution, the scripts create the AF SQL database (PIFD) and
populate its tables.
The execution of the scripts must occur from an account with
sysadmin
privileges on the SQL Server instance.
In this chapter you will learn how to:
• Create the AFServers Local Group on the AF Application
Service Computer (page 56).
• Execute the SQL Scripts to Create and Populate the AF SQL
Database (page 57).
• Modify the AF Application Service Connect String (page 59).
• Configure AF Application Service to Point to a Different AF
SQL Database (page 60).
Before you run the SQL scripts, follow these steps to enable
interaction between the AF application service and the AF SQL
database:
1. On the computer where you installed the AF SQL database,
open Computer Management.
2. Create the AFServers local group, if it does not already exist.
3. Do either of the following:
• If the AF application service is not running under a domain
account, add the AF application service computer name to
the AFServers group, using this syntax:
DOMAIN\ComputerName
In this example, the domain is
RA
and the computer name is
RADAT
.
Create the AFServers Local
Group on the AF Application
Service Computer