Error connecting to Integration Services

  • I am trying to use SSMS to connect to an Integration Services server. We have only one domain and every user and server are on that domain. When I start SSMS on my local machine and then try to connect to the Integration Services server (which is NOT on my local machine, but on the same domain), I get the following error:

    ADDITIONAL INFORMATION:

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

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

    ------------------------------

    A security package specific error occurred. (Exception from HRESULT: 0x80070721) (Microsoft.SqlServer.DTSRuntimeWrap)

    ------------------------------

    However, when I use Remote Desktop Connection (RDC) to run SSMS on the same box the Integration Services server is on, I do not get any errors, even if I use my same Windows login.

    Does anyone know what my problem could be?

  • Are you using the same version of the tools on the remote machine? I have seen this while trying to use SSMS from SQL 2008 to try and connect to a SQL 2005 SSIS server. If you had gotten access denied I might have said its a DCOM problem but you got a fail. The other thought I had was firewall issue.

    CEWII

  • On local machine:

    Microsoft SQL Server Management Studio10.0.1600.22 ((SQL_PreRelease).080709-1414 )

    Microsoft Analysis Services Client Tools2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )

    Microsoft Data Access Components (MDAC)2000.085.1132.00 (xpsp.080413-0852)

    Microsoft MSXML2.6 3.0 4.0 5.0 6.0

    Microsoft Internet Explorer8.0.6001.18702

    Microsoft .NET Framework2.0.50727.3623

    Operating System5.1.2600

    On remote machine:

    Microsoft SQL Server Management Studio10.50.2500.0

    Microsoft Analysis Services Client Tools10.50.2500.0

    Microsoft Data Access Components (MDAC)6.1.7601.17514

    Microsoft MSXML3.0 5.0 6.0

    Microsoft Internet Explorer8.0.7601.17514

    Microsoft .NET Framework2.0.50727.5446

    Operating System6.1.7601

    Do you think the version differences are the problem?

  • imani_technology (10/11/2011)


    On local machine:

    Microsoft SQL Server Management Studio10.0.1600.22 ((SQL_PreRelease).080709-1414 )

    On remote machine:

    Microsoft SQL Server Management Studio10.50.2500.0

    Microsoft Analysis Services Client Tools10.50.2500.0

    Do you think the version differences are the problem?

    Yes, based on the version on the remote machine it has SQL 2008R2 with SP1. On your local machine you are using the last Release Candidate for SQL 2008. SQL doesn't like to connect to newer versions from older versions. You need to upgrade your local machine.

    CEWII

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

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