2016 SSIS and Local Admin

  • So we just moved from 2008 to 2016, and it looks like only local admins can use SSIS now.. how do we get non local admins access run work flows to SQL Server? Getting must be local admin to bulk insert. The user is a sysadmin on the SQL Server.

  • dwilliscp - Friday, October 12, 2018 1:45 PM

    So we just moved from 2008 to 2016, and it looks like only local admins can use SSIS now.. how do we get non local admins access run work flows to SQL Server? Getting must be local admin to bulk insert. The user is a sysadmin on the SQL Server.

    SSIS isn't limited to only local admins. You may just be having issues with setting permissions for the tasks but there is no way to tell without more information.

    Sue

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

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