Wednesday, May 23, 2012

SQL Server 2005 Unintall Issue

While uninstalling SQL Server 2005 from the server i got below errors. After doing 15 minutes of R&D i came to know the solution, Let me explain error details and workaround for this. 

Error Message: 
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe ===
MSI (c) (50:A4) [15:39:40:509]: Resetting cached policy values
MSI (c) (50:A4) [15:39:40:509]: Machine policy value 'Debug' is 0
MSI (c) (50:A4) [15:39:40:509]: ******* RunEngine:
           ******* Action:
           ******* CommandLine: **********
MSI (c) (50:A4) [15:39:40:509]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (50:A4) [15:39:40:509]: Grabbed execution mutex.
MSI (c) (50:A4) [15:39:40:525]: Failed to connect to server. Error: 0x80070422

MSI (c) (50:A4) [15:39:40:525]: Failed to connect to server.
MSI (c) (50:A4) [15:39:40:525]: MainEngineThread is returning 1601
=== Verbose logging stopped: 5/11/2012  15:39:40 ===

From above error messages and error log it is very difficult to understand the exact issue, it was not clear at-all. Let me explain workaround to this error. From which server i had uninstalled sql server 2005 is a SOX server, as per SOX Control we have disabled Windows Installer, after enabling and Start the Windows Installer, the uninstall successfully completed without any failure.

Step 1: Click 'Run' from the Start menu. 

Step 2: Type services.msc and click Enter.

Step 3: In services check for Windows Installer.

Step 4: Right click on Windows installer and select Properties like below image.

Step 5: After clicking Properties, new pop-up box will open like below.

Step 6:  From Startup type select Automatic, and click apply after that click Start button and click ok. 

Step 7:  Now open Add/Remove program from control panel and follow the uninstall procedure.

How can I completely uninstall SQL Server. Uninstall SQL Server 2008. SQL Server 2008 R2. Uninstall and Remove Multiple Database Instances of Microsoft SQL. How to Uninstall SQL Server. How to complete uninstall SQL Server 2008 R2. how to remove sql server 2000 completly. sql server uninstall cleanup sql server uninstall service pack. sql server uninstall error code 0x84b30002. sql server uninstall named instance. sql server uninstall 0x84b30002. sql server uninstall analysis services. sql server uninstall tool sql server 2008 uninstall. Uninstall SQL SERVER 2005 from command prompt. SQL Server won't uninstall! Databases. How to Uninstall Reporting Services from SQL Server 2008 R2. Not able to uninstall SQL Server 2005 default instance. how to install sql server 2012. How to uninstall an instance of SQL Server 2008. How to manually remove SQL Server 2000 default. How to uninstall SQL Server Management Studio. HOW TO: Remove a SQL Server Service Pack. how to uninstall sql server service pack completly.


Post a Comment