Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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"


Bug #: 408947 (SQLBUDT)

↑ Back to the top


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).

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top


Keywords: kbsql2005error, kbexpertiseadvanced, kbtshoot, kbprb, kb, misc_migrate_32718

↑ Back to the top

Article Info
Article ID : 919945
Revision : 6
Created on : 4/13/2018
Published on : 4/13/2018
Exists online : False
Views : 272