Problems uninstalling a clustered instance

Question

Post reply

Problems uninstalling a clustered instance

WayneS

SSC Guru

Points: 95405
More actions
September 29, 2010 at 5:13 pm

#227219

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
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95405 More actions · Answer 1

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

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

WayneS SSC Guru Points: 95405 More actions · Answer 2

FYI:

I was able to manually uninstall the instance from the cluster using the directions at http://qa.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

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2