Post reply

SSIS cross-domain riddle

  • September 8, 2010 at 4:24 pm

    #148687

    Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) on a virtual machine running Windows NT 6.0 <x64> sp2

    I've installed a named instance of SQL Server 2008, including the SSIS components, on a virtual machine in DomainA.

    I can access the SSIS installation with the local installation of SSMS when using terminal services\RDP to connect to the machine, logging on to the machine with my DomainA\username credentials.

    I can access the SSIS installation from any other SQL Server Management Studio within DomainA.

    What's killing me is that I can't access the SSIS installation via SSMS from any domain other than DomainA. I can, however, access the SQL Server database engine from anywhere.

    The error message(s) in the pop-up window when I attempt to access the SSIS installation from any domain other than DomainA:

    Cannot connect to MachineName.

    Additional information:

    Failed to retrieve data fro this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

    Connect to SSIS Service on macine "MachineName" falied:

    Access is denied.

    I've tried running the 'SQL Server Integration Services 10.0' service with a DomainA account and then as a local system account.

    Please help me connect to the SSIS installation in DomainA from DomainB.

    Thank you in advance for your help.

    Seth

  • September 8, 2010 at 6:08 pm

    #1218310

    Ensure you've followed the steps outlined here....

    and then you may still have to muck with the dcom as noted here...

    Steve.

  • September 8, 2010 at 7:08 pm

    #1218318

    Thank you, Steve!

    I, too, had seen the first link. The second link you sent did the trick.

    Seth

  • January 25, 2019 at 8:46 am

    #2020121

    Second link is no longer available.

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • January 25, 2019 at 9:11 am

    #2020129

    Carolyn Richardson - Friday, January 25, 2019 8:46 AM

    Second link is no longer available.

    This is a 9 year old thread. Do you have the same problem then?

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply