SQL Server 2005 SP3 through Microsoft Update now supports clustering


On March 24th, we revised the SQL Server 2005 Service Pack 3 Microsoft Update logic to offer when a clustered instance is detected. When the logic was originally released, the logic would not offer if an instance was detected to be clustered.


Since the SQL Server 2005 Service Pack still requires credentials to launch the process on the PASSIVE node, the update needs to run in attended or user interface mode. You should scan the ACTIVE node first and then the PASSIVE node for applicability of the service pack . When the update runs on the ACTIVE node it is expected to patch the ACTIVE node and PASSIVE instances. We recommend scanning the PASSIVE node for applicability of the service pack to ensure all component have been update to the service pack.

Comments (5)

  1. Starting today March 24 2009, customers will now be able to install SQL Server 2005 SP3 through MU on

  2. robwestseattle says:

    Don’t the last two sentences conflict?

    "You should run the update on the ACTIVE node first and then run on the PASSIVE node afterwords to ensure all components are fully patched."

    "When the service pack is run on the ACTIVE node it will automatically patch the PASSIVE instance."

    Or maybe there should be a final paragraph, like this: "When you run the patch on the ACTIVE node it will attempt to automatically patch the PASSIVE node.  However, it might fail to completely patch the PASSIVE node.  That is why we recommend installing the patch on the PASSIVE node afterwords."

  3. petersad says:

    I revised the wording some. I wanted to be clear on recommended procedure through Microsoft Update.

  4. uttam_parui@hotmail.com says:

    robwestseattle,

    When you run the SP3 on the active node, it will create a Task Scheduler task on the passive node with the command and parameters to install on the second node. If the SP3 setup fails on the passive node, the the full SP3 setup is supposed to roll back. By default, you cannot install SP3 on the passive node afterwards. You will once again have to run SP3 from the active node. But if you want to install SP3 only on the passive node then you can install it from the command line using the /passive switch.See http://support.microsoft.com/kb/934749 for more details.

    Hope this clears this up a bit.

    Thanks,

    Uttam