Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Cluster problem

  
   Database Forums (Home) -> Clustering RSS
Next:  problem exporting data from mainframe using db2 c..  
Author Message
Robert Hindla

External


Since: Aug 29, 2006
Posts: 2



(Msg. 1) Posted: Thu Dec 13, 2007 7:08 pm
Post subject: Cluster problem
Archived from groups: microsoft>public>sqlserver>clustering (more info?)
An installation of sql2k5 sp2 to one node of a three node
active/active/active cluster has failed. It cannot proceed beyond the
beginning of the sql2k5 sp2 installation. It fails because it can't install
sqlsupport.msi. It seems to want to put the files in the wrong place.

We can't get the sp to install after a lot of trying and want to 1) fail the
instance the node normally hosts to a partner 2) disconnect the node from
the cluster heartbeat and public networks and 3) run a SQL de-install of the
problematic instance on the disconnected node to clear off SQL and then
reinstall it, bringing it up to SQL2K5 SP2 4) reconnect the node to the
network and 5) fail the instance on the partner node back.

I don't think this will work because during the de-install the add/remove
routine will ask to remove code from san drives it can't find because
they're no longer accessible to it, since it has been disconnected from the
network and SAN. I think a manual removal may be all that can work.

After the node has been reconnected, and SQL installation commenced I will
be asked to create a new instance, a local or clustered instance, neither of
which I want. Can I avoid this by running SQL Setup on the reconnected node
and asking to manage a virtual instance instead of installing a fresh one?

Will I need, at some point, to evict the disconnected node from the cluster?
I know on a previous occasion, I couldn't get the node, once evicted, to
rejoin. Once it's out, it's out for good, isn't it?

 >> Stay informed about: Cluster problem 
Back to top
Login to vote
Russ Kaufmann [MVP]

External


Since: Jul 12, 2006
Posts: 30



(Msg. 2) Posted: Mon Dec 17, 2007 11:25 am
Post subject: Re: Cluster problem [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"Robert Hindla" wrote in message

> An installation of sql2k5 sp2 to one node of a three node
> active/active/active cluster has failed. It cannot proceed beyond the
> beginning of the sql2k5 sp2 installation. It fails because it can't
> install
> sqlsupport.msi. It seems to want to put the files in the wrong place.

Are you installing the first instance or the second instance?

--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
Jan 18 - 31 in Denver
Mar 10- 13 in Denver

 >> Stay informed about: Cluster problem 
Back to top
Login to vote
Robert Hindla

External


Since: Aug 29, 2006
Posts: 2



(Msg. 3) Posted: Tue Dec 18, 2007 4:13 pm
Post subject: Re: Cluster problem [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
The virtual SQL instance I'm proposing to de-install and then re-configure
using the setup program in 'manage' mode (instead of 'setup' mode) is one of
two named instances. It isn't the default instance.

The default instance functions satisfactorily, but only after a lot of
backing and filling, such as returning the native client to RTM level and
then re-running the installation of the client tools.


On 12/17/07 1:25 PM, in article
351AA24D-A3AA-4812-9682-F36BAFB1BC14.TakeThisOut@microsoft.com, "Russ Kaufmann [MVP]"
wrote:

> "Robert Hindla" wrote in message
>
>> An installation of sql2k5 sp2 to one node of a three node
>> active/active/active cluster has failed. It cannot proceed beyond the
>> beginning of the sql2k5 sp2 installation. It fails because it can't
>> install
>> sqlsupport.msi. It seems to want to put the files in the wrong place.
>
> Are you installing the first instance or the second instance?
 >> Stay informed about: Cluster problem 
Back to top
Login to vote
Russ Kaufmann [MVP]

External


Since: Jul 12, 2006
Posts: 30



(Msg. 4) Posted: Tue Dec 18, 2007 4:13 pm
Post subject: Re: Cluster problem [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"Robert Hindla" wrote in message

> The virtual SQL instance I'm proposing to de-install and then re-configure
> using the setup program in 'manage' mode (instead of 'setup' mode) is one
> of
> two named instances. It isn't the default instance.
>
> The default instance functions satisfactorily, but only after a lot of
> backing and filling, such as returning the native client to RTM level and
> then re-running the installation of the client tools.

So, it sounds to me like things are seriously hosed (to use a highly
technical term) with your cluster. I would consider a complete rebuild over
the holidays if it were me.


--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
Jan 18 - 31 in Denver
Mar 10- 13 in Denver
 >> Stay informed about: Cluster problem 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Configuring SIS in a Cluster problem - I am attempting to configure SIS in a clustered environment using the instructions found at http://msdn2.microsoft.com/en-us/library/ms345193.aspx. I have added the required dependancies to a new generic resource in the Cluster Adminstration screen and i...

Cluster problem sql server 2000 active/passive is running .. - Hello, Today, during work, suddenly my sql server was stopped, cluster started failover. Did not switch node but started sql on the same active machine. After that I got message that on passive machine also sql server service is running :( I tried to..

Database Mail Configuration Problem in a cluster env. (SQL.. - Hello, I'm trying to configure Database Mail on our Cluster running 2 SQL server 2005 SP2 node. The configuratoin wizard is running fine and I presume the details entered are correct: - Existing user - FQN mail server etc.. I also made sure the..

How SQL2005 cluster can be installed on windows cluster? - I am new on both SQL and windows cluster. Our company is trying to deploy a HA SQL system, which I need to install SQL2005 to windows cluster. My question is: Since windows cluster will share one back end storage chassis, where should I put SQL2005 on...

Cluster DR - My production cluster disks are corruptd - i would like to find out how to restore from backups I have all system backups and mdf and ldf files of the databases - I would like to keep the logins, jobs etc Thanks
   Database Forums (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]