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:
- 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.
- Configure Credential Manager to store credentials used for database access:
- Open Credential Manager.
- Click Windows Credentials, then Add a Windows credential.
- Provide the appropriate values in fields Internet or network
address, User name and Password.
-
Internet or network address must contain the DB Server URL
in format
mysqlserver.mydomain.com:1433. - User name must contain the name of user provided in the
deploy.properties file, found in property
os.service.username - Password must contain the password of user provided in field User name
-
Internet or network address must contain the DB Server URL
in format