SQL Server 2005 Service Pack 2

Hi All,

first of all thank you very much for your help!
I have two questions

I have a SQL Server 2005 on a Windows 2003 failover cluster. Both nods
are without Service Pack and I want to upgrate them to SP2 but I'm not
able to find a guide to understand if i have to run the setup on both
nodes or only on the active one.

The second question is: after the installation of the Service Pack, if
one node crashes, when I re-join it to the cluster, do I have to
reinstall SQL 2005 plus Service Pack 2 on this node or only SQL 2005?

Thanks
.

Relevant Pages

  • Re: IIS Virtual Directory Management for SQL Server
    ... There is no special requirements for a specific service pack for Windows ... For SQL 2000, you should have SP3 with you. ... >> I got the IIS Virtual Directory Management for SQL Server working but I ...
    (microsoft.public.sqlserver.xml)
  • Will the correct DTCSetup.exe version please stand up?
    ... I'm trying to rebuild MS DTC services on an SQL 2000 ... server located on a Windows NT 4.0 server. ... MSDTC setup on the SQL Server Service Pack 2 CD in the \x86 ...
    (microsoft.public.sqlserver.setup)
  • Re: Stuck at Cluster Network Configuration Wizard
    ... It should ask for the SQL VIP. ... Network settings for this failover cluster). ... identify your failover cluster instance on the network. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Stuck at Cluster Network Configuration Wizard
    ... SQL setup can see the nics (they are listed on this screen under 'Specify ... Network settings for this failover cluster). ... Principal SQL Infrastructure Consultant ...
    (microsoft.public.sqlserver.clustering)
  • Will the real DTCsetup.exe version please stand up?
    ... I'm trying to rebuild MS DTC services on an SQL 2000 ... server located on a Windows NT 4.0 server. ... MSDTC setup on the SQL Server Service Pack 2 CD in the \x86 ...
    (microsoft.public.sqlserver.server)