According to the sp2 readme:

3.2.5 Installing SQL Server 2005 SP2 on a Failover Cluster Instance
Note the following information before you install SP2 on a failover cluster
instance:
Do not stop the cluster service before you run the SP2 Setup program, or
while the installation program is running.
Do not end any running processes before you run the SP2 Setup program.
Do not take the SQL Server service off line before you run the SP2 Setup
program. The SP2 Setup program will stop and start the SQL Server service.
Run the SP2 Setup program on the primary node of the failover cluster
instance.
You must restart all failover cluster nodes after SP2 is finished
installing.
Rolling upgrade is not supported for SP2.

I just want to make sure this is all I really have to do? I've read
elsewhere that non-cluster-aware SQL components like Workstation
Components/SMS will not be updated on the passive server unless I run sp2 on
that server after running it on the active node?

I want to get this right the first time!

Go ahead and run the install as written. You may have to hand-patch the
non-clustered components after the main install, but that is OK.


--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"geekyguy" <geeky (AT) guy (DOT) com> wrote

Go ahead and run the install as written. You may have to hand-patch the
non-clustered components after the main install, but that is OK.


--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"geekyguy" <geeky (AT) guy (DOT) com> wrote

Go ahead and run the install as written. You may have to hand-patch the
non-clustered components after the main install, but that is OK.


--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"geekyguy" <geeky (AT) guy (DOT) com> wrote

Go ahead and run the install as written. You may have to hand-patch the
non-clustered components after the main install, but that is OK.


--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"geekyguy" <geeky (AT) guy (DOT) com> wrote

Go ahead and run the install as written. You may have to hand-patch the
non-clustered components after the main install, but that is OK.


--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"geekyguy" <geeky (AT) guy (DOT) com> wrote

Go ahead and run the install as written. You may have to hand-patch the
non-clustered components after the main install, but that is OK.


--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"geekyguy" <geeky (AT) guy (DOT) com> wrote

Go ahead and run the install as written. You may have to hand-patch the
non-clustered components after the main install, but that is OK.


--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"geekyguy" <geeky (AT) guy (DOT) com> wrote

Go ahead and run the install as written. You may have to hand-patch the
non-clustered components after the main install, but that is OK.


--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"geekyguy" <geeky (AT) guy (DOT) com> wrote

Go ahead and run the install as written. You may have to hand-patch the
non-clustered components after the main install, but that is OK.


--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP


"geekyguy" <geeky (AT) guy (DOT) com> wrote