Solved

MS08-040 Security Patch on a Microsoft Windows 2003 Cluster Running MS SQL 2000 SP4

Posted on 2008-10-24
7
732 Views
Last Modified: 2012-05-05
I am trying to find out about this patch. I need to know if the hotfixes for this are cluster aware
The vulnerability numbers are 948110, 948111

Where can I find offical documentation about installation and cluster awareness? I also need to read about deployment methods etc.

Thanks for your help
0
Comment
Question by:bbcac
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 22

Expert Comment

by:65td
ID: 22805633
Patch 948110 is for SQL 2000 and pllies to windows 2000 advanced and windows 2003 enterprise (cluster OS).
http://support.microsoft.com/kb/948110

948111 appies to OS windows 2000 advanced.
http://support.microsoft.com/kb/948111/en-us
0
 

Author Comment

by:bbcac
ID: 22805793
great... thanks.... any help with the "cluster awareness" part? I need to find about wheather this patch is cluster aware.

0
 
LVL 22

Expert Comment

by:65td
ID: 22812238

The patch needs to be installed on each node of the cluster.
I would say the patch is not cluster aware but patches cluster OS's and applications.
So passive node first, move groups, patch new passive, not necessarily the same day, may want to review / test the patch first.
0
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

 

Author Comment

by:bbcac
ID: 22812712
This is any SQL patch though... I have read on EE that SQL patches are applied to the Virtual cluster name, and both nodes are patched.
0
 
LVL 22

Expert Comment

by:65td
ID: 22813403
I don't know it may work
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 22817029
This (http:/Q_23823918.html) was a discussion for patching SQL 2005 I was recently in.  As I understand it, the same things sort of apply to SQL 2000.

There are cluster aware portions of SQL and non-cluster aware portions.

It might give you some of the guidance in trying to figure out what is done depending on the patch.

0
 

Accepted Solution

by:
bbcac earned 0 total points
ID: 22841475
I placed a call to microsoft support. The patch is cluster aware. You patch the active node and both servers are then patched.

The patch requires a reboot if any of the files are locked during the time of install. The SQL server supposedly continues running fine unitl next reboot however.

0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question