Rockwell Automation FactoryTalk Metrics Line Edition Administrators Guide - Manual (Page 14)

F ACTORY T ALK M ETRICS L INE E DITION A DMINISTRATOR ’ S G UIDE
10
• •
•
•
•
Creating a SQL Server database
If you do not have an existing SQL Server database for FactoryTalk Metrics LE, create a
new SQL Server database and data source.
To create a SQL Server database:
1. Launch SQL Server. Select Start > All Programs > SQL Server 2005 > SQL Server
Management Studio.
2. In the Object Explorer pane, right-click Databases and select New Database.
3. In the Database name field, type the name to be given to your FactoryTalk Metrics LE
database (for example, FTMLEDB):
:
C REATING A SQL S ERVER LOGIN ACCOUNT
Creating a new SQL Server login account is optional. You only have to create a new SQL
Server login account if you do not yet have a login account to use for SQL Server.
To create a SQL Server login account:
1. Under the Security folder in the Object Explorer pane, right-click the Logins folder
and select New Login. The Login - New dialog box appears.
2. On the General page of the dialog box, complete the following fields:
„
Login name. Type the name of the user (for example, FTMLEUser).
„
SQL Server authentication. Select this option to authenticate the new user
through SQL Server rather than Microsoft Windows.
„
Password. Type the user password (for example, FTMLEUser) for the SQL
Server database.
„
Confirm Password. Re-type the user password.
„
Default database. Select the SQL Server database you created for FactoryTalk
Metrics LE (for example, FTMLEDB).
FTMLE Admin Guide.book Page 10 Friday, August 8, 2008 8:28 AM