SSIS Package Error “proxy is not allowed for subsystem”

You attempt to run or create an agent job with a proxy defined and get the error “proxy is not allowed for subsystem”.  Proxies are useful when you want to run an agent job as a lower privileged account.  If you encounter the error above try adapting the following script and execute to resolve :

USE msdb ;
GO

EXEC dbo.sp_grant_login_to_proxy
    @login_name = N'DOMAIN\ACCOUNT',
    @proxy_name = N'PROXYNAME' ;
GO

About AussieBICG

Connect with me here https://au.linkedin.com/in/aussiebicg

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s