Installing the database components, Installing microsoft sql server, Creating the databases – Rockwell Automation Emonitor with an MS SQL Networked Database User Manual

Page 11

Advertising
background image

7

2

Installing the database components

This chapter goes through the database installation process.

Installing Microsoft SQL Server

If you have a database server already installed and you have checked the version number
to make sure it is compatible with Emonitor, you can skip this section. The minimum
Microsoft SQL Server database version supported by Emonitor is version 2008. As
always, if you are updating, back up your database directories to insure that you have a
backup copy.

Refer to the Microsoft documentation for instructions on installing the database server,
including the choice of Microsoft operating systems. The server installation procedures
may require a database administrator to complete the configuration.

Installing database components for SQL Server 2008 and 2012

Creating the databases

You must create the databases that hold the data for Emonitor. This section shows you
how to create the databases and the users, or logins, for those databases.

1. Start Microsoft SQL Server Management Studio by choosing it from the Start menu.

2. Open the Databases directory by expanding the hierarchy on the left-hand side.

The Group names in the following steps (ENTEKI, ENTEKD) are recommended but not required;
you can substitute different Group names in the steps.

Advertising