Agent Proxy accounts not listed

Hi,

I just created a new proxy account. Creating credentials wasn't any problem (my NT user), creating the proxy (for all subsystems) also. But when I look at the subsystems in the SQL Management Studio I don't see the new proxy! I refreshed it, restarted it, no chance. I also tried to recreate the proxy but I can't since it tells me that it's already present. So where is it?

I need a proxy because my SQL Agent is running as local system but I need some credentials from a user to run a SSIS package. When I create a SSIS job step I only see "SQL Server Agent account" under "run as". I expected to see the proxy account there, too!

What can I do?

Thanks,

I tried with the same scenario you mentioned. Running SQLAgent account under LocalSystem and creating proxies and i could view then under Proxies node and could successfully see in Job step "Run As" combo box

I am assuming that grant the proxy to the subsystems was missed . Please check under should under unassigned proxies. If not granted to the subsystems Job step "Run As" combo box will list SQLAgent service account.

If you see proxy under unassigned Proxies node, open it and check the subsystems you want to use. Now things should work fine in job step dialog

Thanks,

Gops Dwarak

|||

Gops,

thanks for the repy... I see funny things going on... I can create the proxy, click on the subsystems I want to apply, it's created without any error. When I look into the subsystems I don't see the proxy. I see it under "unassigned". When I select the subsystems there and try to apply them, I get an error that this proxy is already assigned and I should check my permissions. I can delete it and try again, but that doesn't help...

Any idea?