sql 2005 service pack 2 fails on a node in the cluster

Giganews Newsgroups
Subject: sql 2005 service pack 2 fails on a node in the cluster
Posted by:  johnboy1973 (johnboy19…@hotmail.com)
Date: Tue, 19 Jun 2007

We have a 2003 clster with 2005 sql running across 2 nodes. We ran SP2
on the active node, all went through successfully, but it dodnt.

It left one node SQL SP2 and 1 Node SQL SP1

No every time i install the service pack on the sp1 node i get an
error as detailed below. Been on to MS so far, and tried many things
detailed on the net, even the bug thats similar on sp1 upgrades.

Any advice would be apprechiated.

ERROR:

<Func Name='Do_sqlGroupMember'>
Local group SLINKLAN\ClusterSQLServer doesn't exist
Failure adding user serviceaccou…@domain.com to local group ADDomain
\ClusterSQLServer (2221)
        Error Code: 0x800708ad (2221)
Windows Error Text: The user name could not be found.
  Source File Name: sqlca\sqlsecurityca.cpp
Compiler Timestamp: Wed Jun 14 16:27:11 2006
    Function Name: Do_sqlGroupMember
Source Line Number: 1132

OR IN SUMMARY REPORT AT END OF SETUP:

MSP Error: 29512  SQL Server Setup was unable add user
serviceaccpou…@domain.com to local group domain\ClusterSQLServer

CHEERS IN ADVANCE

Replies