SQL 2005 SP3 fails to update Error Code 29512

Last Post 28 Jun 2010 05:03 AM by zeeaay. 6 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages Not Resolved
zeeaay
New Member
New Member

--
24 Jun 2010 05:22 PM
Hi All,
I am having a proble update my production SQL Server 2005 to SP3. it fails and gives me an ERROR Code 29512 and it is a Cluster Installation.

Any help will be appreciated highly
zeeaay
New Member
New Member

--
24 Jun 2010 05:24 PM
I am sorry I typed message so quick. It is NOT Cluster andUpdate to SP3 is failing due to this Error Code 29512
rm
New Member
New Member

--
25 Jun 2010 03:58 AM
Check sp3 installation log files for details, they are in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix by default.
rm
New Member
New Member

--
25 Jun 2010 04:01 AM
Here's link to address similar issue:
http://support.microsoft.com/kb/917410
zeeaay
New Member
New Member

--
25 Jun 2010 05:33 AM
Hey Folks,
Thanks for all your replies and help. I have done all what you are recommanding but nothing works. The Service agent account is already included long before this SP3 as SP1, Sp2 were applied back in 2007.

the log file also mentions this error code only and nothing else, and it points nowhere. I have also submitted this case with MS and it is been about a week they are just pushing the envelope from one to another and Windows to SQL and vice versa
J013-B
New Member
New Member

--
27 Jun 2010 02:52 PM
Can you post the install log?
zeeaay
New Member
New Member

--
28 Jun 2010 05:03 AM
Log file.

Time: 06/20/2010 13:07:09.069 KB Number: KB955706 Machine: DCCAS12 OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 2 (Build 3790) Package Language: 1033 (ENU) Package Platform: x86 Package SP Level: 3 Package Version: 4035 Command-line parameters specified: Cluster Installation: No ********************************************************************************** Prerequisites Check & Status SQLSupport: Passed ********************************************************************************** Products Detected Language Level Patch Level Platform Edition Setup Support Files ENU 9.2.3042 x86 Database Services (GREATPLAINS) ENU SP2 2005.090.3054.00 x86 STANDARD Analysis Services (GREATPLAINS) ENU SP2 2005.090.3054.00 x86 STANDARD Notification Services ENU SP2 9.00.3080.00 x86 STANDARD Integration Services ENU SP2 9.00.3080.00 x86 STANDARD SQL Server Native Client ENU 9.00.3042.00 x86 Client Components ENU SP2 9.2.3080 x86 STANDARD MSXML 6.0 P***r ENU 6.20.2003.0 x86 SQLXML4 ENU 9.00.3042.00 x86 Backward Compatibility ENU 8.05.2004 x86 Microsoft SQL Server VSS Writer ENU 9.00.3042.00 x86 ********************************************************************************** Products Disqualified & Reason Product Reason ********************************************************************************** Processes Locking Files Process Name Feature Type User Name PID MSSQL$GREATPLAINS SQL Server Native Client Service 2320 SQLAgent$GREATPLAINS SQL Server Native Client Service 3864 msftesql$GREATPLAINS Database Services Service 2264 SQLBrowser Database Services Service 2668 MSOLAP$GREATPLAINS Analysis Services Service 2300 SQLWriter Microsoft SQL Server VSS Writer Service NT AUTHORITY\SYSTEM 3324 ********************************************************************************** Product Installation Status Product : Setup Support Files Product Version (Previous): 3042 Product Version (Final) : 4035 Status : Success Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB955706_SqlSupport.msi.log Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : Database Services (GREATPLAINS) Product Version (Previous): 3054 Product Version (Final) : Status : Failure Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log Error Number : 29512 Error Description : MSP Error: 29512 SQL Server Setup was unable add user CAS\homer to local group CAS\SQLServer2005SQLAgentUser$DCCAS04$GREATPLAINS. ----------------------------------------------------------------------------------


Acceptable Use Policy
---