I thought of opening a new thread, so it does not get overlooked..

So my problem is that I can't install sp3a on a virtual SQL 2000 server, installed on a Windwos 2003 cluster

I have preinstalled MSDTC as a clustered app (according to Q301600) so I guess the install of SQL just skips it, because it detects it as being already there. So all MSDTC resources are there. SQL 2000 installs fine on a 2-node cluster win 2003. But when I try to apply sp3 for SQL 2000 it fails with "Setup failed to perform required operations on cluster nodes" and in the sqlsp0.log I see something like

Error running script: repltran.sql (1

-or

12:29:16 Setup is installing the Microsoft Full-Text Search Engine ..
12:29:16 "C:\sql2ksp3\x86\FullText\MSSearch\Search\SearchSt p.exe" /s /a:SQLServer$INST
the above being the last line in the lo

Is it a propper sequence of installing SQL 2000 sp3 on a Windows 2003 cluster

I just want to mention I have read and tryied all of the following KB docs: Q815431, 309398, 318672, 321063, 815430, 301600, 811168

Thanks for your help, Jason

That doesnt sound like a GeoCluster problem.

The only thing that GC does it split the shared storage underneath the
cluster

- in a regular cluster, you define a shared-disk resource (call it drive
X and then when you install, SQL will select from the available clustered
drives (which here will be X)
- in a cluster with GC, you define a replicated-disk resource (call it
drive X and then when you install, SQL will select from the available
clustered drives (which here will be X)

Past that, everything is how you install SQL. Literally, no other
differences.

jason


"suzana ciur" <anonymous (AT) discussions (DOT) microsoft.com> wrote

already there. So all MSDTC resources are there. SQL 2000 installs fine on a
2-node cluster win 2003. But when I try to apply sp3 for SQL 2000 it fails
with "Setup failed to perform required operations on cluster nodes" and in
the sqlsp0.log I see something like: