Using Windows Integrated Security vs​. SQL Authentication to Access the MES Database

The MES middleware service must be assigned to a SQL Server login that has the proper permissions to access the MES database.

Unless Workgroups is being used to manage user accounts and the middleware is on a different node than the MES database, the MES middleware service can use Windows integrated security to access the MES database. If this approach is chosen, the MES DB/MW Communications component Security tab includes an option to automatically add the middleware service Windows user account as a SQL Server login when the MES DB/MW Communications component is configured.

If Windows integrated security is not or cannot be used, then the middleware service must use an existing SQL Server login with the appropriate access to the MES database. See Manually Adding a SQL Server Login for the Middleware Service.