SSIS 2008 R2 in Cluster. Error


  • Hi guys

    I need some help from you.

    Sql 2008 R2 clusteer with 2 instances (VS are Virtual Names):



    The cluster works fine without issues.


    I have configured the SS Integration Services in the cluster belonging to the VS2/Instance group.

    I successfully connect to SSIS (from SQL Management Studio) by using the VS2 virtual name, but when I try to open the MSDB folder I get the error: Failed to retrieve... The SQL Server instance specified.... (A log error message).

    Could you help me?


    Tuesday, July 08, 2014 6:22 PM


All replies

  • Hi guys,

    I have solved the problem, but I need clarification (see later):

    1) To Add SSIS as cluster service I have followed the doc: but I got the problem as explained.

    2) Then, searching in the web I found this link that solved the issue:

    The doc says to modify the genuine xml file at the installation folder with references to the SQL VirtualServer\Instance.

    3) Applying the suggestion, now the issue looks solved.


    At this point I do not understand:

    The step to modify the registry key and add the xml file in a shared folder is still needed as described in MS article?


    • Marked as answer by Fasttrack2 Tuesday, July 08, 2014 6:27 PM
    • Edited by Fasttrack2 Tuesday, July 08, 2014 6:30 PM
    Tuesday, July 08, 2014 6:26 PM
  • I am still try to understand how SSIS works in cluster.

    I have found out that in My cluster instakllation the registry key about the xml file is not present.

    I tried to add the xml file directory as key in the registry as stated in the MS document but I have found out that it is automatically delete by the system.

    Any suggestion?


    Thursday, July 10, 2014 4:44 PM

    When un update runs,  it deletes the updated registry key

    Thursday, July 10, 2014 5:11 PM