SSIS server connection

#1

Hi
If i need to connect to ssis server from sql management studio, what are the
minimum permission i should have to connect the ssis server. i dont want to
give admin access or sql admin access.
Thanks inadvance.

#2

Hello Hari,

There is a section in BOL that I believe may help you and it can be found
here

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/1088aafc-14c5-4e7d-9930-606a24c3049b.htm

Allan

Quote:

Hi
If i need to connect to ssis server from sql management studio, what
are the
minimum permission i should have to connect the ssis server. i dont
want to
give admin access or sql admin access.
Thanks inadvance.

#3

Thanks Allan.

But my question is how do i connect to a ssis server from sqlwb without
being a sysadmin. what role i should be part of for me to connect and manage
ssis server.

"Allan Mitchell" wrote:

Quote:

Hello Hari,

There is a section in BOL that I believe may help you and it can be found
here

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/1088aafc-14c5-4e7d-9930-606a24c3049b.htm

Allan

Hi
If i need to connect to ssis server from sql management studio, what
are the
minimum permission i should have to connect the ssis server. i dont
want to
give admin access or sql admin access.
Thanks inadvance.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SSIS server connection

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

SSIS server connection - 01-11-2006 , 07:00 AM

Re: SSIS server connection - 01-11-2006 , 01:15 PM

Re: SSIS server connection - 01-11-2006 , 08:35 PM