Uninstall SQL Server 2005 Express after Demoting the DC
- by Walter Aman
A Windows Server 2003 SP2 hosting a now orphan installation of SQL 2005 Workgroup was pressed into service as a DC in a disaster recovery scenario. It has since been demoted. The server also hosts legacy apps for which we lack reinstallation resources; thus our desire to preserve it as close to intact as possible while removing the orphaned roles.
All efforts to remove SQL 2005 thru Control Panel and ARPWrapper /remove fail with error 29528.
Should I abandon this and leave the orphan SQL dormant, or is it reasonable to remove it post-demote?