Hi, I want to connect a MS SQL server database which is in a remote machine of same domain in a Talend job for reading the databse.
Which authentication is most recommended in this scenario; Windows authentication or SQL server authentication ?
In the case of windows authentication we don't have to specify the username and password of the target machine(machine with SQL Server database) .Is that correct?
Please 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.
