Rockwell Automation FactoryTalk AssetCentre Installation Guide 5.0 - Manual (Page 27)

3 • I NSTALLING THE F ACTORY T ALK A SSET C ENTRE SERVER
21
•
•
•
• •
a. On the Feature Selection screen, make sure the following features are selected:
 Database Engine Services
 SQL Server Replication
 Full-Text Search
 Client Tools Connectivity
 Client Tools Backwards Compatibility
 Management Tools - Basic
b. Click Next.
5. Follow the on-screen instructions for installation until you get to the Server
Configuration screen.
6. In the Server Configuration screen, the Services Accounts tab asks how you want to
run the services for the SQL Server. Specify the account name and password for each
SQL Server service.
7. In the Server Configuration screen, click the Collation tab and then click the
Customize button next to the Database Engine Collation area to specify the Database
Engine collation. In the Customize the SQL Server 2008 Database Engine Collation
dialog box, select SQL collation and then select the
SQL_Latin1_General_CP1_CI_AS option.
8. In the Database Engine Configuration window, click the Account Provisioning tab and
then select Mixed Mode (SQL Server Authentication and Windows
authentication). This means that both the SQL Server and the Windows domain can
authenticate users for the SQL Server.
FactoryTalk AssetCentre uses SQL Server authentication.
You can run the SQL Server using a domain account. This can, however, complicate system
maintenance (for instance, when changing passwords). If you are not sure of the type of
account you should use for running the SQL Server, consult your network administrator.
The collation settings must be case-insensitive! If the settings are case-sensitive, the
FactoryTalk AssetCentre database installation will fail.
FTAC-IN005A-EN-E.book Page 21 Monday, March 4, 2013 4:03 PM