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
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
you have to install SP3 on both node.
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,
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.