What permissions needed to connect to SQL Server Integration Services

Posted by rwmnau on Stack Overflow See other posts from Stack Overflow or by rwmnau
Published on 2009-07-09T17:10:15Z Indexed on 2010/03/23 22:03 UTC
Read the original article Hit count: 315

Filed under:
|
|

I need to allow a consultant to connect to SSIS on a SQL Server 2008 box without making him a local administrator. If I add him to the local administrators group, he can connect to SSIS just fine, but it seems that I can't grant him enough permissions through SQL Server to give him these rights without being a local admin.

I've added him to every role on the server, every database role in MSDB shy of DBO, and he's still not able to connect. I don't see any SSIS-related Windows groups on the server - Is membership in the Local Administrators group really required to connect to the SSIS instance on a SQL Server? It seems like there is somewhere I should be able to grant "SSIS Admin" rights to a user (even if it's a Windows account and not a SQL account), but I can't find that place.

UPDATE: I've found an MSDN article (See the section titled "Eliminating the 'Access if Denied' Error") that describes how to resolve problem, but even after following the stepsI'm still not able to connect. Just wanted to add it to the discussion

© Stack Overflow or respective owner

Related posts about sql-server-2008

Related posts about ssis