update hotfix 3024 for SQL Server Database Services 2005?

  • While instaling failover instance on w2k3(sp2) iam getting update hotfix 3024 error.

    This means should I apply any hotfix befor installing failoverinstance?

    and also iam not upgrading anything.I installed sql2k5 EE as first instance n iam trying to install 2nd failover instance. Eventhough Iam not upgrading , in System configuration check it giving me edition change warning

    Error String : The setup has encountered an error while Upgrading Components. The error: -2147019873

    Error message: The group or resource is not in the correct state to perform the requested operation.

    Error Number : 29550

    Product: Microsoft SQL Server 2005 (64-bit) - Update 'Hotfix 3024 for SQL Server Database Services 2005 (64-bit) ENU (KB000000)' could not be installed. Error code 1603

    What will be the best solution?

  • I haven't seen this before. My guess is that you didn't complete something on the first instance that was installed. Did you install any hotfixes or patches on that first node?

  • Thanks Steve,

    I applied only sp2. I did not applied any cumulative update.

    Do you want me to apply the cumulative update. If that is the reason. could you please tell me the best cumulative update?

    or you want me to check the windows level hotfix. We are using windows 2003 x-64 and applied SP2,

    But Iam not sure whether any hot fixes are applied the system Admin?

    the update hotfix 3024 is for windows 2003?

  • I'm having exactly the same problem and using the same scenario - I'm installing a 2nd failover named instance and I'm using Windows Server 2003 R2 Enterprise x64 MSCS 4 node cluster. Any help greatly appreciated...

  • Hi, I resolved the problem as follows:

    On all of the MCSC nodes search in the registry HKLM for "Hotfix 3204" omitting the quotes - look for the key "Uninstallabe" and change the dword value from 0 to 1.

    All the usual registry provisos apply ie back up your registry before you do this.

    This worked for me..

  • Did you able to solve this problem. We have same problem.

  • Hi. ive got the same problem, but in my register, i cant find that key.

    Can anybody help me, please?

    Thank you.

  • I am also having same problem. trying to add another named instance (2K5). Currently I have few other instances(2K5) with SP3 CU10.

    Product: Microsoft SQL Server 2005 (64-bit) - Update 'Hotfix 3024 for SQL Server Database Services 2005 (64-bit) ENU (KB000000)' could not be installed. Error code 1603. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files

    Any solutions? Thanks

  • Could this be related to Windows KB 937444? This fix is required for Filestream to work with a SQL 2008 cluster on W2003, but may have other benefits to SQL 2005.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply