How to create a FactoryTalk Alarm and Events Database in View Studio

The Automation School – HMI Basics – Article Banner

FTView_8_SplashSo you’re using FactoryTalk View Studio and are ready to setup FactoryTalk Alarm and Events (FTAE.)

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.

In most cases it’s easiest to just install a new instance of the free MS SQL Server Express which comes on the FactoryTalk View Studio installation discs and in the View Studio download package.

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”

ftae-connect-1

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:

ftae-connect-2

Once View Studio verifies the Database doesn’t already exist, you receive the below prompt in which you’ll want to click on “Yes”

ftae-connect-3

After a few moments you should see your new Database Connection appear in the Project Tree:

ftae-connect-10

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)

ftae-issue-5

However, if you get the below error message you’ll want to check out my article on how to resolve that issue here:

ftae-issue-4

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.

Sincerely,

Shawn Tierney
Automation Blogger and Trainer

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

The Automation School – HMI Basics – Article Banner

Check Also

FactoryTalk View Studio Splash Fi

FactoryTalk View Site Edition 8.1 Released

Late last week Rockwell Automation released version 8.1 of FactoryTalk View Site Edition. In Today’s article …

Rockwells-RSView-to-ViewSE-Videos Fi

Rockwell's RSView32 Migration Videos

All this week we’ve been talking about RSView32 to FactoryTalk View SE migration, and today …