Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Clustering / September 2005

Tip: Looking for answers? Try searching our database.

upgrade to SP4 from SQL 2000 SP3  on a 2 node cluster failing

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bill - 17 Sep 2005 05:36 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.