Cluster upgrade to SQL Server 2008 fails when SQL Server 2005 cluster nodes have different installed features

• Perry Whittle

  SSC Guru

  Points: 234064

  More actions

  June 22, 2010 at 1:09 pm

  #1183562

  i dont know never tried and never ran into the issue. From the KB i think probably not the instance ID may not be the same hence why it tells you too remove. Its certainly worth a try i suppose to install SSIS and see. Check the registry first to see which IDs are in use already on both nodes.

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

  "Ya can't make an omelette without breaking just a few eggs" 😉

• passivebyz

  SSCommitted

  Points: 1908

  More actions

  June 22, 2010 at 4:04 pm

  #1183636

  We have some DTS packages running SQL Server 2005 and SSIS had installed on NOde1 but on node2. In theory, we need to install SSIS on node2 too. Because if the instance fail over to secondary, it's should run the DTS packages. So I, believe, installing SSIS on node2 will be the good idea!

  Thanks