Connecting to SQL server using windows authentication

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
SagarMelam
Participant
Posts: 26
Joined: Mon Apr 21, 2008 4:03 am
Location: Amalapuram

Connecting to SQL server using windows authentication

Post by SagarMelam »

Hi ,

Can we connect to Sql server using Windows authentication in Datastage because i heard that odbc drivers doesn't support windows authentication and only support sql authentication.Can any one let me know on if it is true.
Sagar
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

From a server on UNIX, the answer always used to be no.

I have not yet tested the newer ODBC drivers myself, but the docs had said this feature was coming.

viewtopic.php?t=145443&start=15
Choose a job you love, and you will never have to work a day in your life. - Confucius
SagarMelam
Participant
Posts: 26
Joined: Mon Apr 21, 2008 4:03 am
Location: Amalapuram

Post by SagarMelam »

Thank you
Sagar
Post Reply