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

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: setup is not running
    ... You are using SQL 2000 edition right? ... When I run setup SQL after 2 seconds ... > choose "Virtual server" to install SQL na Cluster. ... > installation necessary on clusetr with Windows 2003 Enterprise Edition ...
    (microsoft.public.sqlserver.clustering)
  • Re: 4 Queries about DB clustering
    ... multi-instance cluster ... > I support the Professional Association for SQL Server ... The installer writes the executable files to each host node ... > you choose as part of the installation. ...
    (microsoft.public.sqlserver.clustering)
  • Re: ..newbie.. cluster multi-istance..
    ... In your situation, with only a 2-node cluster, running Standard Edition, ... group with an existing dedicated shared disk resource. ... but different installation paths will be chosen for each ... You wouldn't want to run your database files from the same SAN ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2000 Problems on One Node Only
    ... Since it is a setup error, there will be a setup log file in the windows ... Installation of a named instance of SQL Server 2000 virtual server on a ... Windows 2003-based cluster fails ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Migrating stand-alone SQL server to cluster
    ... applying binaries on one node in a virtual installation. ... The problem is that if you try to reapply the service pack as you would a ... Mixed Cluster configuration that caused our problems. ... This will reinstall SQL Server on the new ...
    (microsoft.public.sqlserver.clustering)