If you get the “Access is denied” error while connecting to remote SSIS server, you may have to perform the steps outlined in the following link
http://msdn.microsoft.com/en-us/library/aa337083.aspx
Additional steps to perform which are not in the MSDN page
- Add the user to the Distributed COM Users group on the server
- Restart the SSIS service after making changes
- At the minimum, add the user to the MSDB db_dtsltduser role to edit their own packages. Check this link for more permissions on the msdb database
No comments:
Post a Comment