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

An AD issue would explain the problems. Personally, I have my DB servers in
their own OU, mainly to keep overly restrictive group policies from being
applied. You may want to try this approach if your networking people agree.

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

"KMcDermott" <KMcDermott@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ECF0B89B-6679-4DBE-9BB9-833ADD3F9334@xxxxxxxxxxxxxxxx
> Geoff...
>
> While rebooting Node1, the same thing happened with the network
> connectivity
> loss.
>
> As well, the freshly re-built Node02 (new name) lost connectivity after
> adding to the AD domain, only this time I can't get in at all... domain or
> local accounts.
>
> I've succumbed to the likliehood that it's an AD / GPO problem now, as I
> can
> PING the box successfully until the Windows startup changes from PREPARING
> NETWORK CONNECTIONS to APPLYING COMPUTER SETTINGS, then it dies
> (DESTINATION
> HOST UNREACHABLE).
>
> Thanks again for all of your assistance & Guidance.
>
> In case you want to follow where we go with this, the new thread I've
> started in the 2003 AD forum is
> http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.windows.server.active_directory
>
> Regards,
> Kevin
>
> "Geoff N. Hiten" wrote:
>
>> You are referring to a CLUSTER.EXE command option. I am referring to the
>> SQL installer procedure that removes node 2 from the SQL installation
>> information store. Even if you evict node 2, SQL still thinks it is is a
>> valid node for the SQL instance. You have to run the SQL installer on
>> node
>> 1 and remove node 2. This is all detailed in BOL under Maintaining a
>> Failover Cluster | Removing a node from an existing Failover cluster.
>> Until
>> this is done, you cannot apply a service pack or add the node back to the
>> SQL virtual server. SQL thinks the node still exists and tries to update
>> the local binaries, even ifthe node has been evicted from the cluster.
>>
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>> "KMcDermott" <KMcDermott@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:4C36D14B-4874-4633-9B01-3B603FAFBC6E@xxxxxxxxxxxxxxxx
>> > By CLEAN do you mean CLUSTER NODE NODE2 /FORCECLEANUP ??
>> >
>> > "Geoff N. Hiten" wrote:
>> >
>> >> Make sure and run the SQL install to clean Node 2 from the SQL
>> >> installation
>> >> or you will not be able to install SQL to the replacement node later
>> >> on.
>> >> It
>> >> will fuss that it cannot find the target node, but it still has to run
>> >> to
>> >> clean out references to it from the working node(s).
>> >>
>> >> --
>> >> Geoff N. Hiten
>> >> Senior Database Administrator
>> >> Microsoft SQL Server MVP
>> >>
>> >> "KMcDermott" <KMcDermott@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> news:C075B8D7-D64A-4BA8-86E1-BB4E06DEC7B5@xxxxxxxxxxxxxxxx
>> >> > Have evicted node2 from the cluster but unable to run cleanup as the
>> >> > network
>> >> > cannot see it, and it cannot see any other machines. Have removed
>> >> > node2
>> >> > from
>> >> > AD, and am rebuilding it from scratch.
>> >> >
>> >> > Will see what happens.
>> >> >
>> >> > Thanks very much for all of your assistance & suggestions
>> >> > throughout.
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>


.

Relevant Pages

  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SQL Clustering Active/Active Problem.
    ... I tried through the SQL Installer through steps: ... Install SQL Server 2000 Components ->Install Database Server ... possible owners will not work. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
    (microsoft.public.windows.server.sbs)