DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
raji33



Group memberships:
Premium Members

Joined: 23 Sep 2010
Posts: 144
Location: NJ
Points: 1195

Post Posted: Fri Sep 08, 2017 11:55 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
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



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2593
Location: USA
Points: 18827

Post Posted: Fri Sep 08, 2017 3:16 pm Reply with quote    Back to top    

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
Rate this response:  
Not yet rated
PaulVL



Group memberships:
Premium Members

Joined: 17 Dec 2010
Posts: 1129

Points: 7485

Post Posted: Fri Sep 08, 2017 4:29 pm Reply with quote    Back to top    

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.
Rate this response:  
Not yet rated
JRodriguez



Group memberships:
Premium Members

Joined: 19 Nov 2005
Posts: 397
Location: New York City
Points: 4301

Post Posted: Sat Sep 09, 2017 9:01 am Reply with quote    Back to top    

To connect to SQL Server databases with Windows athentication you would need the DataDirect drivers 7.0 of the SQL Server Wire Protocol driver, the functionality is not supported in previous versions

Add below two new mandatory lines to the ODBC entry, the rest remain as in the legacy version:
AuthenticationMethod=9
 Domain=WindowsDomainName

​The SQL Server login assigned to the Windows account determine the WindowsDomainName, and the Authentication Method "9" signal the SQL Server connection to connect using NTLM authentication

Try it out and post any issues

_________________
Julio Rodriguez
ETL Developer by choice

"Sure we have lots of reasons for being rude - But no excuses
Rate this response:  
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours