Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

who can connect to integration services in SSMS 2k5?


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