Granting SSIS Permissions to a Domain Account

Run a stored procedure to grant SSIS permissions to a specified domain account.

You have connected to an RDS for SQL Server instance.

Run the following command to authorize a domain account:

EXEC master.dbo.rds_grant_ssis_to_login [login];

login: indicates the name of the domain account to be authorized.

Run the following command to authorize the domain account JHA\DCADMIN:

EXEC master.dbo.rds_grant_ssis_to_login [JHA\DCADMIN];