O'Reilly logo

What's New in SQL Server 2012 by Jon Reade, Rachel Clements

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Introducing the ssis_admin role

If you have followed the instructions for creating your SSISDB catalog, you will now be able to add users to a new role for performing administration tasks on the Integration Services server. The new ssis_admin role is a little like the sysadmin role, but just for the SSISDB catalog database.

To add a user to this role, open Management Studio and expand the Security node in the Object Explorer pane. Expand the Logins node and right-click on the account you want to alter. When the menu pops up, click on Properties:

Introducing the ssis_admin role

You will first need to ensure that the user is mapped to the SSIS database, so click on the User Mappings ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required