Windows connectivity to DB

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
kennyapril
Participant
Posts: 248
Joined: Fri Jul 30, 2010 9:04 am

Windows connectivity to DB

Post by kennyapril »

Hello,

We are using 8.0 version of datastage and trying to connect to SQL server 2008 with windows authentication.

Can we get connected or we need only SQL Authentication?


Please provide your input
Regards,
Kenny
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

At my site I couldn't get the windows authentication to work and thus used a specific user id.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I would imagine you'd need DataStage to be running on a Windows server for that to work.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply