MES DB/MW Communication component properties

MES Production Database Connection String Properties

These properties specify the connection string that the MES middleware service will use to connect to SQL Server and the MES production database.

• MES.FactMiddle.ProductionServerName

  The name of the server that is hosting the MES production database.

  If this property is not specified, the server name defaults to the node name if a connection string was not previously saved or to the server name entered for the previously saved connection string.

• MES.FactMiddle.ProductionDatabaseName

  The name of the MES production database.

  If this property is not specified:

  • If this is a new installation and the connection string has not been created yet, the name defaults to MESDB.

  • If the connection string has been previously created or the database was migrated from a previous release, the actual database name is used.

• MES.FactMiddle.ProductionUseIntegratedSecurity

  Specifies which security method should be used to connect to the production database.

  Values are:

  • True: Use Windows Integrated Security. The currently logged-in Windows user account will be used to connect to SQL Server and the MES database. No user name or password has to be specified in the response file.

  • False: Use SQL Server Authentication. Specify the appropriate SQL Server Authentication user name and password with the ProductionUserName and ProductionDatabasePassword properties.

    When false, the ProductionUseIntegratedSecurity property must always precede the ProductionUserName and ProductionDatabasePassword properties. Otherwise, the false setting of this property will cause the values of the ProductionUserName and ProductionDatabasePassword properties to be cleared.

    The default value true is used if this property is not specified.

• MES.FactMiddle.ProductionUserName

  If SQL Server Authentication is being used, the SQL user name.

• MES.FactMiddle.ProductionDatabasePassword

  If SQL Server Authentication is being used, the SQL user password.

• MES.FactMiddle.ProductionAdvancedSettings

  (Optional) Used to append advanced settings to the database connection string.

  The advanced settings allow you to set properties that affect the database connection behavior, such as tuning the connection to your environment or to set up database mirroring. For example, entering Connect Timeout=300 would cause the connection to attempt to connect to the database for up to 300 seconds.

  For a list of the SQL database connection properties that can be set, see the Microsoft MSDN SqlConnectionStringBuilder Class topic.

• MES.FactMiddle.ProductionSetPreferredMiddlewareHost

  (Optional) If multiple MES middleware hosts are running in a multi-node environment, you can designate which one is the preferred middleware host for this database. To use the local middleware host, if one is installed, set this property to true. The default is false.

• MES.FactMiddle.ProductionDefaultTimeZoneId

  Optional. To change the time zone for the database, use this property to specify the new time zone. Unless it has been changed, the time zone defaults to that of the server on which the database is installed.

  The time zone entry must be in the standard Windows time zone format [e.g., (UTC-08:00) Baja California]. You can see a list of time zones and their proper format using the following methods:

  • In the post-install Configurator, in the Default Time Zone list on the Production tab of the MES DB/MW Communication component

  • By running the following command in a Windows Command Prompt window: tzutil /l

MES Restore Database Connection String Properties

These properties specify the connection string that the MES middleware service will use to connect to SQL Server and the MES restore database.

• MES.FactMiddle.EnableRestoreDatabase

  If MES is going to support a restore database, set this property to true. If not, set it to false.

  If set to true, make sure that the restore database has already been created.

  The default value false is used if this property is not specified.

• MES.FactMiddle.RestoreServerName

  The name of the server that is hosting the MES restore database.

  If this property is not specified, the server name defaults to the node name if a connection string was not previously saved or to the server name entered for the previously saved connection string.

• MES.FactMiddle.RestoreDatabaseName

  The name of the MES restore database.

  If this property is not specified:

  • If this is a new installation and the connection string has not been created yet, the name defaults to RestoreDB.

  • If the connection string has been previously created or the database was migrated from a previous release, the actual database name is used.

• MES.FactMiddle.RestoreUseIntegratedSecurity

  Specifies which security method should be used to connect to the restore database

  Values are:

  • True: Use Windows Integrated Security. The currently logged-in Windows user account will be used to connect to SQL Server and the MES database. No user name or password has to be specified in the response file.

  • False: Use SQL Server Authentication. Specify the appropriate SQL Server Authentication user name and password with the RestoreUserName and RestoreDatabasePassword properties.

    When false, the RestoreUseIntegratedSecurity property must always precede the RestoreUserName and RestoreDatabasePassword properties. Otherwise, the false setting of this property will cause the values of the RestoreUserName and RestoreDatabasePassword properties to be cleared.

    The default value true is used if this property is not specified.

• MES.FactMiddle.RestoreUserName

  If SQL Server Authentication is being used, the SQL user name.

• MES.FactMiddle.RestoreDatabasePassword

  If SQL Server Authentication is being used, the SQL user password.

• MES.FactMiddle.RestoreAdvancedSettings

  Optional. Used to append advanced settings to the database connection string.

  The advanced settings allow you to set properties that affect the database connection behavior, such as tuning the connection to your environment or to set up database mirroring. For example, entering Connect Timeout=300 would cause the connection to attempt to connect to the database for up to 300 seconds.

  For a list of the SQL database connection properties that can be set, see the Microsoft MSDN SqlConnectionStringBuilder Class topic.

MES Middleware Service User Account Properties

These properties specify:

• Whether to automatically set the minimum SQL permissions on the MES databases for the MES middleware service Windows user account

• If permissions will be set automatically, the admin user accounts that are authorized to set the permissions on the MES databases

• MES.FactMiddle.SetMinimalSqlPermissions

  Set this property to True to have the minimal SQL permissions set to allow the MES middleware service user account to perform the required operations on the MES databases.

  If set to False, then you will have to manually set up the SQL permissions and assign them to the MES middleware service user account using the SQL Server Management Studio. For more information about the minimal SQL permissions that are needed, see Assigning SQL Server Database Roles to the MES Middleware Service User Account.

  The default value true is used if this property is not specified.

• MES.FactMiddle.ProductionAdminUseIntegratedSecurity

  Applies only if the SetMinimalSqlPermissions property is set to true.

  Values are:

  • True: Use Windows Integrated Security. The currently logged-in Windows user account will be used to set the MES middleware service user account SQL permissions for the MES production database. The user must have administrator privileges to set SQL permissions.

  • False: Use SQL Server Authentication. Specify the appropriate SQL Server Authentication user name and password with the ProductionSecuritySqlUserName and ProductionSecuritySqlPassword properties.

    When false, the ProductionAdminUseIntegratedSecurity property must always precede the ProductionSecuritySqlUserName and ProductionSecuritySqlPassword properties. Otherwise, the false setting of this property will cause the values of the ProductionSecuritySqlUserName and ProductionSecuritySqlPassword properties to be cleared.

    The default value true is used if this property is not specified.

• MES.FactMiddle.ProductionSecuritySqlUserName

  If SQL Server Authentication is being used, the user name of the SQL user account that has administrator privileges to set SQL permissions for the MES production database.

• MES.FactMiddle.ProductionSecuritySqlPassword

  If SQL Server Authentication is being used, the password of the SQL user account that has administrator privileges to set SQL permissions for the MES production database.

• MES.FactMiddle.UseProductionCredentialsForRestore

  Applies only if the EnableRestoreDatabase property is set to true.

  Values are:

  • True: Use the same user account to set the MES middleware user service account SQL permissions for the MES restore database as the one being used for the production database.

  • False: Use the user account specified by the RestoreAdminUseIntegratedSecurity, RestoreSecuritySqlUserName, and RestoreSecuritySqlPassword properties.

    The default value true is used if this property is not specified.

• MES.FactMiddle.RestoreAdminUseIntegratedSecurity

  Applies only if the SetMinimalSqlPermissions property is set to true and the UseProductionCredentialsForRestore is set to false.

  Values are:

  • True: Use Windows Integrated Security. The currently logged-in Windows user account will be used to set the MES middleware service user account SQL permissions for the MES restore database. The user must have administrator privileges to set SQL permissions.

  • False: Use SQL Server Authentication. Specify the appropriate SQL Server Authentication user name and password with the RestoreSecuritySqlUserName and RestoreSecuritySqlPassword properties.

    When false, the RestoreAdminUseIntegratedSecurity property must always precede the RestoreSecuritySqlUserName and RestoreSecuritySqlPassword properties. Otherwise, the false setting of this property will cause the values of the RestoreSecuritySqlUserName and RestoreSecuritySqlPassword properties to be cleared.

    The default value true is used if this property is not specified.

• MES.FactMiddle.RestoreSecuritySqlUserName

  If SQL Server Authentication is being used, the user name of the SQL user account that has administrator privileges to set SQL permissions for the MES restore database.

• MES.FactMiddle.RestoreSecuritySqlPassword

  If SQL Server Authentication is being used, the password of the SQL user account that has administrator privileges to set SQL permissions for the MES restore database.

• MES.FactMiddle.AIMHost

  The fully qualified domain name of the node on which the AVEVA Identity Manager is running.

• MES.FactMiddle.AIMHttpsPort

  The HTTPS port number for the Identity Manager.

  The default HTTPS port number 443 is used if this property is not specified.

• MES.FactMiddle.ClientRegistrationUserName and MES.FactMiddle.ClientRegistrationUserPassword

  The user name and password of an admin account on the node on which the Identity Manager is running.