SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Error applying Service Pack 4 in SQL Server 2005 (version: Microsoft SQL Server 2005 - 9.00.3080.00...


Error applying Service Pack 4 in SQL Server 2005 (version: Microsoft SQL Server 2005 - 9.00.3080.00 (X64)) in windows Server 2008 cluster

Author
Message
SQL-DBA-01
SQL-DBA-01
SSC-Insane
SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)

Group: General Forum Members
Points: 20314 Visits: 3824
Hi All,


While applying the service pack 4 in the SQL Server 2005 (version: Microsoft SQL Server 2005 - 9.00.3080.00 (X64)) in windows Server 2008 cluster, getting the below error -

Product : Database Services (SQLINSTANCENAME)
Product Version (Previous): 3080
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB2463332_sqlrun_sql.msp.log
Error Number : 29512
Error Description : MSP Error: 29512 SQL Server Setup was unable add user DOMAIN\loginame to local group domain\SQLServerAgent.


Can you please suggest what might be the error?

Thanks.
kirkysql
kirkysql
SSC-Enthusiastic
SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)

Group: General Forum Members
Points: 162 Visits: 364
Hey,

Just wondering was there ever a resolution to this issue?

I am experiencing the same

Paul



lulu_lutz
lulu_lutz
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1219 Visits: 277
We had the same exact issue with two sql 2005 clusters when trying to install SP4. Both errored because it didn't like the service account. The one was due to the service account user looking like this username@domain.local rather than domain\username. The other was due to the service account getting changed via the services window rather than the sql configuration manager. If a sql service user is changed in services, it might not update the user in all of the appropriate places on the server. Hope this helps.
kirkysql
kirkysql
SSC-Enthusiastic
SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)

Group: General Forum Members
Points: 162 Visits: 364
We got sorted on this one - old faithful did the trick - REBOOT

To prove the concept, we rebooted the passive node, ran the service pack from the active node again and it patched the passive node successfuly but then failed on the active. A quick reboot of the active and rerun of the service pack and we were sorted.

dunno why though



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search