Link to home
Start Free TrialLog in
Avatar of towo2002
towo2002

asked on

Do I need to install SQL Server 2005 SP3 on both cluster nodes

Dear all experts,

I just install SQL Server 2005 cluster (Active /Passive) in my environment.  Just wonder do I need to install SP3 on both nodes or it will help me to apply SP3 on both nodes automatically?  As I remember that in earlier version of SQL Server, I've to install service pack on both nodes.  But now when I type select @@version on both nodes, it both returns 9.00.4035.00 (X64).

Please kindly advise
Avatar of RiteshShah
RiteshShah
Flag of India image

you have to install SP3 on both node.
Avatar of towo2002
towo2002

ASKER

Hi RiteshShah,

Thanks for your quick response.  When I install SP3 on the other nodes, it just highlight reporting service for me to update, the rest of component (like database, native client, xml, etc...) were not selected.  Do I still go ahead for the installation or simply select all then start the installation?

Thanks,
ASKER CERTIFIED SOLUTION
Avatar of r_panos
r_panos

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial