non-admin user and SSIS (integration services)

27 Nov 2007 5:42 PM

horseradish

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?

27 Nov 2007 7:01 PM

Russell Fields

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/library/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

Show quote

"horseradish" <dontcal***@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?

27 Nov 2007 7:39 PM

Ben Nevarez

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/library/aa337083.aspx

Hope this helps,

Ben Nevarez
Senior Database Administrator
AIG SunAmerica

Show quote

"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?
>

27 Nov 2007 9:32 PM

horseradish

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/library/aa337083.aspx

BINGO. This solved the issue. Thanks for the assist!