SQL server login issue

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
raji33
Premium Member
Premium Member
Posts: 151
Joined: Thu Sep 23, 2010 9:21 pm
Location: NJ

SQL server login issue

Post by raji33 »

Hi All,

We have a situation where we can able to connect to sql server db with generic sql account, But our requirement got changed and now we want to connect the db using windows user as the access to database is controlled by AD group. We can able to connect through sql tool using same windows user but unable to connect through datastage. Can anyone guide/suggest me what changes needs to be done to make it successfull.

Thanks
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

You may need to configure upgrade then configure your ODBC drivers.
Choose a job you love, and you will never have to work a day in your life. - Confucius
PaulVL
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post by PaulVL »

Actually... are you passing USERID and PASSWORD to your ODBC stage?

Seems like it should work to me as the authentication values are being passed in and should be all on the SQL Server side and not on your Unix ETL server side.

Make a dummy job, select a table you KNOW your user id has access to, and fill in the parameters when you run the job IN DEV.

Show us any error message you are getting. You can also enable ODBC tracing for that connection, then turn it off and look at the log file.
Post Reply