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 / May 2006

Tip: Looking for answers? Try searching our database.

SQL Cluster Server setup Issue

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kevin Humphreys - 26 May 2006 13:16 GMT
Hi,
I'm trying to setup a SQL cluster server on a Active/Passive Server.
I get to the prompt where I select the Instance Name.
I want to use the default installation however the the Default checkbox is
disabled (greyed out).
I am forced to select a new instance name which I dont want.

How can I use the default installation? Any ideas?

Thanks,
Kevin.
Tom Moreau - 26 May 2006 13:58 GMT
You may have another instance somewhere in the cluster - either a virtual
instance or a local one on one of the nodes.

Signature

   Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON   Canada

Hi,
I'm trying to setup a SQL cluster server on a Active/Passive Server.
I get to the prompt where I select the Instance Name.
I want to use the default installation however the the Default checkbox is
disabled (greyed out).
I am forced to select a new instance name which I dont want.

How can I use the default installation? Any ideas?

Thanks,
Kevin.
Kevin Humphreys - 26 May 2006 14:01 GMT
I have a sql server installation on each of the 2 nodes but there are no
extra instances. Just the default ones.
Does this matter?

> You may have another instance somewhere in the cluster - either a virtual
> instance or a local one on one of the nodes.
[quoted text clipped - 10 lines]
> Thanks,
> Kevin.
Tom Moreau - 26 May 2006 14:05 GMT
Yes, it does.

Signature

   Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON   Canada

I have a sql server installation on each of the 2 nodes but there are no
extra instances. Just the default ones.
Does this matter?

> You may have another instance somewhere in the cluster - either a virtual
> instance or a local one on one of the nodes.
[quoted text clipped - 10 lines]
> Thanks,
> Kevin.
Kevin Humphreys - 26 May 2006 14:32 GMT
i was under the assumption that you need a sql server installation on node a
and node b before you begin the installation of the virtual server.
or so i setup the virtual server first and the the local installations?

> Yes, it does.
>
[quoted text clipped - 17 lines]
>> Thanks,
>> Kevin.
Tom Moreau - 26 May 2006 14:49 GMT
You only need the virtual instance.  I'd remove those two local instances -
unless you have some specific need for them.  When you go to install the
virtual instance, the binaries are placed onto the local disks of both nodes
by the setup process, so you do only one install.  The data files go on the
shared disks.

Signature

   Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON   Canada

i was under the assumption that you need a sql server installation on node a
and node b before you begin the installation of the virtual server.
or so i setup the virtual server first and the the local installations?

> Yes, it does.
>
[quoted text clipped - 6 lines]
>> You may have another instance somewhere in the cluster - either a virtual
>> instance or a local one on one of the nodes.
Kevin Humphreys - 26 May 2006 14:59 GMT
Ill give it a go. Thanks for your help.

Regards,
Kevin.

> You only need the virtual instance.  I'd remove those two local
> instances -
[quoted text clipped - 21 lines]
>>> virtual
>>> instance or a local one on one of the nodes.
 
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.