Re: Setup Failed to Perform Req'd operations on CLuster Nodes

Reboot both nodes before SP3a. Install may have a file locked on the remote
node. Also, move the SQL resource group back and forth between the nodes at
least once aftre the reboot but before the SP3a install. That should either
fix the cluster registry keys or determine what is broken.


--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP


"KMcDermott" <KMcDermott@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3EC7FB56-2168-424D-925E-C810C7A30EFC@xxxxxxxxxxxxxxxx
> Geoff...
>
> Installed MSSearch manually on both nodes successfully.
>
> Re-registered gathercl.dll on both nodes successfully.
>
> Re-ran the installation as normal, new errors during the "Setup is
> creating
> Virtual Server resources on the Cluster" process:
>
> -An Error Occurred while creating virtual server resources for clustering.
> Cluster specific registry entries couldn't be written <<OK>>
> -Setup is performing cleanup operations on cluster nodes and will exit
> once
> the cleanup is complete.
>
> Finally seeing MSSQLSERVER events in Application log of FCIADB1
>
> Per MSKB 872931, added LOCAL SERVICE to the READ permissions on
> HKLM\SYSTEM\CurrentControlSet\Control\SecurePipeServers\Winreg key
>
> Deleted the existing but offline/unstartable SQL resources from the
> Cluster
>
> Add MSDTC Resource to the Cluster Group (MSKB 301600 - step 7 on)
>
> Enable DTC Access in Windows 2003 (Add/Remove Programs > Application
> Server
>> Enable DTC Access) on both nodes (MSKB 817064)
>
> Add LOCAL SERVICE with Read Permissions to
> HKLM\SYSTEM\CurrentControlSet\Control\SecurePipeServers\Winreg key on both
> nodes (MSKB 872931)
>
> Confirm that Remote Registry was started on both nodes
>
> Login to each node as domain account used for install and log off
>
> Installation Successful.
>
>
> Only problem is, that now I cannot apply SP3a.
>
> downloaded & expanded SQLSP3a to c:\sqlsp3a on local node.
>
> SETUP FAILED TO PERFORM OPERATIONS ON CLUSTER THE NODES
>
> log follows:


.

Relevant Pages

  • Re: Pervasive SQL Clustering
    ... So, in effect, I've got services running on the cluster and both nodes. ... Is it possible to install and application to the cluster rather than the ... > setting up a Generic Service resource, you might find this topic from Help ... > or application highly available using Generic Service or Generic Application ...
    (microsoft.public.windows.server.clustering)
  • Re: sql 2005 cluster setup questions
    ... Thanks again, Geoff. ... Here is the official instructions on how to rip SQL 2005 out by the roots. ... to 2nd node to install work station component, ... want to take Microsoft recommended approach not to cluster SSIS but I ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL2K setup fails on 2K3 Cluster...Cant create Virtual Srvr r
    ... TS and Remote Desktop are NOT the same. ... should not interfere with the install, however, do not remote into the ... All 3 of the accounts you mention are in use ... the cluster VIP and name did get registered in the DNS table. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... However, as far a clustering SQL Server, my prior post lists the steps. ... and how many cluster resource groups for this instances. ... Install RTM SS2K and designate the node membership. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Server Clusters: Rolling Upgrades. Upgrading to Windows Server
    ... then join it back into the cluster? ... and proceeded to allow it to continue the boot process, ... I then had it boot from CD again and told it to continue the upgrade ... it said that the previous install had not completed and if you would ...
    (microsoft.public.windows.server.clustering)