Link to home
Start Free TrialLog in
Avatar of rares_dumitrescu
rares_dumitrescu

asked on

REBUILD SQL CLUSTER NODE

Hi,

   I am trying to rebuild a SQL 2000 Cluster node in an active/passive configuration. On the active node I have SQL 2000 SP4 and it`s working fine.
   I have successfully installed SQL Server 2000 on the passive node and now I have hard times installing SP4.

I have tried to installed and I am prompted with some errors:
setup cannot verify/grant logon as service right to the SQL Server service logon account: 5000 => I followed http://support.microsoft.com/kb/905286, but couldn`t see any update.
   One more thing I`ve tried was to delete "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Need_sp_key" as found in other articles, but although after that the setup went a couple of stept further it failed again.

thx 4 help
ASKER CERTIFIED SOLUTION
Avatar of arnold
arnold
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
From what I understand....the system was already up...running smoothly...then they added spk 2 to OS and the cluster "broke" *( dont know what that means because he rebuild)...Ok I am going to reinstall ...patch OS first..then add sql server 2000 and patch to serivce pack 4..Like I said I see errors in the events log but I dont know what happened...
Can you confirm that instructions and overall look of content in Cluster Administrator should resemble Windows 2000 build...I believe this is an active/passive configuraiton one primary and one secondary