January 17, 2008 at 1:04 pm
We are having problems with a Linked Server connection to DB2 (z/OS)using the IBMDADB2 OLE Provider. Authentication on the DB2 Server is being accomplished by specifying the remote login and password.
Using the OpenQuery syntax we are successful in connecting and retrieving data from the Linked Server when using a SQL Server Agent job or running the query logged in as the Windows Admin account. However, the same query fails with a DB2 security error (SQL1092N) when running under a non-admin (end user) account.
Any thoughts or suggestions would be appreciated!
Thanks,
Chris.
January 29, 2008 at 7:47 am
I have a similar problem like you Chris, but in my case I tried to use with Oracle (9i) through linked server from SQL Server 2000 SP3, I put a stored procedure inside a job (exec mysproc) with only 1 step.
I tried many times, and finally I have succeded executing the job, but only putting a windows account (win login) running with the Sql Server Agent, and the owner of the job with the same windows account (win login). Although I need a system account (sql login) to run with the agent service and the owner of the job with the system account too, but when I execute, the job fails, and the following error appears Executed as user: NT AUTHORITY\SYSTEM. Access to the remote server is denied because no login-mapping exists. [SQLSTATE 42000] (Error 7416). The step failed. I don't know why this happens
Please, help me. Thank you in advance
February 12, 2008 at 4:51 am
Until now I still having problem with security context, only with windows login I can't use the linked server with jobs, any ideas?
February 12, 2008 at 4:52 am
sorry, only with sql login I can't use linked server with jobs 😀
February 12, 2008 at 9:53 am
Just an update on my previous post...the resolution was to add the local domain user into a DB2Users local admin group. After logging out and back in the users were able to access data through the linked server with no further problems.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply