Set up a new MES database

Use the Configurator Database Setup component to create as many MES databases as 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.

Set up a new 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. Select Use Windows integrated security to assign the SQL permissions required to access and query the MES database to the current Windows user account.

   Note: AVEVA recommends using Windows integrated security rather than SQL Server authentication to access SQL Server because it is more secure.

   If Use Windows integrated security is not selected, the SQL permissions must be assigned manually. For more information, see Specify SQL Server user authentication.

   The user account specified here is used to create the SQL Server login for the MES middleware service to access the MES database. Therefore, the user must have the SQL Server administrator credentials required to add a SQL Server login and assign it access to the MES database.

   For more information about specifying the user account to access SQL Server, see Select Windows Integrated Security or SQL Authentication to access the MES database.

3. Select Validate to access SQL server and check for the existence of the specified database.

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

   

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

4. (Optional) 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.