SSIS – access/privileges to grant.

methods to grant access on SSIS

——————————-
https://www.mssqltips.com/sqlservertip/3086/how-to-resolve-ssis-access-denied-error-in-sql-server-management-studio/

https://sysbadmin.wordpress.com/2012/09/04/how-to-grant-access-permission-for-ssis/

http://mssqltrek.com/2011/12/07/connecting-to-the-integration-services-service-on-the-computer-mirrorstand-failed-with-the-following-error-access-is-denied/

https://msdn.microsoft.com/en-us/library/hh213130.aspx

below roles need to be granted to user depending on type of access

-db_ssisadmin
– db_ssisltduser
-db_ssisoperator

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s