Errors during apply SP3 in passive node in SQL server 2005 cluster

• wanxzhu

  SSC Journeyman

  Points: 98

  More actions

  December 16, 2010 at 7:36 am

  #146555

  I have 2-node SQL server 2005 cluster with Windows Server 2003. I have installed SQL server 2005 SP3 on my cluster server. However the passive node can not be applied SP3. I tried to put passive node to active and install SP3 and got error message, Database Services -MSSQLSERVER - Failure.

  "A recently applied update, KB955706, failed to install."

  Does anyone have idea that how to keep SQL server 2005 clusters in the same service pack.

  Thanks for your input.

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  December 16, 2010 at 10:59 am

  #1263594

  Pls check these links

  http://www.sqlservercentral.com/articles/Installation/66128/

  http://www.sqlservercentral.com/blogs/sql_performance/archive/2010/02/05/microsoft-sql-server-2005-service-pack-3-installation-in-cluster-environment.aspx

  http://www.sqlcoffee.com/Tips0007.htm

  Thank You,

  Best Regards,

  SQLBuddy

• wanxzhu

  SSC Journeyman

  Points: 98

  More actions

  December 16, 2010 at 12:12 pm

  #1263648

  Thanks for your kind reply.

  I resoved the problem with this simple command switch /passive.

  http://support.microsoft.com/kb/973993