none
Proxy account unable to execute stored procedue

    Question

  • Hey Guys,

    I am coming across a very strange situation, so i need your expert advise

    I have SSIS package which runs through a Proxy account and it executes successfuly if i am running it in Production and Development.

    However if i run the package in UAT it is getting failed. Apparently UAT is getting refreshed based on production backup.

    In the stored procedure and i am logging the initiation and completion event in a event table. I don't see any log in the event table

    and so i conclude, it is not able to execute the stored proc. Whereas in the Dev i can see log and more interestingly it is logging as 'dbo' whereas package is configured to run through Proxy account.

    I have checked/compared roles and everything in database and nothing found

    Can anyone please tell me what could have gone wrong and is proxy account specific to particular database?

    Wednesday, November 27, 2013 5:55 PM

Answers

All replies