Rockwell Automation FactoryTalk AssetCentre Installation Guide 5.0 User Manual
Page 26
3
•
I
NSTALLING
THE
F
ACTORY
T
ALK
A
SSET
C
ENTRE
SERVER
20
•
•
•
• •
To install SQL Server 2008 so it is compatible with FactoryTalk AssetCentre server:
1. Log on to the server computer as an administrator or as a user with administrative
rights.
2. Start the SQL Server 2008 installation from the SQL Server 2008 discs.
3. Follow the on-screen instructions for installation until you get to the Feature
Selection screen.
4. The Feature Selection screen asks which features of SQL Server 2008 you want to
install. If you like, or if your business requires you to do so, you may install the
complete SQL Server 2008 installation.
If you want to install only those features necessary to run the FactoryTalk AssetCentre
server:
It is possible to install SQL Server 2008 on a different computer from the one on which you
install the FactoryTalk AssetCentre server software.
If you use an existing SQL Server installation:
The SQL Server collation must be dictionary-order, case-insensitive for use with
FactoryTalk AssetCentre software. If your existing SQL Server collation is case-
sensitive, the FactoryTalk AssetCentre database installation will fail. Follow the
directions here if your SQL Server collation is NOT dictionary-order, case-
insensitive.
If this SQL Server has no other databases on it:
Either: Uninstall SQL Server and reinstall it using the default collation in the
setup program. (This statement applies to English language Microsoft Windows
operating systems and SQL Server software. For other languages, be sure to
select a dictionary-order, case-insensitive collation when reinstalling.)
Or: Rebuild the master database using a dictionary-order, case-insensitive
collation. Refer to the SQL Server 2008 online books for instructions.
If this SQL Server has other databases on it, then setup or use another SQL Server
that is configured with a dictionary-order, case-insensitive collation.
If you have an MSDN subscription you can find more information at
r search the Microsoft
MSDN site for SQL Server 2008 collation settings.
FTAC-IN005A-EN-E.book Page 20 Monday, March 4, 2013 4:03 PM