asked on

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

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 log in to VS machine to accomplish that task?

Or is there any other better scenario?

Regards

lcohan

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 log in to VS machine to accomplish that task?

No that would not be enough however having both VS and SQL on the same domain helps as you can create new AD user or use existing AD logins from that domain and add them to SQL Server Security and to the appropriate needed Role as they are listed here (mind you tis is for the last version of SQL so please select your own): https://docs.microsoft.com/en-us/sql/integration-services/security/integration-services-roles-ssis-service?view=sql-server-ver15 - this is for older versions: https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2005/ms141053(v=sql.90)?redirectedfrom=MSDN
You can also find more details about the two (old and new) deployment models from here: https://docs.microsoft.com/en-us/sql/integration-services/packages/deploy-integration-services-ssis-projects-and-packages?view=sql-server-ver15

This question needs an answer!

Become an EE member today

7 DAY FREE TRIAL

Members can start a 7-Day Free trial then enjoy unlimited access to the platform.

View membership options

Learn why we charge membership fees

We get it - no one likes a content blocker. Take one extra minute and find out why we block content.