But before your FTAE configuration will have the ability to maintain a historical record of your alarms, you’ll first need to connect your View Studio project to a FactoryTalk Alarm and Events database.
And before you can create and connect to a FTAE database, you first need access to a MS SQL Server Server or MS SQL Server Express database server.
The procedure for installing SQL Server is also well documented in Rockwell's “FT Alarms and Events System Configuration Guide, PUBLICATION FTAE-RM001G-EN-E” that comes with FactoryTalk View Studio.
NOTE: You can purchase an “ad free” copy of this article from our article shop HERE, or become a “Premium Member” for as little as $3 a month and receive $5 worth of articles and code downloads free each month!
With a copy of MS SQL Server installed (or accessible,) open your FactoryTalk View Studio project.
Next, under System – Connections, right click on Databases and select “New Database”
Now fill in a new Definition Name, new Database User Name, and new Database name that you want View Studio to use when creating your FTAE Database and connection:
Once View Studio verifies the Database doesn’t already exist, you receive the below prompt in which you’ll want to click on “Yes”
After a few moments you should see your new Database Connection appear in the Project Tree:
And if you were to open SQL Server Management Studio, you would also find View Studio has created your database and user (in this example they are MyDatabase and MyUserName)
However, if you get the below error message you'll want to check out my article on how to resolve that issue here:
Have a question or comment? Please feel free to leave them with us by clicking on the “leave a reply” link at the very bottom of this page.
Need personalized help? For as little as $25 per month you can get direct access to ask me Rockwell PLC, HMI, and SCADA questions! Learn the details at Patreon.com/Automation