Link to home
Start Free TrialLog in
Avatar of Hooznext
Hooznext

asked on

SQL Server 2005 SP4 upgrade fails with Error 11009 - No passive nodes were successfully patched

I've tried the following the instructions below, I can't seem to install either SP3 or SP4.

I get the following error

Unexpected Error Occured.

The Hotfix Installer Crashes

Problem signature:
  Problem Event Name:    APPCRASH
  Application Name:    hotfix.exe
  Application Version:    1.4.1581.0
  Application Timestamp:    4a44d1d7
  Fault Module Name:    hotfix.exe
  Fault Module Version:    1.4.1581.0
  Fault Module Timestamp:    4a44d1d7
  Exception Code:    c0000005
  Exception Offset:    000000000003cfdc
  OS Version:    6.0.6002.2.2.0.274.10
  Locale ID:    1033
  Additional Information 1:    deec
  Additional Information 2:    601b7899f22fa8952a10ccb8ff42853e
  Additional Information 3:    b2ce
  Additional Information 4:    4624f576650d42293d0f513f059b4f13


Followed these Instructions
------------------------------------------
Step 1. Ensure you are logged onto your Passive Node with the Domain Admin Account.

Step 2. Go to DOS and execute the SP3.exe update with the "/passive" command.  - This will launch the installation and should now by-pass the Cluster check and you shouldn't receive the 11009 Error message.  

Step 3. Once the Installation is completed your passive node should re-boot, now go to your Active Node.

Step 4. On the Active Node - open failover clustering and Pause the Passive Node and stop the SQL Services on the Active node.

Step 5. Ensure your Services are configured in Step 2.  and launch the SP3 Update.exe. - Allow the installation to complete (it will probably ask for a reboot do not reboot yet).

Step 6. Un-Pause the Passive Node in the cluster, restart your SQL Services. then Reboot the Active Node.
Avatar of Hooznext
Hooznext

ASKER

I was able to get the active node done, however the passive node I get that error still.
Please help.
I have tried said instructions and get the error listed in post. I'm running Server 2008 SP2 with SQL 2005 SP2. I've managed to post one node to SP4.
ASKER CERTIFIED SOLUTION
Avatar of Hooznext
Hooznext

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
Open a case with microsoft and solved it.