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

Chapter 4 Post-Installation Tasks
58 Rockwell Automation Publication HSE-IN025A-EN-E–September 2013
• Windows authentication example
The following command is an example of using Windows
Authentication on a SQL Server that does not include an
instance name:
GO.bat MySQL PIFD
To execute the SQL scripts:
1. If this is an upgrade, stop the AF server services.
2. Open a command prompt window.
Use osql to run these commands if the T-SQL command-line
utility, sqlcmd, is not installed on your system.
3. Use the following syntax to execute the SQL scripts found in
the SQL folder:
GO.bat <SQLName>[\<SQLInstanceName>] PIFD [<SQLUserName>
<SQLUserPassword>]
where:
•
<SQLName>
is the name of the SQL Server into which the AF SQL
database (PIFD) will be installed.
•
\<SQLInstanceName>
is optional, and should be included if the SQL Server was
installed with an instance name.
•
PIFD
is the name of the AF SQL database.
•
<SQLUserName>
and
<SQLUserPassword>
are optional, and should be used if SQL Server
authentication is required to connect to the SQL Server.
If not provided, the scripts use Windows authentication
to connect to the SQL Server.
The process is complete when the command line looks like:
c:\..\PIPC\AF\SQL\PISYSOLEDB>_