Specify SQL Server user authentication

Several of the product components require you to specify a user account to access SQL Server. The MES components use a common interface that might look slightly different from other product components. For the MES components, the two user account options are described below.

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

• To use the currently logged-in Windows user account, select the Use Windows integrated security option. No user name or password entry is required.

  

• To use SQL Server authentication, unselect the the Use Windows integrated security option. Enter the appropriate SQL Server Authentication user name and password.

  

  If using this option, make sure that the SQL user account has been created. If the user account is being used to access the MES production or restore database, make sure that it is assigned the appropriate database roles. For more information on how to create a login, see Create an SQL Server login.