Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 doesn't have permissions to use proxy 1 for subsys

Author  Topic 

ammie
Starting Member

1 Post

Posted - 2007-01-08 : 16:06:40

I'm looking for a real solution to this problem. Has anyone had this issue before and resolved it? I've been trying to schedule my package to run as a SQL Server Agent Job on a remote SQL server.

I've created credentials with a domain identity that has sysadmin role.

I've also created a proxy account, with Job owner and assigned to the same sysadmin role.

When I run the job it fails with ( .. doesn't have permissions to use proxy 1 for subsystem SSIS)

HELP Please....

Ammie

   

- Advertisement -