Running batch with integrated security database connections

There are two preferred ways of running batch processes if your environment is configured to use Integrated Authentication for MS SQL Server:

  1. Run all batch processes with the exactly the same domain user as the one configured to access EO databases. No further configuration steps are necessary.
  2. Configure Credential Manager to store credentials used for database access:
    1. Open Credential Manager.
    2. Click Windows Credentials, then Add a Windows credential.
    3. Provide the appropriate values in fields Internet or network address, User name and Password.
      1. Internet or network address must contain the DB Server URL in format mysqlserver.mydomain.com:1433.
      2. User name must contain the name of user provided in the deploy.properties file, found in property os.service.username
      3. Password must contain the password of user provided in field User name