sql_server connection Error

Five 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

Highlighted
Five Stars

Re: sql_server connection Error

i already installed  and the jar file.

Five 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.
Five 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.

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.