473,725 Members | 2,020 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL Server 2000 Failover Cluster upgrade to SQL Server 2005

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)
database that it finds on the server.

When I ckeck the install details it tells me that
"Your upgrade is blocked becuase of cluster upgrade rules"

I have tried searching the MS site but none of the entries I found
appear to apply.

Any ideas?

-- Mark D Powell --
Sep 6 '08 #1
3 4148
Mark D Powell (Ma*********@ed s.com) writes:
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)
database that it finds on the server.

When I ckeck the install details it tells me that
"Your upgrade is blocked becuase of cluster upgrade rules"

I have tried searching the MS site but none of the entries I found
appear to apply.

Any ideas?
Exactly when do you get this error? And do you have a cluster in the first
place?

I have not run that many upgrades (if any at all) to SQL 2005, but do you
really select which *database* to upgrade? The upgrade is per instance,
as far as I know.

In any case, it may be simpler to install a new server instance rather
than upgrading, not the least on a cluster.

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Sep 6 '08 #2
On Sep 6, 5:37*am, Erland Sommarskog <esq...@sommars kog.sewrote:
Mark D Powell (Mark.Pow...@ed s.com) writes:
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)
database that it finds on the server.
When I ckeck the install details it tells me that
"Your upgrade is blocked becuase of cluster upgrade rules"
I have tried searching the MS site but none of the entries I found
appear to apply.
Any ideas?

Exactly when do you get this error? And do you have a cluster in the first
place?

I have not run that many upgrades (if any at all) to SQL 2005, but do you
really select which *database* to upgrade? The upgrade is per instance,
as far as I know.

In any case, it may be simpler to install a new server instance rather
than upgrading, not the least on a cluster.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarsk og.se

Links for SQL Server Books Online:
SQL 2008:http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005:http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000:http://www.microsoft.com/sql/prodinf...ons/books.mspx
I figured the probme out. I apparently missed the check box where you
have to tell it you are on a cluster even though when it runs the pre-
install checks it finds both nodes and runs the checks on them.

I have a new problem after performing the upgrade, applying SP2, and
then hot fix pack 7 in that the SQL Agent will no longer run.
Searching on SQL Server Agent (Agent XP Disabled) found me 3 potential
fixes.

1- use sp_configure to enable routines
2- http://technet.microsoft.com/en-us/l.../ms190730.aspx --
verify ID has privilege to page lock
3- http://support.microsoft.com/kb/943525
-- change Id to non-domain administrator Id

Item 1 did not fix the issue, item 2 was already true, so item 3.
Jobs run but now 1/3 of my jobs which all obtain data from Oracle are
failing with an invalid user/password. The link connects to Oracle
with a different Id depending on who uses it but all the jobs are
being ran by the Id that used to run the agent. I do not know if that
is a change from the upgrade or if this was always true. I manually
tested the id/passwords from the server but what passwords are in use
in the link are hidden. Still it should not have changed since it was
working prior to the upgrade.

-- Mark D Powell --

Sep 6 '08 #3
On Sep 6, 3:16*pm, Mark D Powell <Mark.Pow...@ed s.comwrote:
On Sep 6, 5:37*am, Erland Sommarskog <esq...@sommars kog.sewrote:


Mark D Powell (Mark.Pow...@ed s.com) writes:
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)
database that it finds on the server.
When I ckeck the install details it tells me that
"Your upgrade is blocked becuase of cluster upgrade rules"
I have tried searching the MS site but none of the entries I found
appear to apply.
Any ideas?
Exactly when do you get this error? And do you have a cluster in the first
place?
I have not run that many upgrades (if any at all) to SQL 2005, but do you
really select which *database* to upgrade? The upgrade is per instance,
as far as I know.
In any case, it may be simpler to install a new server instance rather
than upgrading, not the least on a cluster.
--
Erland Sommarskog, SQL Server MVP, esq...@sommarsk og.se
Links for SQL Server Books Online:
SQL 2008:http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005:http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000:http://www.microsoft.com/sql/prodinf...ons/books.mspx

I figured the probme out. *I apparently missed the check box where you
have to tell it you are on a cluster even though when it runs the pre-
install checks it finds both nodes and runs the checks on them.

I have a new problem after performing the upgrade, applying SP2, and
then hot fix pack 7 in that the SQL Agent will no longer run.
Searching on SQL Server Agent (Agent XP Disabled) found me 3 potential
fixes.

1- * use sp_configure to enable routines
2-http://technet.microso ft.com/en-us/library/ms190730.aspx* * *--
verify ID has privilege to page lock
3-http://support.microso ft.com/kb/943525
-- *change Id to non-domain administrator Id

Item 1 did not fix the issue, item 2 was already true, so item 3.
Jobs run but now 1/3 of my jobs which all obtain data from Oracle are
failing with an invalid user/password. *The link connects to Oracle
with a different Id depending on who uses it but all the jobs are
being ran by the Id that used to run the agent. *I do not know if that
is a change from the upgrade or if this was always true. *I manually
tested the id/passwords from the server but what passwords are in use
in the link are hidden. *Still it should not have changed since it was
working prior to the upgrade.

-- Mark D Powell --- Hide quoted text -

- Show quoted text -
To get the sqlagent to run we changed the connection to run as a local
system account instead of a domain user. The jobs that reference the
link to Oracle would then fail.

Then I dropped and re-created the link to Oracle. The jobs then
resumed working,

-- Mark D Powell --
Sep 8 '08 #4

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

Similar topics

4
2228
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 server must support the following: - 600+ users using various ASP.Net based applications, only 2 currently but growing over time as old legacy apps are converted; - Some applications are mission critical, others not so much; - DB back-end is a...
1
3035
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 database and our application database. When the SQL Server cluster is failed-over, any "pointers" to the live connections stored in the connection pool are made invalid. When the application tries to reference these "damaged" connections, it throws...
5
3107
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 dual path from each node but we dont need that. The current setup has two completly seperate paths. hba on node 1 to controller A on DS400 and hba on node 2 to controller B. If i take a controller offline, failover works fine to jumo to other...
1
2428
by: Mark D Powell | last post by:
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...
14
3033
by: Developer | last post by:
Hello All, i have recently installed VS2005 and was trying to install SQL sever 2000. I have Win XP' SP2. But when I tried installing, it only installed client tools and not the database. Can anyone please help me with this as I want to install SQL server and also wouold be grateful, if you can suggest me any workaround to dealwith this problem.(Like should I install any new OS etc). Any help would be appreciated.
2
2679
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 document which can help us do that? Thanks. -jay
4
2845
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. Now arises the problem of how to synchronize the servers in the shortest interval (synchronize databases that is). I'm not sure that merge or peer-to-peer replication in sql 2005 is the best solution for synchronization (because it still has a...
1
1814
by: Mark D Powell | last post by:
I have installed Analysis Server (AS) and Reporting Services (RS) on SQL Server 2000 before. Now I have been asked to install these on a failover Cluster we have. Previously I just ran the SQL Server 2000 install program off our network disk and then ran the SP4 patch to install AS. When I ran the install and chose AS there was no indication from the software that it recogned that I wanted it to install on a cluster. After it said it...
1
4510
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 cannot not reinstall sql server (or failover). Failover fails because the sql server resources are not owned by the rebuilt node. There is no option to add in the new node as a possible owner because the rebuilt node does not exist in the modify...
0
8886
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9401
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9104
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8090
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6010
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4509
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4780
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3217
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2632
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.