April 9, 2003 at 2:32 pm
Problem:
I set up a proxy acct for my user to schedule DTS jobs. One job he runs queries data on a different server. That job runs under the SQL Server Service Account instead of the proxy acct.
Why?
Details:
My user schedules a DTS job that runs a stored procedure. That procedure runs a view that is located on another database on the same server. The view queries
data on a different server (don't ask why). All servers run WINNT 4 sp6a and SQl Server 2000 sp2 and are in the same domain. The proxy acct has read rights on the appropriate database on the 2nd server and sys admin rights on the server the DTS job is scheduled from. When the user schedules jobs that run on a single server, the Proxy acct functions correctly. The proxy acct is not configured to run batch jobs on the 2nd server and I do not want to give it those rights for security reasons.
IS there a Batch DTS genius out there?
"I hope you enjoy your retirement as much as I will."
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
April 10, 2003 at 2:57 am
I'm assuming that he is using a linked server to query the other server? How is the linked server set up? Is it configured to map all users to a specific log in?
Check that out first.
April 11, 2003 at 2:57 pm
That was the problem. The proxy acct was not linked to the 2nd server. I do map my users to a single account. Once I set that up, all was good.
"I hope you enjoy your retirement as much as I will."
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply