SP2 for SQL 2005 Fails to update one of the nodes in our 2003 Server Cluster

Giganews Newsgroups
Subject: SP2 for SQL 2005 Fails to update one of the nodes in our 2003 Server 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 serviceacco.…@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
serviceaccpo.…@domain.com to local group domain\ClusterSQLServer

CHEERS IN ADVANCE

Replies