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: 601b7899f22fa8952a10ccb8ff 42853e
Additional Information 3: b2ce
Additional Information 4: 4624f576650d42293d0f513f05 9b4f13
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.
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: 601b7899f22fa8952a10ccb8ff
Additional Information 3: b2ce
Additional Information 4: 4624f576650d42293d0f513f05
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.
Hi,
see related PAQ here:
https://www.experts-exchange.com/questions/24520772/SQL-Server-2005-SP3-upgrade-fails-with-Error-11009-No-passive-nodes-were-successfully-patched.html?cid=780
and pls give current sql/os versions
see related PAQ here:
https://www.experts-exchange.com/questions/24520772/SQL-Server-2005-SP3-upgrade-fails-with-Error-11009-No-passive-nodes-were-successfully-patched.html?cid=780
and pls give current sql/os versions
ASKER
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Open a case with microsoft and solved it.
ASKER
Please help.