Rockwell Automation FactoryTalk Alarms and Events Quick Start - Manual (Page 199)

191
Appendix E
Use an existing Microsoft SQL Server database
FactoryTalk Alarms and Events uses Microsoft SQL Server as the database engine for
logging alarm and event information. You can connect to an existing SQL Server
database, or you can install Microsoft SQL Server 2005 Express, Service Pack 2,
which is included in the Redist folder on the FactoryTalk View Site Edition and
RSLinx Enterprise CDs. For more information, see Appendix D, “Install Microsoft
SQL Server 2005 Express”.
You must set up the correct settings for logging alarm and event data if you are using
an existing Microsoft SQL Server database. For more information on the settings, see
“Summary of steps”.
Supported SQL Server databases
FactoryTalk Alarms and Events can use any of the following SQL Server databases:
„ Microsoft SQL Server 2005 Express, Service Pack 2
„ Microsoft SQL Server 2005
„ Microsoft SQL Server 2000, Service Pack 4
Remote connections to the SQL Server database
To allow remote connections to the database you must configure the TCP/IP protocol,
the SQL Server Browser, and the Windows Firewall. Set this up if you:
„ have remote clients (for example, a log viewer) that needs access to the database
„ want to configure the database remotely
Summary of steps
„ Step 1: Install Microsoft SQL Server Management Tools
„ Step 2: Specify Mixed Mode authentication for the SQL Server database
„ Step 3: Configure TCP/IP protocol for the database
„ Step 4: Enable the SQL Server Browser service
„ Step 5: Configure the Windows Firewall