Not able to make db connection in Talend open studio for DQ

[BSajjad1615375415]

Hi,

I'm not able to make a DB connection in Talend open studio for DQ (version 7.3.1)

DB type is : MSSQL server

Have attached the error logs.

[prg]

Hello @Baiza Sajjad​ 

Please review the below KB article while we continue to view your log.

https://community.talend.com/t5/Design-and-Development/Cannot-connect-to-MS-SQL-Server/m-p/54518#M18...

Let us know if it helps and then mark your case as solved (Kudos also accepted).

Regards,

Vaishnavi

[Anonymous]

Hello,

To use a MSSQL named instance in Talend Open Studio, you only put the server name in the host field. The instance name goes in the Additional Parameters field. So you should try:

Login: yourDBlogin

Password: yourDBpwd

Server: SSS

Port: 1433

Database: yourdbname

Schema: dbo

Additional Parameters: instance=SQLEXPRESS

Best regards

Sabrina

[BSajjad1615375415]

Hi,

My MSSQL uses windows authentication.

How to add parameters then?

Thanks

[Anonymous]

Hello,

Please refer to this article about: https://community.talend.com/s/article/How-to-have-Jobs-connect-to-a-Microsoft-SQL-DB-with-Windows-A...

Best regards

Sabrina

[BSajjad1615375415]

Hi,

Did these steps:

1. Download the JTDS driver, extract the contents, and find the ntlmauth.dll.
2. Move the ntlmauth.dll file to one (or both) of these locations: C:\Program Files\Java\JDK_version\bin\ntlmauth.dll or the Windows folder (C:\Windows\System32\ntlmauth.dll).

Now on making DB connection, I'm getting the error log that I've attached.