Post reply

SSIS Security Help needed

  • January 25, 2008 at 8:49 am

    #178564

    I am struggling to lock down security for the sql2005 production system. For ssis users I have set up the group of developers to have in msdb db_dtsadmin, db_dtsltduser, db_dtsoperator and SQLAgentUserRole. Prior to this I had one user setup before I was able to figure the right security set up as sysadmin and he created a couple of packages that ran fine. Now that I dropped his account and he is using the group account (same login as originally just now a member of the group) his packages fail. I changed one of the packages in Integration Services under MSDB to package roll SQLAgentUserRole for both reader and writer, and it still fails...

    What am I missing here? Need help!!!

  • January 25, 2008 at 5:04 pm

    #772074

    Maybe start with the obvious. How are the packages failing? What's the erorr he'd getting?

    I'd start there, and move on to a profiler trace of security activity when the package kicks off to see if perms are failing somewhere.

    He can also run it in debug mode from BIDS under the same acct. Then you'll be able to actually see which steps are failing and knock them out one by one.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply