User Permission needed to Access and Deploy SSIS packages to SQL Server from Visual Studio

RNA-5508 1 Reputation point
2021-10-11T22:08:38.427+00:00

Hi,

In an Active Directory domain environment where both SQL Server and Visual Studio machines are both members of the same domain what user account permission do we usually need to be able to access SQL server from VS and be able to deploy SSIS packages to Integrated Services Catalogue?

Is it enough to create a domain user account and simply add it to the "local administrators group" on the SQL server and then use that account to login to VS machine to accomplish that task?

Or is there any other better scenario?

Regards

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,454 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Martinez, Gabriel 6 Reputation points
    2022-11-16T18:38:47.847+00:00

    try assign ssis_admin Role in the SSISDB database, with this role is good and enough to do what you are requesting.

    1 person found this answer helpful.
  2. ZoeHui-MSFT 33,051 Reputation points
    2021-10-12T03:18:27.847+00:00

    Hi @RNA-5508 ,

    Permissions to assign are going to be based on what deployment model you are going to use within your environment.

    Please refer: deploy-integration-services-ssis-projects-and-packages

    Connect to your instance in SSMS. Expand security / logins. Rt-click add new login, put in the domain account info. Grant it sysadmin if you want it to have total permission over the SQL instance.

    And then, it is enough to create a domain user account and simply add it to the "local administrators group" on the SQL server and then use that account to login to VS machine and deploy SSIS project.

    Regards，

    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October