Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
SQL Server Agent Proxy Account logon Failed
213 views
Skip to first unread message
AL
Jun 2, 2004, 2:01:04 PM6/2/04
to
I had a job running under non-system admin proxy account. This account has 'sa' right and also a domain user account.
This job has been running so many months without any problem until now. There is no change on the server recently. I have to re-type the password and re-run the job, it will work. I don't want to re-do this everytime when the job failed. Can someone tell me how to fix this problem: The following is the error message I got:
This job has been running so many months without any problem until now. There is no change on the server recently. I have to re-type the password and re-run the job, it will work. I don't want to re-do this everytime when the job failed. Can someone tell me how to fix this problem: The following is the error message I got:
========================================================
A problem occurred while attempting to logon as the Windows user 'SQLAgentCmdExec': Logon failure: the user has not been granted the requested logon type at this computer. The step failed.
======================================================
Thanks,
AL
![Rand Boyd [MSFT]'s profile photo](https://lh3.googleusercontent.com/a/default-user=s40-c)
Rand Boyd [MSFT]
Jun 3, 2004, 11:10:48 AM6/3/04
to
Check and see if the Proxy account ahs the following right enabled:
Access this computer from the network
Rand
This posting is provided "as is" with no warranties and confers no rights.
Kevin McDonnell [MSFT]
Jun 4, 2004, 1:58:01 PM6/4/04
to
When this account fails, are you able to logon to the local computer and
authenticate via Trusted Connection?
Is this a local machine account or domain account?
authenticate via Trusted Connection?
Is this a local machine account or domain account?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Kevin McDonnell [MSFT]
Jun 11, 2004, 1:58:27 PM6/11/04
to
I've not heard of this problem before. If this same account was used to
start another server service, would it then also fail? In other words, is
the problem specific to the account, or can it only be reproduced with the
SQL Proxy code?
start another server service, would it then also fail? In other words, is
the problem specific to the account, or can it only be reproduced with the
SQL Proxy code?
If you can reproduce this problem in a lab environment, I would suggest
opening up a case with a SQL engineer and getting a BUG filed. BUG cases
are never charged to your account.
Tokunbo Oseni
Jan 27, 2017, 9:48:35 AM1/27/17
to
I am getting the below type of error message for all jobs that uses proxy account. These jobs runs fine before with proxy account.
Executed as user : Domain\Account.
The process could not be created for step Step Number of job Unique Job ID (reason: A required privilege is not held by the client). The step failed.
I have tried the below resolution with no luck
https://support.microsoft.com/en-gb/help/911305/sql-server-agent-jobs-may-fail-after-you-change-the-sql-server-agent-service-startup-account-by-using-the-windows-service-control-manager
Michael
Feb 7, 2017, 7:50:56 AM2/7/17
to
https://blog.oraylis.de/2013/09/fixing-sql-2012-ssis-deployment-error-6522-a-required-privilege-is-not-held-by-the-client/
0 new messages