July 3, 2010 at 10:41 am
Hi,
I want to uninstall clustered SQL Server 2005 instance from a 2 node a/p cluster.
Before uninstalling SQL instance from active node1, does the SQL Server resources should be moved to passive node2?
or
I can uninstall SQL instance from active node1, having the resources on the same node?
what is the best practice?
thanks
July 3, 2010 at 10:57 am
From the link http://msdn.microsoft.com/en-us/library/ms190438.aspx
Side-by-side installations of SQL Server 2008, SQL Server 2000, and/or SQL Server 7.0, where any of the versions is uninstalled.
Side-by-side installations of SQL Server 2000 with SQL Server 2008, where SQL Server 2000 is installed after SQL Server 2008.
This issue is due to removal of the registration for the SQL Server 2008 SQL-DMO COM library. To re-enable SQL Server 2000 Enterprise Manager and other programs with SQL-DMO dependencies, register SQL-DMO by running 'regsvr32.exe sqldmo.dll' from a command promp
t.
Is the above also applies to SQL Server 2005 & SQL Server 2008? Here I have installed SQL Server 2005 cluster instance and performed in-place upgrade to SQL Server 2008 and upgrade is successful.
And I noticed the SQL Server cluster instance in add/remove programs still after the in-place upgrade and trying to uninstall sql 2005 but it's failing with the below error:
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
SQL Server Setup has determined that the following property was not specified: 'GROUP'. The property specifies the cluster group that contains the SQL Server resources and the disk to which the shared data files are to be written. To proceed, refer to the template.ini and set the property to a valid cluster group name.
------------------------------
BUTTONS:
OK
------------------------------
and I tried to uninstall from passive node and getting the below error:
Registry enumeration failed
So is anything I need to do with SQL-DMO here? I already spend more than a day..please advice
thanks
July 3, 2010 at 4:26 pm
Mani-584606 (7/3/2010)
Hi,I want to uninstall clustered SQL Server 2005 instance from a 2 node a/p cluster.
Before uninstalling SQL instance from active node1, does the SQL Server resources should be moved to passive node2?
or
I can uninstall SQL instance from active node1, having the resources on the same node?
what is the best practice?
thanks
what steps are you performing to remove the clustered instance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 5, 2010 at 10:26 am
what steps are you performing to remove the clustered instance?
Having resources on node1, I tried to uninstall SQL Server 2005 clustered instance from Add/Remove programs
July 5, 2010 at 1:50 pm
Mani-584606 (7/5/2010)
what steps are you performing to remove the clustered instance?
Having resources on node1, I tried to uninstall SQL Server 2005 clustered instance from Add/Remove programs
ok and what did you select after this when the installer runs?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 6, 2010 at 10:30 am
ok and what did you select after this when the installer runs?
From Add/remove programs, I have selected remove and in the SQL Server setup wizard, I have selected the cluster instance name and click next and then I'm getting the error I posted.
Here, first of all why the SQL Server 2005 cluster instance still showing up in Add/remove programs once the in-place upgrade is done?
July 7, 2010 at 5:46 am
Mani-584606 (7/6/2010)
ok and what did you select after this when the installer runs?
From Add/remove programs, I have selected remove and in the SQL Server setup wizard, I have selected the cluster instance name and click next and then I'm getting the error I posted.
Here, first of all why the SQL Server 2005 cluster instance still showing up in Add/remove programs once the in-place upgrade is done?
Ah, thought so. Try the steps below;
In add\remove programs select "Change"
Once the installer starts it will prompt you to select the instance to change, select the clustered instance and click next.
The next screen asks you again to select the clustered instance, select this and click next.
When the "Maintain Virtual Server" dialog appears click "Remove virtual server"
Try these steps and let me know how you get on!
Regards
Perry
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 7, 2010 at 2:24 pm
In add\remove programs select "Change"
Once the installer starts it will prompt you to select the instance to change, select the clustered instance and click next.
The next screen asks you again to select the clustered instance, select this and click next.
When the "Maintain Virtual Server" dialog appears click "Remove virtual server"
I tried this method but still getting the error. Please see the attachment for the screen shots
From the logs, I can see the below error:
Failed to find property "NodeList" {"VirtualServerInfo", "", "INS1VS1"} in cache
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Mon Nov 17 17:05:55 2008
Function Name: VirtualServerInfo.NodeList
Source Line Number: 113
----------------------------------------------------------
Failed to collect property "NodeList" {"VirtualServerInfo", "", "INS1VS1"}
Here, the clustered instance INS1VS1 was already uninstalled successfully but only exist in Add/remove programs and I'm trying to delete from there because when I try to install new failove instance with the same virtual server INS1vs1 and the instance INS1, the setup is failing reporting that the instance name already exist. please select different name..
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply