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.
Wondering why this article doesn't mention the use of a MSSQLServer component or how to do that with the metadata wizard instead of using a Generic JDBC connector.
Would it work with the Talend SQL Server components as well?
which version of SQL Server is that solution compatible with as well? Thank you.