SSIS msdb database rolls are not there

Hi,

I've just imported some SSIS packages onto my instance but my users aren't able to run the jobs for these packages (if thats the write terminology) it keeps failing with this error:

Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account.  The step failed.

I've been looking around and I've been told I can assign the logins to the database roles in msdb but when I look for the roles in msdb they don't exist. SSIS is definitely installed on the server. How do I go about getting these added? I have very little knowledge when it comes to SSIS. Please see screenshot below:

July 10th, 2015 10:00am

Which version are you using, I guess 2005? Those roles where introduce in 2008, in 2005 they have different names, see https://msdn.microsoft.com/en-us/library/ms141053(v=sql.90).aspx
Free Windows Admin Tool Kit Click here and download it now
July 10th, 2015 10:39am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics