Error installing SQL 2005 SP2 KB 921896

4 May 2007 2:13 AM

rlusian

I am running Windows 2003 Enterprise SP2 running SQL 2005 Enterprise and am
getting repeated failures applying SQL 2005 SP2. The error is always the
same (see below).

I have made sure that there are no disabled services in the SQL Server
family of services, but this does not appear to have helped. This SQL
installation is pretty minimal, basically just the Database Engine. The
services list is:

SQL Server (MSSQLSERVER) Started    Automatic    Local System
SQL Server Active Directory Helper Manual (was disabled) Network Service
SQL Server Agent (MSSQLSERVER) Started    Automatic    Local System
SQL Server Browser Manual (was disabled)    Local System
SQL Server FullText Search (MSSQLSERVER) Started    Automatic    Local System
SQL Server VSS Writer Started    Automatic    Local System

from the summary: ----------------------------------------------------------------------------------
Product                   : Database Services (MSSQLSERVER)
Product Version (Previous): 2047
Product Version (Final)   :
Status                    : Failure
Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number              : 29528
Error Description         : MSP Error: 29528 The setup has encountered an
unexpected error while Setting Internal Properties. The error is: Fatal error
during installation.

from the event log:
Event Type:    Error
Event Source:    MsiInstaller
Event Category:    None
Event ID:    1023
Date:        5/3/2007
Time:        6:37:36 PM
User:        RLTESTENV002\Administrator
Computer:    RLTESTENV002
Description:
Product: Microsoft SQL Server 2005 - Update 'Service Pack 2 for SQL Server
Database Services 2005 ENU (KB921896)' could not be installed. Error code
1603. Additional information is available in the log file C:\Program
Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log.

Event Type:    Error
Event Source:    MsiInstaller
Event Category:    None
Event ID:    10005
Date:        5/3/2007
Time:        6:37:35 PM
User:        RLTESTENV002\Administrator
Computer:    RLTESTENV002
Description:
Product: Microsoft SQL Server 2005 -- Error 29528. The setup has encountered
an unexpected error while Setting Internal Properties. The error is: Fatal
error during installation.

I can send the detailed log if you need it.

4 May 2007 7:09 AM

Peter Yang [MSFT]

Hello,

From the error message "Error Description : MSP Error: 29528 The setup has
encountered an unexpected error while Setting Internal Properties. The
error is: Fatal error during installation", this is a known issue. 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.

Considering your SQL Server is not a clustered instance, please follow the
below steps to workaround the problem:

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.

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 more information about this issue, please refer to KB 925976:
<http://support.microsoft.com/default.aspx?scid=kb;EN-US;925976>

Please let em know if this resolve the problem. If you encounter any
further error, please also let's know. Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

8 May 2007 7:04 AM

Peter Yang [MSFT]

Hello,

I'm still interested in this issue. If you have any comments or questions,
please feel free to let's know. We look forward to hearing from you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.