On a Windows Advanced Server 2000 2 node cluster with SQL 2000 SP3 installed,
I'm trying to apply SQL 2000 service pack 4, but at the point where you enter
"a username and password that is a valid administrator account on all nodes
in the cluster", I do that but get this error: The specified account cannot
be validated to have administrator rights on DATA2 An error occurred (1326)
Logon failure: Unknown user name or bad password".
The account I'm using is a domain administrator account which I have used to
successfully log into both nodes of this cluster. DATA2, by the way, is the
passive node of the failover cluster.
When I run Cluster Administrator I can see both nodes and failover happens
fine whenever I have to reboot the active node.
I'm pulling my hair out on this one because I can't get past this point in
the install process. Any ideas?
Nik Marshall-Blank - 17 Sep 2005 07:46 GMT
Search the registry for NEED_SP_KEY, if it's there delete it and retry.

Signature
Nik Marshall-Blank MCSD/MCDBA
> On a Windows Advanced Server 2000 2 node cluster with SQL 2000 SP3
> installed,
[quoted text clipped - 19 lines]
> I'm pulling my hair out on this one because I can't get past this point in
> the install process. Any ideas?
Bill - 17 Sep 2005 13:27 GMT
Searched for the entry NEED_SP_KEY on both nodes and couldn't find it on
either one.
Bill - 17 Sep 2005 18:07 GMT
My follow-up to this is that I rebooted the active node to make the other
node active. and was able to install SP4 from.