A little trick to install SQL 2005 onto your dirty DEV machine

Maybe you have installed SQL 2005 beta stuff on your DEV machine and now you want to install the RTM. Due to some nasty bugs, you may fail to uninstall the Yukon completely. Now when you attempt to install the RTM version, the setup.exe may ask you to uninstall previous version SQL or .Net component first via "Add or Remove programs" of the control panel. However, maybe you have already done that and couldn't see any SQL components there. Then you may desperately delete the physical SQL folder and try again. The setup.exe will still stop and give you a same prompt.

I have found a little trick which may solve this(Assume you don't want to keep any SQL stuff!!!):

Delete registries

  1. Delete HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData
  2. Delete HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\90
  3. Delete HKCU\SOFTWARE\Microsoft\Microsoft SQL Server\90
  4. Delete all 2.0 stuff under HKLM\SOFTWARE\Microsoft\.NETFramework

Delete Services

Use sc.exe to find and delete all SQL services.

  1. sc delete mssqlserver
  2. sc delete sqlserveragent
  3. sc delete sqlbrowser
  4. sc delete msolapservices
  5. sc delete mssqlserverolapservice
  6. sc delete mssqlserveradhelper
  7. sc delete msdtsserver
  8. sc delete msftesql
  9. sc delete nsservice
  10. sc delete reportserver

Delete Assemblies

  1. del /s /q /f "%windir%\assembly\gac\*sqlserver*"
  2. del /s /q /f "%windir%\assembly\gac_32\*sqlserver*"
  3. del /s /q /f "%windir%\assembly\gac_msil\*sqlserver*"

Then you can try the setup.exe again, it will proceed to the next dialog.

See also

  • SQL: Use Dynamic SQL Query Correctly
  • SQL 2005: Use DMV and CROSS APPLY to Get Cached Plans
  • SQL 2005: Discontinued or Deprecated Features in SQL Server 2005
  • SQL 2005: Default Trace Enabled Option
  • SQL 2005: Column Level Permissions
  • SQL 2005: SQLCMD Supports Parameterized Variables and Macro Features
  • SQL 2005: DTS Has Become SSIS now
  • SQL 2005: Microsoft SQL Server 2005 JDBC Driver
  • SQL 2005: Query Notifications in ADO.Net 2.0
  • SQL 2005: Overcome SQL Index Size Limit
  • SQL 2005: DDL Triggers
  • SQL 2005: Why Should Use 64 Bit Now
  • SQL 2005: How to Rebuild The Master Database
  • SQL 2005: A Little Trick to Install SQL 2005 Onto Your Dirty DEV Machine
  • SQL 2005: New Resource Database
  • SQL 2005: Alter Index Rebuild
  • SQL 2005: XQuery Sample
  • SQL 2005: How to Move Database
  • SQL: Use COALESCE to Generate a List
  • SQL: How to Debug SQL Deadlocks
  • .Net: How to Bypass Strong Name Check
  • Agile: Lean Software Development - An Agile Toolkit
  • ORM: How to Use nHibernate 1.2 to Call Stored Procedure to Return a Dataset Without a Mapping Entity
  • AJAX: ASP.NET AJAX Tips
  • .Net: Debugging Commands
  • .Net: How to Run NUnit And Debug Your Test Fixtures Directly from VS 2005
  • .Net: How to Add Domain User to Local Group
  • .Net: Lock Value Type?
  • .Net: How to Create an Instance of a Generic Type with Parameters
  • .Net: How to Get Address of a Managed Type
  • ORM: New Features of nHibernate 1.2
  • .Net: How to Get System Error Message from HRESULT in Managed Code
  • .Net: Use Windows PowerShell Now
  • WMI: Use WMI to Run Commands on Remote Machine
  • API: GetLogicalProcessorInformation to Detect CPUs
  • .Net: How to Implement Singleton Correctly
  • .Net: There is no MTS object context (Exception from HRESULT: 0x8004E004)
  • .Net: The Net Objectives Pattern Repository
  • Web: Access Denied When ASP.Net Accesses Eventlog
  • Nant: Error Loading GUID of Project
  • AJAX: Ajax in Action
  • DTC: DtcGetTransactionManager Fails
  • .Net: Run .Net 1.1 COM+ Serviced Components Under .Net 2.0 Framework
  • .Net: Debugging Managed Code Tip
  • .Net: Assembly Binding Log Viewer (Fuslogvw.exe)
  • .Net: .Net Framework Design Guidelines
  • .Net: Use Global Catalog and CheckTokenMembership to Check AD Group Membership



    • THIS POST IS PROVIDED "AS-IS" WITH NO WARRANTIES AND CONFERS NO RIGHTS. Build time: Sun 03/30/2008 . ©2007 Dalun Software. All rights reserved. Back to Article List