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

F ACTORY T ALK M ETRICS L INE E DITION A DMINISTRATOR ’ S G UIDE
12
• •
•
•
•
5. Click OK. The new FactoryTalk Metrics LE user (for example, FTMLEUser) appears
under the Logins folder.
6. Close the Microsoft SQL Server Management Studio window.
Creating a DSN database connection
1. To launch the ODBC for Windows Server 2003, select Start > All Programs >
Administrative Tools > Data Sources (ODBC). The ODBC Data Source
Administrator dialog box opens.
2. Click the System DSN tab.
3. To create a system DSN connection to this server, click Add. In the Select a driver for
which you want to set up a data source list, select the SQL Native Client driver and
then click Finish. The Create a New Datasource to SQL Server wizard page appears.
4. Complete the following fields:
„
Name. Type the DSN name (for example, FTMLEDSN).
For help creating the SQL Server database or login account, click the Help button or refer to
the RSBizWare Administrator’s Guide.
Select the newly
created database
(for example,
FTMLEDB).
Give the new user
db_owner and
public permissions
for the database.
The db_owner
permission lets the
user create new
tables and perform
other database
administration
functions.
FTMLE Admin Guide.book Page 12 Friday, August 8, 2008 8:28 AM