SP2 on cluster mode

#1

I've got a 2-node SQL Server 2005 running. There is no sql service packs
installed and Windows 2003 service packs. the sql-cluster was built
while back. Is there a special way to install SQL SP2? Do I just install
the SP2 on each node?

Thanks in advance

#2

You will need to install SP2 starting from the current host node to update
the engine and agent. You will need to run SP2 from each node in order to
update SSIS and the client tools, just like you had to run the installer on
each node to install SSIS and client tools.

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

"Sean" <sean (AT) pleasenoemail (DOT) com> wrote

Quote:

I've got a 2-node SQL Server 2005 running. There is no sql service packs
installed and Windows 2003 service packs. the sql-cluster was built
while back. Is there a special way to install SQL SP2? Do I just install
the SP2 on each node?

Thanks in advance

#3

You will need to install SP2 starting from the current host node to update
the engine and agent. You will need to run SP2 from each node in order to
update SSIS and the client tools, just like you had to run the installer on
each node to install SSIS and client tools.

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

"Sean" <sean (AT) pleasenoemail (DOT) com> wrote

Quote:

I've got a 2-node SQL Server 2005 running. There is no sql service packs
installed and Windows 2003 service packs. the sql-cluster was built
while back. Is there a special way to install SQL SP2? Do I just install
the SP2 on each node?

Thanks in advance

#4

You will need to install SP2 starting from the current host node to update
the engine and agent. You will need to run SP2 from each node in order to
update SSIS and the client tools, just like you had to run the installer on
each node to install SSIS and client tools.

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

"Sean" <sean (AT) pleasenoemail (DOT) com> wrote

Quote:

I've got a 2-node SQL Server 2005 running. There is no sql service packs
installed and Windows 2003 service packs. the sql-cluster was built
while back. Is there a special way to install SQL SP2? Do I just install
the SP2 on each node?

Thanks in advance

#5

You will need to install SP2 starting from the current host node to update
the engine and agent. You will need to run SP2 from each node in order to
update SSIS and the client tools, just like you had to run the installer on
each node to install SSIS and client tools.

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

"Sean" <sean (AT) pleasenoemail (DOT) com> wrote

Quote:

I've got a 2-node SQL Server 2005 running. There is no sql service packs
installed and Windows 2003 service packs. the sql-cluster was built
while back. Is there a special way to install SQL SP2? Do I just install
the SP2 on each node?

Thanks in advance

#6

You will need to install SP2 starting from the current host node to update
the engine and agent. You will need to run SP2 from each node in order to
update SSIS and the client tools, just like you had to run the installer on
each node to install SSIS and client tools.

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

"Sean" <sean (AT) pleasenoemail (DOT) com> wrote

Quote:

I've got a 2-node SQL Server 2005 running. There is no sql service packs
installed and Windows 2003 service packs. the sql-cluster was built
while back. Is there a special way to install SQL SP2? Do I just install
the SP2 on each node?

Thanks in advance

#7

You will need to install SP2 starting from the current host node to update
the engine and agent. You will need to run SP2 from each node in order to
update SSIS and the client tools, just like you had to run the installer on
each node to install SSIS and client tools.

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

"Sean" <sean (AT) pleasenoemail (DOT) com> wrote

Quote:

I've got a 2-node SQL Server 2005 running. There is no sql service packs
installed and Windows 2003 service packs. the sql-cluster was built
while back. Is there a special way to install SQL SP2? Do I just install
the SP2 on each node?

Thanks in advance

#8

You will need to install SP2 starting from the current host node to update
the engine and agent. You will need to run SP2 from each node in order to
update SSIS and the client tools, just like you had to run the installer on
each node to install SSIS and client tools.

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

"Sean" <sean (AT) pleasenoemail (DOT) com> wrote

Quote:

I've got a 2-node SQL Server 2005 running. There is no sql service packs
installed and Windows 2003 service packs. the sql-cluster was built
while back. Is there a special way to install SQL SP2? Do I just install
the SP2 on each node?

Thanks in advance

#9

You will need to install SP2 starting from the current host node to update
the engine and agent. You will need to run SP2 from each node in order to
update SSIS and the client tools, just like you had to run the installer on
each node to install SSIS and client tools.

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

"Sean" <sean (AT) pleasenoemail (DOT) com> wrote

Quote:

I've got a 2-node SQL Server 2005 running. There is no sql service packs
installed and Windows 2003 service packs. the sql-cluster was built
while back. Is there a special way to install SQL SP2? Do I just install
the SP2 on each node?

Thanks in advance

#10

You will need to install SP2 starting from the current host node to update
the engine and agent. You will need to run SP2 from each node in order to
update SSIS and the client tools, just like you had to run the installer on
each node to install SSIS and client tools.

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

"Sean" <sean (AT) pleasenoemail (DOT) com> wrote

Quote:

I've got a 2-node SQL Server 2005 running. There is no sql service packs
installed and Windows 2003 service packs. the sql-cluster was built
while back. Is there a special way to install SQL SP2? Do I just install
the SP2 on each node?

Thanks in advance