|
Home > Archive > MS SQL Server DTS > March 2006 > How does one configure and manage a remote SSIS Service?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How does one configure and manage a remote SSIS Service?
|
|
| vnapoli 2006-03-14, 8:24 pm |
| 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? Pro...er&LinkId=20476
------------------------------
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
------------------------------
| |
| Allan Mitchell 2006-03-15, 7:30 am |
| Hello vnapoli,
Have you had a look at this?
http://www.sqljunkies.com/WebLog/kn...1/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? Pro...erver&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
> ------------------------------
| |
| vnapoli 2006-03-15, 9:24 am |
| 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/kn...1/05/17769.aspx
>
>
> Allan Mitchell
> www.SQLDTS.com
> www.SQLIS.com
> www.Konesans.com
>
>
>
>
| |
| vnapoli 2006-03-21, 1:31 pm |
| I tried the setup described in the article
http://www.sqljunkies.com/WebLog/kn...1/05/17769.aspx
also on a Windows 2003 server, sp1 (SQL 2005 standard edition) with no luck
also. Any thoughts? Suggestions?
"vnapoli" wrote:
[color=darkred]
> 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:
>
| |
| vnapoli 2006-03-22, 8:33 pm |
| Correction. We got the remote access to a SSIS Service (on a Windows 2003
server, sp1) working. We had inadvertently left out the step to add the
windows account or group to the Distributed COM Users group on the local
machine. With that step and the rest of the instructions in the article,
http://www.sqljunkies.com/WebLog/kn.../05/17769.aspx,
we got it to work. No luck whatsoever with the setup on the Windows XP
machine as there was no Distributed COM Users group on the local machine.
"vnapoli" wrote:
[color=darkred]
> I tried the setup described in the article
> http://www.sqljunkies.com/WebLog/kn...1/05/17769.aspx
> also on a Windows 2003 server, sp1 (SQL 2005 standard edition) with no luck
> also. Any thoughts? Suggestions?
>
>
>
>
> "vnapoli" wrote:
>
|
|
|
|
|