Hi- I'm trying to set the Proxy Account for Sql Server agent to a local
windows account. The account is NOT in a domain; yet a domain is required to
set the proxy. I have tried machine name, workgroup name, ., \, etc. to no
avail. We have tried from Enterprise Manager / Agent properties, and via sql
using
when doing this we get an error (of course we sub in username, pw and
various guesses at what domain should be)
error is...
"Error executing extended stored procedure: Specified user can not login"
(of course cause we incorrect no domain...)
Any ideas? We are trying to do this so we can execute a master..xp_cmdshell
command and have it run under this Proxy Account. Otherwise we have to run
under sa and lose security.
Permission Denied for CreateObject ... When I execute a DTS package via the SQL Server Agent I get a Permission Denied for CreateObject after the job successfully creates an object. ... The service account the SQL Server Agent starts under and the Proxy Account are both System Administrators. ... (microsoft.public.sqlserver.dts)
Re: Execute Persmission denied on object sp_OACreate ... It is strange though -- in my dev server I did not have to make the owner be ... >> Does Sql Server Agent recognize that a user does not have SysAdmin ... >> priviliges and automatically invoke the proxy account to execute these ... >> proxy account to use in the Job Systems tab of SQL Server Agent ... (microsoft.public.sqlserver.security)
Re: Permission Denied for CreateObject ... > When I execute a DTS package via the SQL Server Agent I get a Permission Denied for CreateObject after the job successfully creates an object. ... > The service account the SQL Server Agent starts under and the Proxy Account are both System Administrators. ... (microsoft.public.sqlserver.dts)
RE: Unable to set the SQL Agent proxy account ... The Proxy Account should not be the same account used to ... Start SQL Server and SQL Agent. ...SQL Server Agent proxy accounts allow SQL Server users who do not belong to ...SQL Server Agent jobs.... (microsoft.public.sqlserver.security)
Re: Is this the correct group to post problems about proxy accounts? ... Try resetting the proxy account using the user and password ... the properties of SQL Server Agent, on the Job Control tab, ... click on Reset Proxy Account.... >the logon details are correct. ... (microsoft.public.sqlserver.security)
