Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Clustering / June 2005

Tip: Looking for answers? Try searching our database.

Single Node Cluster Upgrade

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Inspiron9300 - 24 Jun 2005 20:53 GMT
We have a SQL 2k Single Node Cluster that we are adding a Passive node
to. We have installed everything but are having issues installing SP3a
on the Passive node. The Active Node has SP3a already installed. We get
an error stating "All cluster disks available to this virtual server
are owned by other node(s)". We rolled the cluster to the passive node
and got SQL Group Errors. Any ideas?
Cheers,
John
Rodney R. Fournier [MVP] - 24 Jun 2005 21:14 GMT
Sounds like a problem with either the drive letter assignments on the new
node or its configuration in general. Can the new node control all the
disks?

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog

> We have a SQL 2k Single Node Cluster that we are adding a Passive node
> to. We have installed everything but are having issues installing SP3a
[quoted text clipped - 4 lines]
> Cheers,
> John
Mike Epprecht \(SQL MVP\) - 24 Jun 2005 21:22 GMT
Hi

You get the same  "All cluster disks available to this virtual server are
owned by other node(s)".  with SP4 also (not really a problem), BUT, the
fact that you can not fail the instance over to the new cluster is your
problem.

Once you fix that, the SP will install.

As Rodney mentioned, make sure that the resources can be owned by the other
node.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

> Sounds like a problem with either the drive letter assignments on the new
> node or its configuration in general. Can the new node control all the
[quoted text clipped - 16 lines]
>> Cheers,
>> John
Inspiron9300 - 24 Jun 2005 22:01 GMT
It sees them all. They are obviously listed as unavailable since its
passive. Is is possible to upgrade the node from the active node?
Mike Epprecht \(SQL MVP\) - 24 Jun 2005 22:39 GMT
Hi

Run some basic checks on your cluster. Take SQL Server offline on the
Primary node.

Fail the cluster services over to the other node.

Looks like the basic cluster is not right.

Is the 2nd node a possible resource owner for all the resources? By default,
they are not.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

> It sees them all. They are obviously listed as unavailable since its
> passive. Is is possible to upgrade the node from the active node?
Mark Harris - 27 Jun 2005 10:14 GMT
If you do the install from the primary node, the SP setup should ask you if u
are upgrading the virtual server. If you select this option, it should
upgrade both nodes with the service pack!

"Mike Epprecht (SQL MVP)" wrote:

> Hi
>
[quoted text clipped - 21 lines]
> > It sees them all. They are obviously listed as unavailable since its
> > passive. Is is possible to upgrade the node from the active node?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.