sql_server connection Error

Four Stars

sql_server connection Error

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.

 

Moderator

Re: sql_server connection Error

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

 

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: sql_server connection Error

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

Four Stars

Re: sql_server connection Error

i already installed  and the jar file.

Four Stars

Re: sql_server connection Error

i already installed  and  added the jar file in modules.

Moderator

Re: sql_server connection Error

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

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: sql_server connection Error

Hi  xdshi,

 

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

Moderator

Re: sql_server connection Error

Hello,

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

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.