Error While Create SQL Server Connection

[Anonymous]

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]

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

[Anonymous]

@manodwhb, still error but different error message

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

[Anonymous · Accepted solution]

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