topic DB connectivity issue in Talend Studio

DB connectivity issue

AGR1997 — Mon, 23 Sep 2024 15:31:54 GMT

Db (SQL Server) connectivity is failing using tdbinput component using JDK 17 and Talend 8.

Error: Execution f4b1b056-1871-40e0-a84f-3e16bf7b6d5e failed with code 1 and error Job stopped with errors or unable to run. Exception in component tDBInput_1 (TestTMC) java.sql.SQLException: Login failed for user.

I am getting the issue when using latest version of Remote engine (2.13.6), with the older one it works fine

Re: DB connectivity issue

Xiaodi_Shi — Thu, 26 Sep 2024 08:13:20 GMT

Hello,

The connection information in the metadata setup is correct with you?

Does your job run fine within Studio or just not when you try to run it from TMC?

Best regards

Sabrina

Re: DB connectivity issue

fcolagiacomo — Mon, 07 Oct 2024 20:55:54 GMT

The error means username or password are incorrect. The connection is ok else it cannot response you "Login failed user". I suggest to check the password, probably you have to add double quote or remove them in password field