CoNetrix Blog

Error 29528 When Installing SQL Server Hotfix

Posted on January 22, 2009 9:43 PM

I was trying to install a hotfix package onto a SQL Server and continued to get Error 29528. Upon inspection into the WindowsUpdate.log file, I noticed this line: “Error 29528. The setup has encountered an unexpected error while Setting Internal Properties”. After some Google searching, I stumbled upon a Microsoft KB article that helped out quite a bit. http://support.microsoft.com/kb/925976/

The workaround resolution involves the following steps:

For a stand-alone installation of SQL Server 2005

  • 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:

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

For some reason, the local SIDs had been changed or removed or something and SQL just needed to figure out what was going on.

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

E-mail to a Friend | Comments (13) | 
Tags: ,    Category: Networking

Related Posts

Comments

Comment by Roger Vives

February 18, 2009 11:48 AM

Hi,
I'm installing sp3 on my SQL Server 2005 laptop. I just have installed client components and I get this error.

Product : Client Components
Product Version (Previous): 3054
Product Version (Final) :
Status : Failure
Log File : C:\Archivos de programa\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB955706_sqlrun_tools.msp.log
Error Number : 29528
Error Description : MSP Error: 29528 The setup has encountered an unexpected error while Setting Internal Properties. The error is: Interfaz no compatible

I've taken a look at this workaround but this register key doesn't exist because I only have client components installed.

Can anybody help me?
Thanks a lot!

Comment by Francisco

March 11, 2009 10:10 AM

same problem. When I look into the registry, this key is not there.

Comment by PenPal1999

March 16, 2010 12:16 PM

Worked!!! Thanks, been looking for a fix for weeks.

Comment by Herve Monfouga

April 22, 2010 9:59 AM

Hi,

thanks a lot. It saved my day.

BR
Hervé

Comment by soe

May 27, 2010 11:49 AM

thanks
got the same error when upgrading backup exec 12.5 to 2010 during the sql installation

Comment by James

July 15, 2010 3:47 PM

This worked perfect and fixed my problem, thanks!

Comment by JRVandy

August 12, 2010 3:36 PM

We found the proper registry entries in a different area on our 2003 64 bit server
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\MSSQL.1
Deleting the above keys did the trick.

Comment by Robert

October 21, 2010 4:22 PM

Excellent post. I've been looking for this for days. Worked for me.

Comment by Hospice

December 8, 2010 11:05 PM

Worked for me as well, Kudos and thanks!

Comment by Eric M

December 29, 2010 11:39 PM

This is a life saver - been trying to solve this for hours. Used the PSGetSid version of this with no fix - when all else fails, delete the keys...

Comment by Mohammad

January 29, 2011 10:02 AM

It was great!

worked for me like a charm!

well done.

Comment by sikander

August 24, 2011 12:14 AM

This worked for me. Thank you very much.

Comment by Vladamir

January 17, 2012 11:25 PM

It worked for me too! Thank You.

Add Comment





[b][/b] - [i][/i] - [u][/u]- [quote][/quote]