?
Solved

run job as specific acount

Posted on 2011-03-07
7
Medium Priority
?
288 Views
Last Modified: 2012-05-11
experts,

i have a SQL job queries a database and exports a text file to a specific location. i need to run the jobs under a specific account, so that it has permissions to write to the directory where I'm trying to copy to. This seems like it should be simple, but I can't seem to find a way. on my jop steps, i have a "run as" option, but I can't figure out how to create an account with the needed credentials to populate this drop down.

thanks in advance.
0
Comment
Question by:Butterfield_Cayman
  • 4
  • 3
7 Comments
 
LVL 4

Accepted Solution

by:
Amgad_Consulting_Co earned 1000 total points
ID: 35058815
you can set that in the job step.

get job properties, step , advanced and the set "run as user" value.

check this link http://blogs.msdn.com/b/varun_sharma/archive/2007/08/30/how-to-run-sql-server-agent-and-sql-server-jobs-with-least-privilege-in-sql-server-2005.aspx
0
 

Author Comment

by:Butterfield_Cayman
ID: 35058868
i don't see a "run as user" value on the advanced tab. I see one on the general tab. looks like creating a proxy may be the way to do this?? not 100% sure though.
0
 
LVL 4

Assisted Solution

by:Amgad_Consulting_Co
Amgad_Consulting_Co earned 1000 total points
ID: 35058894
can you try the one on general tab.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Butterfield_Cayman
ID: 35058931
yep, got that one going - thanks. justr had to create the correct proxy account. thanks for help.
0
 
LVL 4

Expert Comment

by:Amgad_Consulting_Co
ID: 35058935
here is how it looks on my side.

 sample
0
 

Author Comment

by:Butterfield_Cayman
ID: 35058967
i'm using 2005 - is that 2008? interesting
0
 
LVL 4

Expert Comment

by:Amgad_Consulting_Co
ID: 35058985
yes it is SQL 2008
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

621 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