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

Chapter 3 Installing FactoryTalk Historian
30 Rockwell Automation Publication HSE-IN025A-EN-E–September 2013
Installation mode Description
AF Application Service and AF SQL Database The service and the database are installed on the same machine.
This is the default setting.
AF Application Service and AF SQL Database
with unprocessed database scripts The service is installed on the machine, the system is prepared for the database
installation, and the database scripts are copied to the following location in the Program
Files directory: Rockwell Software\FactoryTalk Historian\PIPC\AF\SQL.
You can create the database manually, using the provided scripts. See "Manually Create or
Upgrade the AF SQL Database (page 55)" for more information.
If you select this option, you need to provide in the DB Server Name text box the name of
the SQL Server machine, and (optionally) the name of the instance of the SQL Server with
which the AF service will communicate.
• The service and the database are located on different
machines:
Installation mode Description
AF Application Service Only the service is installed on the machine.
If you select this option, you need to provide in the DB Server Name text box the name of
the SQL Server machine, and (optionally) the name of the instance of the SQL Server with
which the AF service will communicate.
AF SQL Database Note: This option must be executed on the machine with the Microsoft SQL Server
installed.
Only the database is installed on the machine.
If you select this option, the database scripts will be copied to the machine and executed
during the installation. This will result in creating the PIFD Asset Framework SQL database.
AF SQL Database with unprocessed database
scripts Note: This option must be executed on the machine with the Microsoft SQL Server
installed.
The system is prepared for the database installation, and the database scripts are copied to
the following location in the Program Files directory: Rockwell Software\FactoryTalk
Historian\PIPC\AF\SQL.
You can create the database manually, using the provided scripts. See "Manually Create or
Upgrade the AF SQL Database (page 55)" for more information.
You may choose to create the AF SQL database manually using the
provided scripts, for example when the configuration of your SQL
server does not allow for the integrated Windows authentication.
During the execution of the database scripts you can provide the
user name and the password to the SQL Server.