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

Chapter 4 Post-Installation Tasks
60 Rockwell Automation Publication HSE-IN025A-EN-E–September 2013
To enable encrypted communication, add
encrypt=Yes;
to
the code. See the Microsoft SQL Native Client
documentation for other options.
4. If the AF application service is running, stop and restart it for
your changes to take effect.
If you need to direct your AF application service to a different AF
SQL database, follow the instructions below to specify a new SQL
Server instance and to enable communications.
To specify a new SQL Server instance and enable
communications:
1. On the AF application service computer, edit the
AFService.exe.config
file in the
PIPC\AF
folder and replace
the server information with the name of the remote SQL
Server to be accessed.
2. Restart the AF application service computer.
3. If the AF application service is using the NetworkService or
LocalSystem account, add the Domain\Machine Name for the
remote AF server to the local AFServers Windows group (on
the AF SQL database computer.)
4. If the AF application service has been modified to use any
other account, add the account under which it is running to
the local AFServers Windows group (on the AF SQL database
computer.)
For details, see "Create the AFServers Local Group on the AF
Application Service Computer (page 56)", step 3.
5. Restart the AF SQL database computer.
Configure AF Application
Service to Point to a Different
AF SQL Database