Re: Is it necessary to do a Service Pack reinstall after changing or adding new software or hardware components?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

It's not a cluster issue. This happens on standalone servers. It all has
to do with versioning. Software installs can and do put down older versions
of drivers or components which are not patched. Hardware does the same with
drivers. After installing or uninstalling hardware or software to a system,
you should always reapply service packs and hot fixes to ensure that
everything is at the correct patch level. Doesn't matter if it is a cluster
or not.

--
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com


"Sean" <spowell71@xxxxxxxxxxx> wrote in message
news:1136903278.100563.8350@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
In: Clustered SQL Server do's, don'ts, and basic warnings
http://support.microsoft.com/default.aspx?scid=kb;en-us;254321
In Section: Important cluster service administrative rules.
"Warning If you ignore any of the following rules, you will need to
reinstall Microsoft Cluster Service.
·If you change or add new software or hardware components to your
system after you install SQL Server Service Pack 3, you must reinstall
Service Pack 3 or your current Windows NT service pack again."

My eyes almost popped out when I saw this. Can this be right, I am
reading this right? This KB article does not cover Windows 2003 and SQL
SP4, does this KB apply to this platform?
T
his issue came up during a production incident were after we
uninstalled Symantec Norton Antivirus (SAV) our SQL Server Replication
broke. We started getting DCOM errors because the ATL71.dll had been
removed from the cluster nodes. We took a shot in the dark and
reapplied the SP4 and it fixed it. During a postmortem, I came across
this section in the KB. An article that t I have read many times before
but the importance of the above quote had never register in my mind.


.

Relevant Pages

  • Re: Is it necessary to do a Service Pack reinstall after changing or adding new software or hardware
    ... our NT team did test the uninstall on a standalone server ... > It's not a cluster issue. ... > system after you install SQL Server Service Pack 3, ...
    (microsoft.public.sqlserver.clustering)
  • SQL Server 2005 cluster duplicated data
    ... Our cluster is not yet running Service Pack 2. ... SQL Server cluster? ...
    (microsoft.public.sqlserver.clustering)
  • Re: Printer Cluster Error trying to add printers
    ... Windows Printing Team ... SETUP HAS DETECTED THAT THE SERVICE PACK VERISON OF THIS SYSTEM IS NEWER ... I am still not able to add printer to cluster. ... add a printer to a virtual server that is part of a Windows Server 2003 ...
    (microsoft.public.windows.server.clustering)
  • Re: SQL Server 2005 Cluster Install
    ... clustered data server. ... Microsoft SQL Server 2005 Notification Services ... Failover Cluster ... Setup installs management tools only on the primary node of a failover ...
    (microsoft.public.sqlserver.setup)
  • Re: Printer Cluster Error trying to add printers
    ... Can you add a printer using a driver that ships with Server 2003? ... SETUP HAS DETECTED THAT THE SERVICE PACK VERISON OF THIS SYSTEM IS NEWER ... I am still not able to add printer to cluster. ... MVP - Windows Server - Clustering ...
    (microsoft.public.windows.server.clustering)