Microsoft KB Archive/925976

Knowledge Base

Error message when you try to install a SQL Server 2005 service pack or a SQL Server 2005 hotfix package: "Error 29528. The setup has encountered an unexpected error while Setting Internal Properties"

Article ID: 925976

Article Last Modified on 11/20/2007

---

APPLIES TO

• Microsoft SQL Server 2005 Standard Edition
• Microsoft SQL Server 2005 Developer Edition
• Microsoft SQL Server 2005 Enterprise Edition
• Microsoft SQL Server 2005 Standard X64 Edition
• Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
• Microsoft SQL Server 2005 Enterprise X64 Edition
• Microsoft SQL Server 2005 Express Edition with Advanced Services

---

Important This article contains information about how to modify the registry. Make sure to back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows registry

SYMPTOMS

When you try to install Microsoft SQL Server 2005 Service Pack 1 (SP1), later SQL Server 2005 service packs, or a SQL Server 2005 hotfix package, SQL Server 2005 Database Services or SQL Server 2005 Analysis Services may not be installed successfully. Additionally, the following error message may be logged in the Setup log file:

Error 29528. The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.

CAUSE

This issue occurs because of one of the following reasons:

• An operation has removed the local groups for the initial installation of SQL Server 2005.
• An operation has changed the security identifiers (SID) for the local groups.

WORKAROUND

Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

For a stand-alone installation of SQL Server 2005

1. Remove the following registry subkeys that store SID settings:
   • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup\SQLGroup
   • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup\AGTGroup
   • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup\FTSGroup
   • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup\ASGroup

   Note In these registry subkeys, MSSQL.X is a placeholder for the corresponding value on a specific system. You can determine MSSQL.X on a specific system by examining the value of the MSSQLSERVER registry entry under the following registry subkey:

   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL\

2. Reinstall the SQL Server 2005 service pack or the SQL Server 2005 hotfix package.

For a clustered instance of SQL Server 2005

1. Follow step 1 in the procedure for a stand-alone installation of SQL Server 2005.
2. Reinstall the clustered instance of SQL Server 2005.
3. Reinstall the SQL Server 2005 service pack or the SQL Server 2005 hotfix package.

STATUS

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

MORE INFORMATION

The initial installation of SQL Server 2005 creates local groups and stores the SID settings for the local groups in the registry. However, the local groups or the SIDs may be removed or changed when you perform the following operations:

• Install the Active Directory directory service on a member server.
• Remove Active Directory from a domain controller.

Keywords: kbtshoot kbprb kbexpertiseadvanced kbsql2005setup KB925976

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.