Bonjour all,

I tried to put in place a proxy account to a job which runs in step 1 a DTS
which can't be execute by the owner of the DTS and the Job as she is not
member of sysadmin.

I put in place a proxy account as following but I still have the same
problem.

Create credential CredentialDeBA with identity='domainServer\user'
sp_add_proxy @proxy_name='proxyDeBA', @credential_name='CredentialDeBA'
sp_grant_proxy_to_subsystem @proxy_name='proxyDeBA', @subsystem_name='SSIS'
sp_grant_login_to_proxy @login_name='domainServer\user',
@proxy_name='proxyDeBA'
sp_update_jobstep @job_id=N'<job id>', @step_id=1 , @proxy_name=N'proxyDeBA'

Advice will be welcome !
Thank you
Sandrine

MS Sql Server LazyDBA home page