April 27, 2010 at 3:05 pm
Hi,
We active/active/passive clustered SQL Server 2005 setup. Node1 has 2 instances & node2 has 2 instances & node3 is passive.
On node1 & node2, databases engine, Integration services and Management tools has been installed but we DID NOT install anything on node3. So in this case, having different features installed on cluster nodes, does the in-place upgrade fails according the issue mentioned in the link
http://support.microsoft.com/kb/955949
Thanks
April 27, 2010 at 3:22 pm
I too have the same question. We have 2 node active/passive cluster setup for SQL Server 2005 with SP3
On NODE1 (Active), we have Integration Services installed but not on NODE2 (passive). So before starting the in-palce upgrade, do we need to uninstall SSIS from NODE1?
Is that correct? please clarify me...Please see the attachments for installed features on NODE1 & NODE2.
many thanks
April 27, 2010 at 3:26 pm
as the link details the workaround is to un install the mismatched features
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 27, 2010 at 4:21 pm
Is this applicable to our case (having SSIS in Active node and NOT on Passive node)?
please advice??
April 28, 2010 at 5:51 am
gmamata7 (4/27/2010)
Is this applicable to our case (having SSIS in Active node and NOT on Passive node)?please advice??
according to the KB article, yes.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 28, 2010 at 9:47 am
I
s this applicable to our case (having SSIS in Active node and NOT on Passive node)?
please advice??
according to the KB article, yes
If that is the case, then installing the SSIS & SP3 on NODE2 (passive) before starting the In-place upgrade to SQL Server 2008 will resolve the issue right?
or I need t Uninstall SSIS from NODE1 (Active) & then upgrade to SQL Server 2008?
Thanks
April 28, 2010 at 10:30 am
personally i would uninstall ssis from node 1
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 28, 2010 at 10:37 am
personally i would uninstall ssis from node 1
If you uninstall SSIS from NODE1, then what happens to the Maaintenance palns that are running on NODE1. We are using maintenance plans for Integrity Check, History Cleanup & Index Rebuilding. So what happens to these jobs?
Will they work after uninstalling SSIS? We do not have any DTS or SSIS packages other than the above maintenance plans.
Thanks
April 28, 2010 at 10:42 am
Hi Perry,
as the link details the workaround is to un install the mismatched features
according to the KB article, yes
personally i would uninstall ssis from node 1
Did you actually upgrade an active/passive clustered sql server 2005 to 2008? where one of the nodes having SSIS & the other having NO SSIS? or you just telling according to the KB article?
Thanks
April 28, 2010 at 10:54 am
no going by the link, i always prefer a clean install and not an upgrade. Maintenance plans are stored in the msdb so wont be affected. Do you actually have any SSIS packages (and i dont mean maintenance plans).
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 28, 2010 at 11:04 am
no going by the link, i always prefer a clean install and not an upgrade. Maintenance plans are stored in the msdb so wont be affected. Do you actually have any SSIS packages (and i dont mean maintenance plans)
Our CLustered servers are only 2 years old. So I have only one option - In-place upgrade...In one cluster set up, we do not have any DTS or SSIS packages. But in other 2 node cluster, we do have couple of DTS packages
June 16, 2010 at 1:01 am
Any more inputs from those who experienced cluster instances in-place upgrade from sql 2005 to 2008?
Is Having same features on all clustered nodes mandatory to do in-place upgrade from sql 2005 to 2008?
thanks
June 21, 2010 at 5:01 pm
Is Having same features on all clustered nodes mandatory to do in-place upgrade from sql 2005 to 2008?
No where in BOL is mentioned that you have to have same features on all clustered nodes to do in-place upgrade from sql 2005 to 2008.
Where did you find that information..provide that link:-):-)
June 22, 2010 at 9:21 am
passivebyz (6/21/2010)
Is Having same features on all clustered nodes mandatory to do in-place upgrade from sql 2005 to 2008?
No where in BOL is mentioned that you have to have same features on all clustered nodes to do in-place upgrade from sql 2005 to 2008.
Where did you find that information..provide that link:-):-)
http://support.microsoft.com/kb/955949 !!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 22, 2010 at 12:47 pm
Thank you very much Perry,
I could have run into trouble if I miss this thread!
I read the KB Article in the link http://support.microsoft.com/kb/955949 and I have understand that it is a MANDATORY TO HAVE THE SAME SQL SERVER FEATURES INSTALLED ON ALL CLUSTER NODES. and the article says:
To work around this issue, remove the mismatched features of SQL Server 2005 that are installed in the cluster environment. Then, run the Setup program again to upgrade the clustered instance of SQL Server 2005 to SQL Server 2008.
Question:
Instead of removing the mismathed features, can we install the features that were missed on one node compared to other node? (Making sure sure all the nodes have same features)
For example, on node1, we have SSIS but not on node2. So in this case, instead of removing the SSIS from node1, can we install SSIS on node2 and then do the in-place upgrade to SQL Server 2008?
I appreciate your response.
Thank you
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply