DSXchange

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

You may need to configure upgrade then configure your ODBC drivers.

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.