Re: Is this the correct group to post problems about proxy accounts?

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 07/28/05

  • Next message: Sue Hoegemeier: "Re: Can run sp as Administrator but not as User/dbo"
    Date: Wed, 27 Jul 2005 18:41:51 -0600
    
    

    Try resetting the proxy account using the user and password
    you can log in with - the easiest way to reset is to select
    the properties of SQL Server Agent, on the Job Control tab,
    click on Reset Proxy Account.

    -Sue

    On Wed, 27 Jul 2005 15:17:40 +0100, "Waldy"
    <waldy@notmail.com> wrote:

    >I have already posted this but have not received an answer.
    >
    >Hi there,
    > I have set the proxy user details using
    >xp_sqlagent_proxy_account 'set' and the command completes successfully, so
    >the logon details are correct. I have also logged onto the server using
    >those details just to make sure and that works OK. However, when I fire a
    >trigger that is making a call to xp_cmd_shell, I get the message "Logon
    >failure: unknown user name or bad password" Anyone know what the issue is
    >here?
    >
    >This is SQL Server 2000 SP3 on Windows 2000 SP4.
    >


  • Next message: Sue Hoegemeier: "Re: Can run sp as Administrator but not as User/dbo"

    Relevant Pages

    • 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: 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)
    • Set Sql Agent Proxy Account to Local Account
      ... Hi- I'm trying to set the Proxy Account for Sql Server agent to a local ... windows account. ... EXECUTE xp_sqlagent_proxy_account N'SET' ...
      (microsoft.public.sqlserver.security)