Results 1 to 9 of 9
  1. #1
    Join Date
    Nov 2007
    Posts
    7

    Unanswered: Applying a Hotfix to a failover Cluster

    Hi. Was hoping to get some advice on applying a hotfix to a SQL Server 2005 failover Cluster.

    The hotfix I am applying (KB933508) relates to a Maintenance Plans issue with Server 2005 Service Pack 2. During installation I'm advised that unless the SQL Server and other services are stopped a reboot will be required, although I can still install the hotfix. However the installation is failing. There are error details in the relevant logs created in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix to the effect that the 'Debug' value in registry key 'Software\Policies\Microsoft\Windows\Installer' can't be read and that SQL Server was unable to add a user (the account under which SQL Server Agent and Analysis Services run) to a local group (the domain group in which SQL Server logins are contained).

    Is this something simple like explicitly shutting down the services first before applying the hotfix or is there something else going on?

    Regards,

    YaHozna

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    I think you need to work on your Google skills. I searched on
    debug Software\Policies\Microsoft\Windows\Installer 2005
    and found 1220 results. The first few could easily address your problem, which BTW is not sql server related.

    -- This is all just a Figment of my Imagination --

  3. #3
    Join Date
    Nov 2007
    Posts
    7

    Angry Response to question

    Hi. There are two ways in which you could have responded to my question.

    The first would have been to say: "If you search for the terms 'debug' and 'Software\Policies\Microsoft\Windows\Installer 2005' in Google it will return quite a few results that may well be useful. At first glance it doesn't look like a SQL Server problem."

    The second way is the way you responded. 'Thanks'.

    YaHozna.

  4. #4
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Nope ... there is a third way. I could have ignored it. Consider it done!.

    -- This is all just a Figment of my Imagination --

  5. #5
    Join Date
    Nov 2007
    Posts
    7
    "Arrogance diminishes wisdom"

  6. #6
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    and those who recieve gifts of horses should not look in their mouths.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    People in glass houses should not walk around naked.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  8. #8
    Join Date
    Nov 2007
    Posts
    7
    Only when one has been sold cruelly short by Mother Nature

  9. #9
    Join Date
    Feb 2004
    Location
    Burbank & Santa Cruz de la Sierra
    Posts
    3,716
    Quote Originally Posted by YaHozna
    "Arrogance diminishes wisdom"
    Cool! a quote-wrestling match!

    "Too many young people itch for what they want without scratching for it."
    aka "Paul"
    Non est ei similis.

    I just read "100 Things To Do Before You Die". I was surprised that "Yell for help!!" wasn't one of them

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •