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"

Article translations Article translations
Article ID: 919945 - View products that this article applies to.
Bug #: 408947 (SQLBUDT)

Expand all | Collapse all

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: August 3, 2006 - Revision: 2.1
APPLIES TO
  • 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
Keywords: 
kbexpertiseadvanced kbtshoot kbprb KB919945

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com