Thanks for the post.

I can see NO 'deny' set anywhere within the config of the system. We only have 3 DBAs here and nobody has amended the security within SQL....

Open 'SQL Help Books Online' and go to URL

"ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/0f5fc7be-e37e-4ecd-ba99-697c8ae3436f.htm"

This will provide a comprehensive step by step guide to deploy SSIS packages.

You basically have two options you can either...

Thanks Tim.

Its a production box so will need to schedule this for out of hours.

However i can confirm that the account thet the SQL Agent service is running under...

ALZDBA

I have just tried logging onto the domain using the 'credential' service account and it let me in fine so i know that the user credentials are correct.

I think...

Thanks Journeyman,

Yes the Proxy has permissions (has the check box selected) to both 'SQL Server Integration Services Package' & 'Operating System CMDExec'.

The proxy account principals are set to SQLAgentUser,...

Thanks for your response.

My issue is the:

"Message

[298] SQLServer Error: 14516, Proxy (3) is not allowed for subsystem "SSIS" and user "domain\uid". Grant permission by calling sp_grant_proxy_to_subsystem or sp_grant_login_to_proxy. [SQLSTATE 42000]

I...

I have also got this same issue.

Does anybody have any idea of a resolution?

Thanks

Steve