topic Re: windows authentication in Talend Studio

windows authentication

tkm1601879874 — Sat, 16 Nov 2024 00:52:38 GMT

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?

Re: windows authentication

Anonymous — Tue, 05 Jan 2021 05:10:06 GMT

Hello,

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.

Best regards

Sabrina