Wednesday, June 3, 2009

Install/add components after Service Pack installation

For example, at the initial installation, you installed everything EXCEPT Integration Services (IS).
Later, you applied SQL 2005 Service Pack 2.
And today, you decided to install IS component.

What to do?
Rerun SQL installation, ignore warning/suggestion about running setup using SKUUPGRADE parameter.
Select/check IS component.
Finish install.
Re-apply SP2 (SP install procedure will let you choose component to update).

No comments:

Post a Comment