Guidelines for changing the MES Middleware Service Windows User Account

If the MES middleware and database are on different server nodes, use the following guidelines to change the MES middleware service's Windows user account from the default account. This will ensure that the MES middleware user account has proper SQL permissions for the MES database.

Note that changing the MES middleware service's user account should be performed prior to configuring the DB/MW Communication component.

Using a Domain User Account

If the account used by the MES middleware service is a valid domain account (for example, ourDomain\mesuser), then that domain account can be used when the minimum SQL permissions are set during the DB/MW Communication component configuration.

Using a Virtual Service Account

If the account used by the MES middleware service is a virtual service account (for example, NT Authority\Network Service or NT Authority\Local Service), then the minimum SQL permissions that are set during the DB/MW Communication component configuration will be given against the domain and the MES Middleware server node (for example, ourDomain\MESMWNode$).

Using a Local User Account

If the account used by the MES middleware service is a valid local account (for example, MESMWNode\mesuser), then that user account will not be given the minimum SQL permissions during the DB/MW Communication component configuration. Sample SQL statements to provide authorization are logged in the output window. You can run these SQL statements manually to provide the minimum SQL permissions to the local user account.