topic Re: sql_server connection Error in Talend Studio

sql_server connection Error

karthik_T — Fri, 25 May 2018 13:37:19 GMT

i am trying to connect mssql server from tos 6.4 which is installed in windows server 2012r2 & the sql server in other(remote) machine. But it showing error like mentioned in attached screen shot.

Re: sql_server connection Error

Anonymous — Tue, 29 May 2018 04:51:42 GMT

Hello,

Have you already installed all required external jar in your V 6.4 studio? Are you using a JDBC component? The screenshots of your DB connection will be preferred.

Best regards

Sabrina

Re: sql_server connection Error

Anonymous — Tue, 29 May 2018 08:04:26 GMT

Hello,

Check if you have installed proper JAR for using mssql server.
You can check it using following path :
Window --> Show View -->Talend --> Modules

If not installed, Please add appropriate JAR and check the connection.

Thanks,
Trupti

Re: sql_server connection Error

karthik_T — Tue, 29 May 2018 12:17:46 GMT

i already installed and the jar file.

Re: sql_server connection Error

karthik_T — Tue, 29 May 2018 12:19:06 GMT

i already installed and added the jar file in modules.

Re: sql_server connection Error

Anonymous — Thu, 07 Jun 2018 08:04:56 GMT

Hello,

This issue is because the drvier jar is incorrect or the dll file config is incorrect. Have you tried to select "Open source JTDS" Db version to see if it works?
Best regards

Sabrina

Re: sql_server connection Error

karthik_T — Sun, 10 Jun 2018 16:28:41 GMT

Hi @xdshi,

Thanks for your reply, the credentials are wrong and now i can connect.

Re: sql_server connection Error

Anonymous — Thu, 05 Jul 2018 07:43:07 GMT

Hello,

Thanks for your feedback. Feel free to mark this topic as resolved.

Best regards

Sabrina