How to have jobs connect to a Microsoft SQL DB with Windows Authentication accounts?
Configure by following these steps:
Format the connection string in your new database connection (General JDBC) as follows:
Note: Ensure that the login, password, server, port, and database fields are blank. If you are doing Windows Authentication, you need to specify them in the connection string, not in the fields.