138 reputation
217
bio website stackoverflow.com
location Canada
age 24
visits member for 1 year, 8 months
seen 13 hours ago

1h
awarded  Notable Question
20h
comment Issues with module signing and SSIS catalog internal procedures
I've checked the owner (it's SA). I'm not sure I understand the revert message: the proc is in MSDB, and the user executing connects to the MSDB databases. I'm not explicitly calling REVERT anywhere. Is the problem with calling the procedures in the SSISDB databases from inside the proc?
1d
comment Issues with module signing and SSIS catalog internal procedures
Thanks for adding the new info. I've verified none of the things are the issue (Except for #1 I am trying to impersonate a service account - not sure if that still applies). I've added more detail to the question.
1d
revised Issues with module signing and SSIS catalog internal procedures
added 1306 characters in body; edited title
Oct
17
comment Issues with module signing and SSIS catalog internal procedures
I have signed the proc in MSDB as well.I receive the same error message when I call the procedure.
Oct
17
comment Issues with module signing and SSIS catalog internal procedures
@RLF No, my procedure lives in the msdb database. I'm calling the internal SSIS Catalog procedures to run the package.
Oct
17
asked Issues with module signing and SSIS catalog internal procedures
Oct
9
accepted Execute permission denied on object sp_start_job
Oct
7
comment Execute permission denied on object sp_start_job
@AaronBertrand Thanks, I may end up doing just that. As it is the database the procedure is in pretty much just has that procedure and nothing else, so it's pointless..
Oct
7
comment Execute permission denied on object sp_start_job
@AaronBertrand I don't particularly want to give the end user access to msdb. What other exposure am I giving by making the database trustworthy?
Oct
7
comment Execute permission denied on object sp_start_job
making the database trustworthy did the trick. Thanks a bunch!
Oct
7
asked Execute permission denied on object sp_start_job
Oct
1
awarded  Notable Question
Sep
15
accepted How can I restore ##MS_SSISServerCleanupJobLogin##?
Sep
4
awarded  Popular Question
Aug
14
awarded  Popular Question
Aug
10
awarded  Popular Question
Aug
7
awarded  Popular Question
Jul
30
answered How can I restore ##MS_SSISServerCleanupJobLogin##?
Jul
30
asked How can I restore ##MS_SSISServerCleanupJobLogin##?