page contents

About the Post

Author Information

Fixed an issue *removing* SQL Server 2008r2

I had an issue tonight where I was unable to remove Microsoft SQL Server 2008r2. The setup was just hanging at this step SqlEngineConfigAction_remove_validation_Cpu64.

I first tried to remove it by Add/Remove Programs and then tried it by the command line:

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2>setup.exe

/ACTION=uninstall /FEATURES=SQL,AS,BOL,SSMS/INSTANCENAME=MSSQLSERVER

Neither action would work and it was still stuck there. So it appeared installed, but the program would never work and it left me without the ability to remove it. So, I did a bit of searching on the internet and found 2 great posts below as reference links that helped aid me in resolving the issue, as seen below.

It appears that the following Registry-Key must be set to 1 (Originally mine was set to 0, which caused the switchback functionality to be overridden):

HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\AppCompat\sbEnable = 1

More information here:

Windows 7 AppCompat changes and SQL Server client and setup hangs
http://blogs.msdn.com/b/sql_protocols/archive/2010/08/13/windows-7-appcompat-changes-and-sql-server-client-and-setup-hangs.aspx

After I made the change, rebooted and then re-ran my command line removal (listed above) and it worked like a champ as seen below!

Reference links:

Cannot Uninstall/repair SQL2008R2 Dev. – Setup hangs at step SqlEngineConfigAction_remove_validation_Cpu64 infinite!
http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/8d00ba7a-e3dc-408e-bb01-6ed82f3f0ccc/

SQL Server 2008 installation fails when you try to install SQL Server a second time (Shows command line removal)
http://support.microsoft.com/kb/955404

Tags: , , , , ,

Trackbacks/Pingbacks

  1. Fixed an issue *installing* SQL Server 2008r2 | Scott Mattie's blog - March 16, 2012

    […] Server 2008r2 As you will remember, I had an issue trying to *remove* SQL Server 2008r2 as noted here. What I failed to tell you was what my REAL issue was… I could not successfully install SQL […]

Copy Protected by Chetan's WP-Copyprotect.