topic Re: Connect to SQL Server using Active Directory in Talend Studio

Connect to SQL Server using Active Directory

rphilips7161 — Sat, 16 Nov 2024 10:33:54 GMT

We have Data Quality and Integration version 6.1.1 in a Windows environment. I see that previous versions of studio (3.1 is the only post I saw) did not support an Active Directory Connection to SQL Server. We can connect using a login name and password but our IT department would prefer us to use an Active Directory login. When I try to use Active Directory, I get the following error:
Connection failure, check the database settings or contact your database administrator.
java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.
I have reviewed my documentation and help but do not see an answer for this.
Is it still the case that Active Directory can not be used to connect to a SQL Server database?

Re: Connect to SQL Server using Active Directory

Anonymous — Thu, 23 Jun 2016 09:50:28 GMT

Hi,
So far, connecting to SQL Server with Active Directory account is not supported by talend.
Feel free to create a new feature jira issue of DI project on Talend Bug Tracker.

https://jira.talendforge.org/secure/Dashboard.jspa

Best regards
Sabrina

Re: Connect to SQL Server using Active Directory

rphilips7161 — Thu, 23 Jun 2016 18:13:18 GMT

Thank you!

Re: Connect to SQL Server using Active Directory

HChandran1595899298 — Sat, 03 Oct 2020 07:57:31 GMT

Do we have support for connecting SQL server with Active directory currently? we trying to connect azure sql server from Talend 7.3.1. but not able to do. Hence came across this thread and would like to know current support.