does anyone know how to grant developer access to integration
services?
i assigned a developer's account to msdb (dtsadmin, dtsuser,
dtsoperator, and targetserveruser ) roles but still he can't connect
to integration servics thru ssms (said access is denied).
i don't think granting sysadmin role is the only way.
thank you
"=== Steve L ===" <steve.@powells.com> wrote in message
news:1173913355.316834.291900@p15g2000hsd.googlegroups.com...
> does anyone know how to grant developer access to integration
> services?
> i assigned a developer's account to msdb (dtsadmin, dtsuser,
> dtsoperator, and targetserveruser ) roles but still he can't connect
> to integration servics thru ssms (said access is denied).
> i don't think granting sysadmin role is the only way.
Connecting to a Remote Integration Services Server
http://msdn2.microsoft.com/en-us/library/aa337083.aspx So try hard to avoid needing to do that. There's very little reason a
developer, or anyone else, would need to connect to the SSIS service. You
can grant the developer the ability to deploy packages into the server's
file system or database, create SQL Server Agent Jobs, and run those jobs,
all without touching the SSIS Service.
David
Add to del.icio.us |
Digg this |
Stumble it |
Powered by Megasolutions Inc
