JOB STEP PROXY ACCOUNT not available

  • Hi,

    I want to set a proxy account for SQL Agent, that is available under SQL Agent Properties > Job System. But the problem is that the option for setting the proxy account is not available. It is there but i cannot set any value, because every option under Job Step Proxy Account is grayed out.

    Please help me finding the reason why this option isn't availble. There must be some SQL Server configuration that is causing this but I am unable to find it.

    Urgent help required.

    Thanks & Regards,

    Rehan

    - Rattu

  • If the SQL Server you are managing is SQL Server 2005, this will be grayed out, for it's the interface to support SQL Server 2000 SQL Server Agents, which only support a single proxy account. SQL Server 2005 supports multiple proxies. You can configure SQL Server 2005 proxies under SQL Server Agent > Proxies. You'll need to have created at least one Credential first, however.

     

     

    K. Brian Kelley
    @kbriankelley

Viewing 2 posts - 1 through 1 (of 1 total)

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