Monday, March 12, 2012

non-admin user and SSIS (integration services)

I wish to grant access to SSIS (e.g., register server in mssms) for a
user _without_ making that user an administrator of the host.
How can this be done--if at all?horseradish,
A login that can use SSIS needs no special server rights. In terms of
server roles, my developers are in 'public'. There are decisions that you
need to make, of course, and these are outlined here:
http://technet.microsoft.com/en-us/...y/ms137833.aspx
FWIW, I (despite the pitch for how good it is to store packages in msdb)
keep my stored on the file system. For one thing, on the file system more
than one team member can edit the package.
RLF
"horseradish" <dontcallme@.illcallu.net> wrote in message
news:OgC5bzRMIHA.5240@.TK2MSFTNGP04.phx.gbl...
>I wish to grant access to SSIS (e.g., register server in mssms) for a user
>_without_ making that user an administrator of the host.
> How can this be done--if at all?|||You can follow this procedure to give access to SSIS to users who are not
local Administrators (look for the 'Access is Denied' section').
http://technet.microsoft.com/en-us/...y/aa337083.aspx
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"horseradish" wrote:

> I wish to grant access to SSIS (e.g., register server in mssms) for a
> user _without_ making that user an administrator of the host.
> How can this be done--if at all?
>|||Ben,

> You can follow this procedure to give access to SSIS to users who are not
> local Administrators (look for the 'Access is Denied' section').
> http://technet.microsoft.com/en-us/...y/aa337083.aspx
BINGO. This solved the issue. Thanks for the assist!

No comments:

Post a Comment