Rockwell Automation FactoryTalk AssetCentre Machine Edition Installation Manual - Manual (Page 14)

F ACTORY T ALK A SSET C ENTRE M ACHINE E DITION I NSTALLATION G UIDE
10
• •
•
•
•
9. In the Authentication Mode window, click Mixed Mode (Windows Authentication
and SQL Server Authentication). This means that both the SQL Server and the
Windows domain can authenticate users for the SQL Server.
FactoryTalk AssetCentre Machine Edition uses SQL Server authentication.
When you click Mixed Mode, fields open for entering the password for the sa (SQL
Server system administrator) account password. Do not forget the password. You
will need this password when you install FactoryTalk AssetCentre Machine Edition.
10. In the Collation Settings window, select SQL collations and then the dictionary-order,
case-insensitive collation option.
11. Follow the on-screen instructions to complete the installation.
Installing Microsoft SQL Server Management Studio Express
The Microsoft SQL Server Management Studio Express provides the graphical interface
with which you can manage SQL Server 2005 Express Edition.
1. The FactoryTalk AssetCentre Machine Edition installation menu for Microsoft SQL
Server should still be open from the previous section.
2. Click Microsoft SQL Server Express Management Studio and follow the on-screen
instructions to install the software.
3. Click Back to return to the FactoryTalk AssetCentre Machine Edition installation
menu.
Local help files are not included with the Microsoft SQL Server Management Studio
Express. You can access help over the Internet from the Help menu. Online books are also
available at
http://msdn.microsoft.com/en-us/library/ms165706(SQL.90).aspx . (Internet
addresses are subject to change without notice.)
Do not leave the password blank. Doing so leaves your SQL Server and your computer open
to attack.
The collation settings must be case-insensitive! If the settings are case-sensitive, the
FactoryTalk AssetCentre Machine Edition database installation will fail.