SQL 2000 test cluster: SP4 not applying

I'm building, for learning purposes, a two-node SQL Server 2000 cluster using VMWare; the guest OS is Windows Server 2003, SP1.

I managed to correctly configure VMWare to share some virtual disks between two VMs, created a third VM to use as a domain controller, crated the domain, joined the two cluster VMs to it and created the cluster using one of the shared disks for the quorum; I also added two virtual NICs to them, to simulate the private cluster network.
The cluster was up and running fine, and I also added three other shared virtual disks to it, and configured them as cluster resources in a specific resource group ("database group", as opposed to the default "cluster group"). I tested failover and failback and they were ok.

I then installed SQL Server 2000 (RTM) as a virtual server, default instance, using both nodes; I chose one of the shared disks to host the main SQL data files, planning to (later) put new databases and logs on the other two; the server got installed, and its resources (correctly) were put into the same group as the shared disks ("database group"). I again tested failover and failback, and they were ok.

Then, before creating any user DB and/or configuring anything else, I proceeded to apply SP4 to the virtual server. I went through all the setup options (I didn't set any SA password, as I configured the server to not use SQL Server authentication), until the actual installation started and said it was performing the required operations on the cluster nodes. Then, it displayed an error message about not being able to perform some operations, and exited.
I've tried it many times, but the result is always the same; I've re-installed SQL Server, and even rebuilt the whole cluster from scratch, but I'm still unable to apply SP4 to it.

Can someone please help?

Thanks.


Massimo

P.S.
All of the software involved are localized in Italian; I don't know if this can be of any importance.

P.P.S.
In a clustered environment like this, is a MSDTC cluster resource needed? I didn't create any.

.

Relevant Pages

  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... In the cluster administrator, there are 5 Groups: ... DBC01 (Disks, SQL Server resources) ... Install RTM SS2K and designate the node membership. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2000 on Windows 2000 Cluster - Removal!
    ... If you take out the cluster, those disks are still ... > The cleanest way to do this would be to uninstall SQL Server (leave the data ... can I simply disable the cluster service and start SQL as ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server service on active/passive
    ... the passive node, the disks are hardware services that are also turned off ... All clustered resources, IPs, Network Names, Disks, SQL Server, are mapped ... cluster configuration. ...
    (microsoft.public.sqlserver.clustering)
  • 2 node MSCS cluster - replace server hardware and move from W2K to W2K3
    ... MSCS cluster, and end up on higher version of Windows. ... Active/Passive SQL Server 2000 Enterprise Edition ... FC2142SR fibre channel HBAs, which I want to use to replace the nodes ... I've moved the relevant cluster resources to that node ...
    (microsoft.public.windows.server.clustering)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Now, for the first problem, adding the 3rd node as a member of the cluster. ... You then installed a 2nd instance of SQL Server. ... DBC01 (Disks, SQL Server resources) ... Install RTM SS2K and designate the node membership. ...
    (microsoft.public.sqlserver.clustering)
Loading