topic Re: Not able to make db connection in Talend open studio for DQ in Talend Studio

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

BSajjad1615375415 — Sat, 16 Nov 2024 00:23:54 GMT

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.

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

prg — Mon, 22 Mar 2021 17:37:19 GMT

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#M18563

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

Regards,

Vaishnavi

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

Anonymous — Tue, 23 Mar 2021 03:44:57 GMT

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:

Password: yourDBpwd

Server: SSS

Port: 1433

Database: yourdbname

Schema: dbo

Additional Parameters: instance=SQLEXPRESS

Best regards

Sabrina

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

BSajjad1615375415 — Tue, 23 Mar 2021 06:02:25 GMT

Hi,

My MSSQL uses windows authentication.

How to add parameters then?

Thanks

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

Anonymous — Tue, 23 Mar 2021 09:18:58 GMT

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-Authentication-accounts-QPbgE

Best regards

Sabrina

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

BSajjad1615375415 — Tue, 23 Mar 2021 09:56:07 GMT

Hi,

Did these steps:

Download the JTDS driver, extract the contents, and find the ntlmauth.dll.
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.