Select Windows Integrated Security or 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.

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

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. For more information, see Specify SQL Server user authentication.