Solved

proxy account

Posted on 2010-09-16
3
662 Views
Last Modified: 2012-05-10
When a DB owner run a SQL job, the result is
"Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account.  The step failed."

what needs to be done to qualify this user to be able to run the job?

thanks
0
Comment
Question by:anushahanna
3 Comments
 
LVL 9

Accepted Solution

by:
valkyrie_nc earned 250 total points
Comment Utility
You have a few options, depending on your corporate security structure and rules:

1.  Add the user to the sysadmin group.
2.  Create a group that has execute permissions and assign the user to that group.
3.  Set up the job steps to execute as a user who does have sysadmin privileges, or change the owner of the job to such a user.
4.  Create a proxy and give the proxy ownership of the job.  http://msdn.microsoft.com/en-us/library/ms189064.aspx

hth

valkyrie_nc
0
 
LVL 23

Assisted Solution

by:Racim BOUDJAKDJI
Racim BOUDJAKDJI earned 250 total points
Comment Utility
You must determine the account that runs the DTS package and create a proxy cmdshell account for that account.  Make also sure that the account has the right credential to access any folder accessed by the DTS package.

Hope this helps...
0
 
LVL 6

Author Comment

by:anushahanna
Comment Utility
Thanks very much.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

744 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now