proxy definition problem

Last Post 25 Oct 2007 05:08 AM by reginab. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
cronid
New Member
New Member

--
08 Aug 2007 10:13 AM
I can successfully execute my package via Business Studio but when I schedule it in SQL Agent I get the error message, 'could not get proxy data for proxy id = 2.' I am trying to execute the scheduled job with that proxy (call it abcd_proxy) because I have a logon id (call it abcd) with access to a specific network drive folder, which holds a required source flat file. The abcd logon is defined as a sysadmin account. I am unable to see that the abcd logon id is an added principal within the abcd_proxy, which I think is because the abcd logon principal has a sysadmin role. My proxy id = 2 definition looks to be defined the same way that my first proxy id was.

Does anyone have an idea about what the message means and how I can fix it?
reginab
New Member
New Member

--
25 Oct 2007 05:08 AM
You may have missed a step, did you create a Credential. If not, create one under system security. Next have the proxy use those credentails and run the job under the proxy name. This can all be done through the GUI under Management Studio.


Acceptable Use Policy
---