Creating an MES Database

The Database Setup component can be used to create as many MES databases as are needed. The databases can be on the same or different SQL Server database servers to support production, restore, test, development, and other types of databases.

The initial MES Database Setup component settings and controls are shown in the following figure.

To create an MES database

1. Complete the database server and MES database name settings:

   Server Name

   The name of the server that is hosting the MES database. The server name defaults to the local server. Supported server names include IP names (IPv4 and IPv6), SQL server named instance conventions, cluster names, and SQL Server Availability Groups.

   When using a Failover or Availability Group naming convention, the configuration must be performed when the primary node is active.

   Database Name

   The name of the MES database. The name defaults to MESDB.

2. Specify the user account to use to access SQL Server.

   For more information about specifying a user account, see Specifying SQL Server User Authentication.

3. To access SQL Server and check for the existence of the specified database, click Validate.

   If the validation is successful and the named database does not exist, the New Database settings appear.

   

   If the named database exists but is not an MES database, an error message appears.

4. Optionally, to set the path, initial size, or percentage growth of either the MES database's data file or log file, click the Advanced settings title to expand the settings.

   

   Path

   The path of the data or log file.

   Initial Size

   The initial size, in MB, of the data or log file.

   Percent Growth

   The percent by which to limit the percent growth of the data or log file.

   When you have completed validating the SQL Server connection and optionally entering any advanced database settings, you are ready to create the MES database.

5. Click Configure.

   The SQL scripts that create the database run. A message appears, asking to wait while the database configuration is performed.

   

   Progress information and any errors, if they occur, appear in the Configuration Messages box.

   If the database creation completes successfully, a success message appears in the Configuration Messages box. Also, the MES Database Setup status indicator changes to a green check mark.

   If errors are encountered, check the Operations Control Management Console Log Viewer for details. To enable additional details, enable the Log Script Execution log flag in the Log Viewer and run the Configure operation again.