topic Re: Error While Create SQL Server Connection in Talend Studio

Error While Create SQL Server Connection

Anonymous — Sat, 16 Nov 2024 02:16:11 GMT

Hello,

I have problem while create DB Connection to my SQL Server localhost.

I can connect to my SQL Server localhost with no issue but when i try to create DB Connection from Talend the error appears.

I'm using TOS_BD-20200219_1130-V7.3.1 that run in 64bit on my 64bit OS laptop.

This is my connection to my localhost

This is my DB Connection properties

this is the error message

I've tried with tDBconnection but it's still an error too.

I have also installed all mssql-jdbc.jar and all of mssql module on Talend but didn't had any change.

Can anyone give me recommendation what should i do?

Thank you.

manodwhb — Tue, 02 Jun 2020 09:20:07 GMT

@fajarkom ,can you choose Open source JTDS from DB version and check that is that issue exists?

Anonymous — Tue, 02 Jun 2020 09:29:19 GMT

@manodwhb, still error but different error message

if i choose Open Source JTDS the error is Login failed for user 'sa'

Anonymous — Mon, 08 Jun 2020 05:43:48 GMT

case closed, i just set up new password for my sql server connection