Hi All,
Below is the issue:
1) There is a database on SQL server which has access to windows NT id and not to DataStage admin id.
2) Created a DSN with DataStage admin id (as windows NT id does not have access to create DSN) on DataStage server to connect to the above database.
3) Created a simple job with ODBC stage as source and another ODBC as destination(some other database having all the access to all the id's).
3) If we run this job with above DSN in source with windows NT id (used to log in to DataStage) will it work?
4) If we run this job with above DSN in source with DataStage admin id will it work?
5) Is there some other way to fetch the data from above database without getting access to DataStage admin id?
connecting to database by NT Id
Moderators: chulett, rschirm, roy
Re: connceting to database by NT Id
So... 'SOL server' should really have said 'SQL Server'? As in that is the 'database' you keep mentioning?Zafar wrote:There is a database on SOL server
Ironical typo, btw.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 457
- Joined: Tue Sep 25, 2007 4:05 pm
Re: connceting to database by NT Id
Well, did it work for you?Zafar wrote: 3) IF we run this job with above DSN in source with windows NT id (used to log in to data stage) will it work?
4) IF we run this job with above DSN in source with data stage admin id will it work?
5) Is there some other way to fetch the data from above database without getting access to data stage admin id?
I ran into this issue and I couldn't make it run. I was on the clock at that moment...so I requested the DBA to give a generic account to log-in and get the work done. So, I am curious if you have got a work-around it!
Vivek Gadwal
Experience is what you get when you didn't get what you wanted
Experience is what you get when you didn't get what you wanted
connceting to database by NT Id
I am also doing the same thing...I asked for the permission on SQL server admin id .