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

Post-Installation Tasks Chapter 4
Rockwell Automation Publication HSE-IN025A-EN-E–September 2013 59
Modify the AF application service connect string to enable
communication between the AF server and the AF SQL database.
On each AF application service computer, follow these steps:
1. In Windows Explorer, navigate to the
..\PIPC\AF
folder.
2. Use a text editor to open the AF application service
configuration file,
AFService.exe.config
.
3. Enter the name of the remote SQL Server, and the named
instance if applicable, in the connect string server.
Refer to the following lines of code:
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<appSettings>
<add key="connectString" value="Persist Security
Info=False;Integrated
Security=SSPI;server=<SQLName>[\SQLInstance];database=PIFD;App
lication Name=AF Application Server;"/>
<add key="streamedPort" value="5459"/>
If the SQL Server is running on a cluster, it is important to use
the clustered resource IP address, instead of a computer name.
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<appSettings>
<add key="connectString" value="Persist Security
Info=False;Integrated
Security=SSPI;server=<SQLClusterName>[\SQLInstance];database=P
IFD;Application Name=AF Application Server;"/>
<add key="streamedPort" value="5459"/>
If the SQL Server is configured to use SQL Server mirroring,
then add
Failover
Partner=<SQLServerName>[\<InstanceName>]
after the
server=
, as shown in the following lines of code:
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<appSettings>
<add key="connectString" value="Persist Security
Info=False;Integrated
Security=SSPI;server=<SQLName>[\SQLInstance];failover
partner=<SQLName>[\SQLInstance];database=PIFD;Application
Name=AF Application Server;"/>
Modify the AF Application
Service Connect String