September 29, 2010 at 5:13 pm
I upgraded a SQL 2005 named instance to 2008.
After this succeeded, I started adding two other instances.
After adding the first instance to the active node, I went to the passive node to add it there. The install detected that I had installed it as a default (MSSQLSERVER) instance instead of a named instance. So I went back to the active node, and was removing the instance so that it can be reinstalled.
The uninstall has stalled (it's now been 2 hours since the last log entry). On the "Remove Node Progress" screen, I have:
Performing Windows Installer actions.
{progress bar, about 55%}
cluster_ip_address_cluster_unconfig_Cpu32
In the C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100929_165557\Detail.txt log file, I have this as the last few entries:
2010-09-29 17:07:00 Slp: Completed Action: SqlEngineConfigAction_remove_unconfignonrc_Cpu32, returned True
2010-09-29 17:07:00 Slp: ---- Flush datastore cache before calling configuration action 'cluster_ip_address_cluster_unconfig_Cpu32'
2010-09-29 17:07:00 Slp: ---- Flush datastore cache before calling configuration action 'cluster_ip_address_cluster_unconfig_Cpu32'
2010-09-29 17:07:00 Slp: ----------------------------------------------------------------------
2010-09-29 17:07:00 Slp: Running Action: cluster_ip_address_cluster_unconfig_Cpu32
2010-09-29 17:07:00 Slp: Action Data:
2010-09-29 17:07:00 Slp: Feature = SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu32
2010-09-29 17:07:00 Slp: Scenario = uninstall
2010-09-29 17:07:00 Slp: Timing = UnConfigNonRC
2010-09-29 17:07:00 Slp: ConfigObjectType = Microsoft.SqlServer.Configuration.ClusterConfiguration.ClusterIPAddressPrivateConfigObject
2010-09-29 17:07:00 Slp: FeatureName = SQL_Engine_Core_Inst
2010-09-29 17:07:00 Slp: FeatureCpuType = Cpu32
2010-09-29 17:07:00 Slp: FeaturePackageId = sql_engine_core_inst
2010-09-29 17:07:00 Slp: FeatureClusterState = None
2010-09-29 17:07:00 Slp: InstallId = Machine[@ID='{NodeName}']/Product[@ID='SQL2008']/Instance[@ID='MSSQLSERVER']/Feature[@ID='SQLEngine_CTP5' and @RegistryPath='SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.{DesiredInstanceName}\Setup' and @RootPath='SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.JCIMS']/Install[@ProductCode='B5153233-9AEE-4CD4-9D2C-4FAAC870DBE2']
2010-09-29 17:07:00 Slp: InstanceName property not found. Creating with defaults.
2010-09-29 17:07:00 Slp: InstanceName property not found. Creating with defaults.
2010-09-29 17:07:00 Slp: InstanceName property not found. Creating with defaults.
2010-09-29 17:07:00 Slp: Taking the network name resource 'SQL Network Name ({VirtualName})' offline
2010-09-29 17:07:00 Slp: Taking cluster resource 'SQL Network Name ({VirtualName})' offline
(Note: the parts in the {} are sanitized entries.)
So it looks like it has completed the part showing on the screen, and is stalled on the next step - before it updated the progress screen.
Cluster Administrator shows this group as having the SQL IP Address as Online, and the SQL Network Name as Offline. The SQL Server and SQL Server Agent entries are not present (they are in the cluster group that was upgraded). But, since the IP address is still online, did it really finish that part?
Any tips for how to complete the uninstall of this instance, without hosing up the other instance.
I also note in the log that there was the desired instance name - any ideas of why the installer detected it as MSSQLSERVER (the default) instead of the proper name on the passive node?
Thanks,
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
September 30, 2010 at 7:49 am
Still trying to uninstall. No further progress after running overnight.
I have noticed that in the registry (HKLM\Software\Microsoft\Microsoft SQL Server) that there are keys for MSSQL10.NamedInstance and MSRS10.NamedInstance for the instance that I'm trying to uninstall.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
September 30, 2010 at 9:53 am
FYI:
I was able to manually uninstall the instance from the cluster using the directions at http://www.sqlservercentral.com/blogs/pearlknows/archive/2010/07/26/uninstall-a-sql-server-cluster-when-all-else-fails.aspx?CommentPosted=true#commentmessage as a guideline - modified to only delete registry keys and binary files that were applicable to the one instance.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply