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

F ACTORY T ALK A SSET C ENTRE M ACHINE E DITION I NSTALLATION G UIDE
22
• •
•
•
•
„
If your Windows Firewall/Internet Connection Sharing (ICS) service is stopped or is
disabled, the FactoryTalk AssetCentre Windows Firewall Configuration window will
indicate this with a red x. Click Continue. The FactoryTalk AssetCentre Machine
Edition agent installation is complete.
If you are using a firewall other than Windows Firewall, use the information in
“Network requirements” on page 4 and “Additional ports you may have to open” on
page 35 to configure your firewall to allow communication through the appropriate
ports and with specific processes.
„
If your Windows Firewall/Internet Connection Sharing (ICS) service is running, the
FactoryTalk AssetCentre Windows Firewall Configuration window will indicate this
with a green check mark. Click Start. The Rockwell Software Windows Firewall
Configuration Utility window opens. The list of exceptions (things to allow through
the firewall) generally includes default SQL server and e-mail ports.
„
If no exceptions need to be made, none will be listed and the Accept button will be
unavailable. In that case, click Exit to close this utility.
„
Click Accept. On the Confirm Windows Firewall Changes window make the
appropriate selection depending on whether your Windows Firewall will be on or
off, then click OK.
Set Microsoft SQL Server Express Permissions
Finally, now that FactoryTalk AssetCentre Machine Edition has been installed, the SQL
Server administrator must set the minimum required SQL Server Express permissions.
The AssetCentreUser SQL user’s default database value can be “master” or
“AssetCentre.” By default, the database value is set to “AssetCentre.” The
AssetCentreUser SQL user needs to belong to the following AssetCentre database roles:
„
db_dataexecute
„
db_datareader
„
db_datawriter
„
public
The “db_dataexecute” database role is added to the FactoryTalk AssetCentre database at
install time. It is used to group Execute permissions of stored procedures and functions
within the AssetCentre database.
All of the user stored procedures and user functions in the FactoryTalk AssetCentre
database need to have the Execute permission granted to the “db_dataexecute” database
role.