"vnapoli" wrote:

> I tried the setup described in the article
> http://www.sqljunkies.com/WebLog/knight_reign/archive/2006/01/05/17769.aspx
> also on a Windows 2003 server, sp1 (SQL 2005 standard edition) with no luck
> also. Any thoughts? Suggestions?
>
>
>
>
> "vnapoli" wrote:
>
> > Yes. That was one of the first things I tried. Windows XP SP2 did not have
> > a Distributed COM Users group on the local machine to be able to add the
> > windows account to. Windows 2003 does have the group. In the DCOM Config
> > section of Component Services for the MsDTSServer component, I even did
> > something that I normally do not do and that was to add the windows account
> > all permissions across the board. Launch and Activate Permissions, Access
> > Permissions, and Configuration Permissions with full authority. Even
> > Restarted the machine, not just the SSIS Service.
> >
> >
> >
> > "Allan Mitchell" wrote:
> >
> > > Hello vnapoli,
> > >
> > > Have you had a look at this?
> > >
> > > http://www.sqljunkies.com/WebLog/knight_reign/archive/2006/01/05/17769.aspx
> > >
> > >
> > > Allan Mitchell
> > > www.SQLDTS.com
> > > www.SQLIS.com
> > > www.Konesans.com
> > >
> > > > How does one configure and manage a remote SSIS Service?
> > > >
> > > > When attempting to administer a remote SSIS Service in SQL Server
> > > > Management Studio, I get an Access is Denied error (message listed
> > > > below) when trying to connect to the service. How does one set up
> > > > access to a remote SSIS Service?
> > > >
> > > > Environment Information
> > > > - Windows account is not part of the a Local Administrator's group on
> > > > the
> > > > remote machine (and do to corp policy, cannot be added)
> > > > - Machine has an Operating System that is Windows XP, sp 2 (eventually
> > > > production machine will be a Windows 2003 server)
> > > > - SQL Server 2005 Standard Edition
> > > > - Same domain and OU
> > > > Error Message:
> > > >
> > > > TITLE: Microsoft SQL Server Management Studio
> > > > ------------------------------
> > > > Failed to retrieve data for this request.
> > > > (Microsoft.SqlServer.SmoEnum)
> > > >
> > > > For help, click:
> > > > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20
> > > > 476
> > > >
> > > > ------------------------------
> > > > ADDITIONAL INFORMATION:
> > > > Connect to SSIS Service on machine "GCMSQLU0" failed:
> > > > Access is denied.
> > > > .
> > > > ------------------------------
> > > > Connect to SSIS Service on machine "GCMSQLU0" failed:
> > > > Access is denied.
> > > > .
> > > > ------------------------------
> > > > BUTTONS:
> > > > OK
> > > > ------------------------------
> > >
> > >