Connecting to sql server using Windows Authentication

qt_ky · Post by **qt_ky** » Fri Jul 17, 2015 11:56 am

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!

nishantrk · Post by **nishantrk** » Fri Jul 17, 2015 9:22 pm

Yes We are using IBM Data Direct sql wire 7.1.3 drivers

electajay · Post by **electajay** » Wed Aug 05, 2015 8:35 am

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

ArndW · Post by **ArndW** » Wed Aug 05, 2015 9:31 am

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.

qt_ky · Post by **qt_ky** » Wed Aug 05, 2015 12:56 pm

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...

I_Server_Whale · Post by **I_Server_Whale** » Mon Aug 24, 2015 2:25 pm

http://www-01.ibm.com/support/docview.w ... wg21687105

DSXchange

Connecting to sql server using Windows Authentication

Re: Connecting to sql server using Windows Authentication