Solved

I just added a proxy to a Agent Job and got the following error.

Posted on 2010-11-12
23
745 Views
Last Modified: 2012-05-10
I just added a proxy to a Agent Job and got the following error.

 Grant permission by calling sp_grant_proxy_to_subsystem or sp_grant_login_to_proxy

Does anybody know fix?

thanks
0
Comment
Question by:Mr_Shaw
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 12
  • 10
23 Comments
 
LVL 6

Expert Comment

by:subhashpunia
ID: 34120290
In which group you created the proxy and what type of command youa re using in Agent job?
Do the credential (used for proxy) have the permission for the resource used by job?
0
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34120297
Have you granted the relevant subsystem permissions to the proxy user. Ie if you are runnning an SSIS package then you will have to grant the user access to the SSIS subsystem.
0
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34120318
The order in which you should set up a proxy is to add the user to Security > Credentials and then under "SQL Server Agent" > Proxies (Right Click) New Proxy and assign the subsystem permissions.
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

Author Comment

by:Mr_Shaw
ID: 34120357
Ok past that error now... the new error is

Unable to start execution of step 3 (reason: Could not get proxy data for proxy_id = 41).  The step failed.

This is tricky...
0
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34120383
Have you entered DOMAIN\USER in the credential?
0
 

Author Comment

by:Mr_Shaw
ID: 34120415
No I am using a sql account.
0
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34120426
And what subsystem are you accessing? T-SQL?
0
 

Author Comment

by:Mr_Shaw
ID: 34120434
i am not sure what subsystem I am using....

I am using SQL Server 2005.
0
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34120464
In the drop down in the job you have created you will see as per the screen shot. This is the subsystem. SUBSYSTEM
0
 

Author Comment

by:Mr_Shaw
ID: 34120491
Oh Operation System (CmdExec)
0
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34120511
Is your SQL Service running under "Local System" or is a user specified?
0
 

Author Comment

by:Mr_Shaw
ID: 34120518
I also tried it using SSIS
0
 

Author Comment

by:Mr_Shaw
ID: 34120533
>>Is your SQL Service running under "Local System" or is a user specified?

Everything is under local system.

0
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34120542
What command are you running?
0
 

Author Comment

by:Mr_Shaw
ID: 34120575
"C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTEXEC.EXE" /SQL "\BReports\Invoicing" /SERVER AD1/MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E

This command work fine if i run the Job under the SA account.

When I use the proxy it does not work.

I have included sysadmin and SQLAgentUserRole in the principals of the proxy.
0
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34120601
Sorry thinking about that is the SQL Server agent running under local system?
0
 

Author Comment

by:Mr_Shaw
ID: 34120627
Yes the agent is also running under local system.
0
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34120984
Interesting that it worked with SA... I take it you dont want to use a windows account?
0
 

Author Comment

by:Mr_Shaw
ID: 34128206
I don't know which windows account to use... unless I ask for a new one to be created.
0
 
LVL 16

Accepted Solution

by:
EvilPostIt earned 500 total points
ID: 34132011
Probably a good idea to get a Jew one created with the specific filesystem permissions that are needed.
0
 

Author Comment

by:Mr_Shaw
ID: 34135484
thank you so much for helping me through this issue.

A new domain account was created which I used in the proxy.

It all works now.
0
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34135493
No probs.
0
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 34135499
Just saw the "Jew one" bit in my reply. Sorry was supposed to be "New one". Damn iPhone autocorrect.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Need help with a query 3 39
SQL Server Express automatically execute SQL or SP 8 34
SQL Server Express or Standard? 5 29
A question about syntax 5 26
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
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 how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

733 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