Page 1 of 1
Posted: Fri Jul 17, 2015 11:56 am
by qt_ky
Have you tried downloading the newest 7.x ODBC drivers from IBM Support Fix Central? Supposedly there is enhanced support in those for domains. Not sure if that will help. Microsoft tends to invent things that just cause problems!
Posted: Fri Jul 17, 2015 9:22 pm
by nishantrk
Yes We are using IBM Data Direct sql wire 7.1.3 drivers
Re: Connecting to sql server using Windows Authentication
Posted: Wed Aug 05, 2015 8:35 am
by electajay
Correct me if I am wrong here, Datastage ==> SQL (Windows AD authentication will not work )
you need to have local account or ID created on the SQL Server side and try it
if you have security team, they will create that Generic ID on SQL Server and maintain the password.
we are following the same process for couple of years now. its working fine
Thanks
Ajay
Posted: Wed Aug 05, 2015 9:31 am
by ArndW
The last time I tried this was about 2 years ago, and our only solution was to have a local SQL-Server user configured which we then used directly rather than through Windows Authentication.
Posted: Wed Aug 05, 2015 12:56 pm
by qt_ky
That is what we do also, however, the 7.x ODBC drivers for Linux/UNIX claim to support Windows/domain authentication for SQL Server as a new feature...
Posted: Mon Aug 24, 2015 2:25 pm
by I_Server_Whale