473,241 Members | 1,545 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,241 software developers and data experts.

Upgrade SQL Server 2000 Failover Cluster from SP3 to SP4

I have a production failover cluster running SQL Server 2000 at SP3
that I want to upgrade to SP4. I do not have a test failover cluster
to test with so I need the install on the primary server to work the
first time. Per the information I have I just install the patch on the
primary server and it will install both on the primary and on the
secondary.

However, I remember when I did the initial install and it failed. The
first problem traced to the fact that the install uses temporary files
under the profile of the installing administrator and the id had never
logged into the second server so the install failed on creating the
temporary file. The was a second problem that related to an OS feature
that had to be off for the install to work.

If anyone out there has done this upgrade and remembers encountering a
problem and its fix/workaround I would appreciate a head up warning.

Thank you
-- Mark D Powell --

Sep 6 '06 #1
1 2406

Mark D Powell wrote:
I have a production failover cluster running SQL Server 2000 at SP3
that I want to upgrade to SP4. I do not have a test failover cluster
to test with so I need the install on the primary server to work the
first time. Per the information I have I just install the patch on the
primary server and it will install both on the primary and on the
secondary.

However, I remember when I did the initial install and it failed. The
first problem traced to the fact that the install uses temporary files
under the profile of the installing administrator and the id had never
logged into the second server so the install failed on creating the
temporary file. The was a second problem that related to an OS feature
that had to be off for the install to work.

If anyone out there has done this upgrade and remembers encountering a
problem and its fix/workaround I would appreciate a head up warning.

Thank you
-- Mark D Powell --
Followup. The SP4 patch installed without a hitch though unlike on the
prior Standard editon upgrades I did where you were shown screens that
stated what was being done: update MDAC etc..., all that came up was a
blue screen with a message about checking on the cluster and this might
take a while. After a 'while' the message changed to something about
creating cluster resources then the finished screen appeared saying it
was time to reboot.

-- Mark D Powell --

Sep 13 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Fredrik Möller | last post by:
Hi all, I need help in solving a connection problem. There is a failover cluster running SQL Server 2000 in to instances, 'AUTUMN-03' and 'WINTER-03\I1'. On an other machine I run a service,...
0
by: jwbeaty | last post by:
Is there a method to determine if a cluster has failed over via data stored in SQL Server? I'm looking for a method to determine if a failover has occurred by running a script of some sort (i.e....
4
by: Chris Gatto | last post by:
Hello, My organization is currently considering the purchase of a new intranet application server and we are looking for opinions from those who have been down this road before. In brief the...
1
by: news.microsoft.com | last post by:
Is there an elegant way to clear out the ADO connection pool used by the SQL Server State Service following a cluster failover? We are using a SQL Cluster to store both the ASP Session State...
5
by: uspensky | last post by:
We are trying to setup a system to system failover cluster using two nodes (x346) which each have a single hba running to seperate controllers on the DS400. For full redundnancy, IBM recommends...
2
by: Jay Balapa | last post by:
Hello, We have two Windows 2003 servers one running IIS and another for SQL Server. We are at a stage where we need to load balance and provide a failover. Can you show us a technical...
4
by: Ronald Green | last post by:
Hi, I have this theoretical problem: Say that I need a chat server that also has a database where it saves all conversations. However, I need several servers for availability and load balancing....
3
by: Mark D Powell | last post by:
I attempted to upgrade my SQL Server 2000 Enterprise Edition (32 bit) to SQL Severer 2005 EE 32 bit and while the prereqs passed the installer will not let me select the version 8.00.x (2000 SP4)...
1
by: snomad | last post by:
Hi all, I had a node failure and rebuild on a sql server 2005 2 node cluster. the server has been rebuilt with new os. i evicted then re-added the rebuilt node via cluster administrator. i...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.