You are currently offline, waiting for your internet to reconnect

Error message when you uninstall SQL Server 2005 or install SQL Server 2005 Service Pack 1: "The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation"

Extended support for SQL Server 2005 ends on April 12, 2016

If you are still running SQL Server 2005 after April 12, 2016, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

Bug #: 408947 (SQLBUDT)

SYMPTOMS
When you uninstall Microsoft SQL Server 2005, you receive the following error message:
The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.
This problem occurs when you perform the following operations before you uninstall SQL Server 2005:
  1. You install the Active Directory directory service on the server.
  2. You install SQL Server 2005.
  3. You remove Active Directory from the server.
In another scenario, after you move Microsoft Windows from one domain to another domain, you receive the same error message when you install Microsoft SQL Server 2005 Service Pack 1 (SP1).
CAUSE
This problem occurs because the SQL Server user groups do not match the corresponding security IDs in the Windows registry.

SQL Server 2005 requires that the SQL Server user groups match the corresponding security IDs in the Windows registry to successfully install or uninstall SQL Server 2005.
WORKAROUND
To work around this problem, follow these steps:
  1. Start Registry Editor, and then locate one of the following registry subkeys:
    • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2005\Setup
    • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup


    Note Only one of these registry subkeys will exist on your computer.
  2. Empty the following registry entries:
    • SQLGroup
    • FTSGroup
    • AGTGroup
  3. Exit Registry Editor.
  4. Uninstall SQL Server 2005 or install SQL Server 2005 SP1.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Properties

Article ID: 919945 - Last Review: 08/03/2006 20:46:31 - Revision: 2.1

Microsoft SQL Server 2005 Standard Edition, Microsoft SQL Server 2005 Workgroup Edition, Microsoft SQL Server 2005 Developer Edition, Microsoft SQL Server 2005 Enterprise Edition, Microsoft SQL Server 2005 Service Pack 1

  • kbexpertiseadvanced kbtshoot kbprb KB919945
Feedback
/html>om/c.gif?DI=4050&did=1&t=">