Solved

JobOwner doesn't have permissions to use proxy

Posted on 2010-09-17
2
3,354 Views
Last Modified: 2012-05-10
I get the error, when i assign a SQL login to run the job.
"
Unable to start execution of step 1 (reason: JobOwner Run_Nightly_Job doesn't have permissions to use proxy 1 for subsystem SSIS).  The step failed.
"

why should this login be dependent on a proxy account?

thanks
0
Comment
Question by:anushahanna
2 Comments
 
LVL 29

Accepted Solution

by:
QPR earned 500 total points
ID: 33705822
0
 
LVL 6

Author Comment

by:anushahanna
ID: 33747211
gave a solution to pursue. Thanks QPR.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question