Setting the SQL Agent proxy account

When trying to reset the proxy account for the SQL Server Agent we get
following error:
Unable to set the SQL Agent Proxy account because of the reason listed
below:
'The system cannot find the file specified'
When executing following stored procedure
"EXEC master.dbo.xp_sqlagent_proxy_account N'SET',
N'BELGACOM',
N'SQLJOBS',
N'xxxxxx'"
or
"EXEC master.dbo.xp_sqlagent_proxy_account N'GET'"
, we get "access is denied" error.
All actions are performed with a sysadmin user (on server & sql level).
The SQLJOBS user is also admin of the server.
We're running SQL Server 2000 SP4 on Windows 2003

Oli

.

Relevant Pages

  • Re: Rebooted server twice and Companyweb does not work
    ... It's the SQL Server Agent service for the SBSMONITORING instance, which is independent of the Sharepoint instance. ... I'm not sure that this service would be running normally or not (it's set to Automatic on my server, ... Check the database connection information and make sure that the database ...
    (microsoft.public.windows.server.sbs)
  • RE: Error trying to execute a sp on a remote server with an SQL agent
    ... SQL Server Agent Job Fails When the Job Uses a Linked ... Microsoft SQL Server Support ... Error trying to execute a sp on a remote server with an SQL ...
    (microsoft.public.sqlserver.connect)
  • Re: DTSX help needed
    ... I have had to move a dtsx from a SQL 2005 server to a SQL 2008 server. ... BIDS upgraded the package and it runs fine from BIDS. ... SQL server agent uses. ...
    (microsoft.public.sqlserver.server)
  • 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)
  • CmdExec and Environment
    ... Unfortunately several of my sql users need tot run cmdexe jobs ... configured a proxy account with not to much rights on the files system. ... For each virtual server I created a separate temp dir for the proxy user. ...
    (microsoft.public.sqlserver.clustering)