Rockwell Automation Emonitor with an MS SQL Networked Database - Manual (Page 15)

2 • I NSTALLING THE DATABASE COMPONENTS
11
•
•
•
• •
c. Click OK.
Repeat this step to create an EConfig user with a database role of db_owner on the
EConfig database.
11. Next, see Running the database creation script below.
Running the database creation script
You must run a database creation script to create the Entek and EConfig databases. If the
Entek databases already exist, you can connect to them, and you do not need to follow
these steps.
If you need to create the database, follow these steps. You can run the script either from
the server or from a client machine.
1. Start Microsoft SQL Server Management Studio by choosing it from the Start menu.
2. Select File > Open File. Select SQL Server files for Files of type, and then select the
entekmsq.sql scrip file, located in the Emonitor program directory:
C:\Program Files\Rockwell Software\Emonitor\entekmsq.sql
3. Select Query > Execute, or press F5. This creates the Entek database structure.
4. Next, open and run the EConfig creation script, cfgmsq.sql, located in the following
directory. This creates the EConfig database structure.
C:\Program Files\Rockwell Software\Emonitor\cfgmsq.sql
Installing the network client
If using MS SQL Server 2008/2012, each Emonitor client computer must have the file
ntwdblib.dll present in the c:\Windows\System32 folder. You must manually copy this file
from c:\Program Files\Rockwell Software\Emonitor into the c:\Windows\System32
folder.
The database creation scrips are installed with the Emonitor software (described in Chapter 3 -
Installing Emonitor). You must install Emonitor first, and then run the database creation scripts.
The scripts may need to be modified to use the correct Group names.
If your database administrator chooses not to use file groups, you must edit the database
creation scripts to remove any reference to 'on enteki' and 'on entekd'
Do not attempt to use ODBC with the client to connect to the SQL Server database.