sql_server connection Error

[karthik_T]

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.

[Anonymous]

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

[Anonymous]

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

[karthik_T]

i already installed  and the jar file.

[karthik_T]

i already installed  and  added the jar file in modules.

[Anonymous]

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

[karthik_T]

Hi  @xdshi,

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

[Anonymous]

Hello,

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

Best regards

Sabrina