Specifying 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.

• 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, clear 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. See Manually Adding a SQL Server Login for the Middleware Service.