Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.sqlserver.security > #7

Re: Proxy account

Show all headers | View raw

On Friday, September 12, 2003 at 7:43:28 PM UTC+1, Gert E.R. Drapers wrote:
> Most of the times this is caused due to insufficient priviliges of the SQL
> Server service account used.
> Go to SQL EM, Server Properties, Security tab, set the service account to
> LocalSystem, restart SQL Server.
> Repeat the same process to set it back to the account you want to use.
> 
> Try again to set the proxy account.
> 
> if that does not work, use the following alternative way to execute the XP
> 
> EXEC master.dbo.xp_sqlagent_proxy_account N'SET',
>              N'mydomain', -- agent_domain_name
>              N'ntaccount', -- agent_username
>              N'123password'
>              N'machine name', -- name of the machine or note your are
> running on
>              N'Administrator', -- local machine administrator account
>              N'123AdminPassword'
> 
> GertD@SQLDev.Net
> 
> Please reply only to the newsgroups.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> You assume all risk for your use.
> Copyright © SQLDev.Net 1991-2003 All rights reserved.
> 
> "ilovesql" <ilovesql@hotmail.com> wrote in message
> news:erL3MS8dDHA.1728@TK2MSFTNGP09.phx.gbl...
> > I want to setup proxy account so that developers can run xp_cmdshell as
> > follows
> >
> > EXEC master.dbo.xp_sqlagent_proxy_account N'SET',
> >              N'mydomain', -- agent_domain_name
> >              N'ntaccount', -- agent_username
> >              N'123password'
> >
> > I get a message saying
> > "Error executing extended stored procedure: Specified user can not login"
> >
> > If I use
> > EXEC master.dbo.xp_sqlagent_proxy_account 'GET'
> > I get nothing.
> >
> > I tried to do this from Enterprise MAnager also but same error.
> >
> >

Please assist 

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

Back to microsoft.public.sqlserver.security | Previous | Next | Find similar

Thread

Re: Proxy account Michael <michaeloseni@googlemail.com> - 2017-01-27 06:53 -0800

csiph-web