Post reply

Deleting a SQL 2000 Agent Proxy Account

  • August 12, 2009 at 6:26 am

    #95979

    Hi,

    I've used xp_sqlagent_proxy_account to create a proxy account in SQL 2000 but now want to delete this proxy account.

    I've ran EXEC master.dbo.xp_sqlagent_proxy_account N'DEL' (with and without the parameters for the proxy account) but when I then run EXEC master.dbo.xp_sqlagent_proxy_account N'GET' I still see the proxy account details.

    I've restarted SQL but this has had no effect. I have now ensured that only SysAdmins can execute CmdExec and Active Scripting job steps but prefer to delete the current proxy account as well if possible.

    any thoughts?

  • August 23, 2009 at 8:52 am

    #1043358

    Are you sure you are on SQL Server 2000 because as per my knowledge SQL Server Agent Proxy Accounts are new to SQL Server 2005.

    Just check.

    Regards,
    Sarabpreet Singh 😎
    Sarabpreet.com
    SQLChamp.com
    Twitter: @Sarab_SQLGeek

  • August 23, 2009 at 9:16 am

    #1043366

    There were more proxies in 2005, but they existed in 2000.

    http://msdn.microsoft.com/en-us/library/aa260700(SQL.80).aspx

    If it's not deleting, that leads me to believe there might be a bug here with the account. You can disable the account in AD, which would get you security. As far as cleaning things up, I'm not sure what to do here. Likely a system table or registry entry could be removed, but I'd be hestiant to recommend that.

    I might just add this as a note in the documetation you keep for others, including DR docs for sysadmins to keep this account disabled.

  • August 23, 2009 at 9:43 am

    #1043374

    I never knew that.

    Thanks Steve.

    Regards,
    Sarabpreet Singh 😎
    Sarabpreet.com
    SQLChamp.com
    Twitter: @Sarab_SQLGeek

  • August 25, 2009 at 5:46 am

    #1044083

    ok, thanks for your replies. Will look at sorting at AD level.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply