Mark Forums Read

Cluster Configurations

Go Back

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Reply

Page 1 of 11

1

#1

Old

Mohit K. Gupta

Posts: n/a

Cluster Configurations - 09-20-2008 , 06:18 PM

Hi,

We are currently looking at setting up 3-Node Cluster with
Active/Active/Passive configuration. I am sorry clustering is my weakness
and I not very good at it, so if the question sounds wrong please let me know.

Configuration we are aiming for (Configuration A):
Node 1: Default Instance (SQL2005) and Named Instance (NI01)
-> Set to Fail Over to Node 3
Node 2: Default Instance (SQL2005) and Named Instance (NI01)
-> Set to Fail Over to Node 3

Configuration I was thinking we should do (Configruation B):
Node 1: Default Instance (SQL2005
-> Set Fail Over to Node 3
Node 2: Named Instance (NI01)
-> Set Fail Over to Node 3

Could someone please tell me if Configuration A is possible? Or do we have
to choose Configuration B as main route?

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

Reply With Quote

#2

Old

Linchi Shea

Posts: n/a

RE: Cluster Configurations - 09-20-2008 , 10:42 PM

No, you cannot have two default SQL Server instances in the same cluster. So
your configuration A doesn't work.

Linchi

"Mohit K. Gupta" wrote:

Quote:

Hi,

We are currently looking at setting up 3-Node Cluster with
Active/Active/Passive configuration. I am sorry clustering is my weakness
and I not very good at it, so if the question sounds wrong please let me know.

Configuration we are aiming for (Configuration A):
Node 1: Default Instance (SQL2005) and Named Instance (NI01)
-> Set to Fail Over to Node 3
Node 2: Default Instance (SQL2005) and Named Instance (NI01)
-> Set to Fail Over to Node 3

Configuration I was thinking we should do (Configruation B):
Node 1: Default Instance (SQL2005
-> Set Fail Over to Node 3
Node 2: Named Instance (NI01)
-> Set Fail Over to Node 3

Could someone please tell me if Configuration A is possible? Or do we have
to choose Configuration B as main route?

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

Reply With Quote

#3

Old

Linchi Shea

Posts: n/a

RE: Cluster Configurations - 09-20-2008 , 10:42 PM

No, you cannot have two default SQL Server instances in the same cluster. So
your configuration A doesn't work.

Linchi

"Mohit K. Gupta" wrote:

Quote:

Hi,

We are currently looking at setting up 3-Node Cluster with
Active/Active/Passive configuration. I am sorry clustering is my weakness
and I not very good at it, so if the question sounds wrong please let me know.

Configuration we are aiming for (Configuration A):
Node 1: Default Instance (SQL2005) and Named Instance (NI01)
-> Set to Fail Over to Node 3
Node 2: Default Instance (SQL2005) and Named Instance (NI01)
-> Set to Fail Over to Node 3

Configuration I was thinking we should do (Configruation B):
Node 1: Default Instance (SQL2005
-> Set Fail Over to Node 3
Node 2: Named Instance (NI01)
-> Set Fail Over to Node 3

Could someone please tell me if Configuration A is possible? Or do we have
to choose Configuration B as main route?

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

Reply With Quote

#4

Old

Linchi Shea

Posts: n/a

RE: Cluster Configurations - 09-20-2008 , 10:42 PM

No, you cannot have two default SQL Server instances in the same cluster. So
your configuration A doesn't work.

Linchi

"Mohit K. Gupta" wrote:

Quote:

Hi,

We are currently looking at setting up 3-Node Cluster with
Active/Active/Passive configuration. I am sorry clustering is my weakness
and I not very good at it, so if the question sounds wrong please let me know.

Configuration we are aiming for (Configuration A):
Node 1: Default Instance (SQL2005) and Named Instance (NI01)
-> Set to Fail Over to Node 3
Node 2: Default Instance (SQL2005) and Named Instance (NI01)
-> Set to Fail Over to Node 3

Configuration I was thinking we should do (Configruation B):
Node 1: Default Instance (SQL2005
-> Set Fail Over to Node 3
Node 2: Named Instance (NI01)
-> Set Fail Over to Node 3

Could someone please tell me if Configuration A is possible? Or do we have
to choose Configuration B as main route?

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

Reply With Quote

#5

Old

Linchi Shea

Posts: n/a

RE: Cluster Configurations - 09-20-2008 , 10:42 PM

No, you cannot have two default SQL Server instances in the same cluster. So
your configuration A doesn't work.

Linchi

"Mohit K. Gupta" wrote:

Quote:

Hi,

We are currently looking at setting up 3-Node Cluster with
Active/Active/Passive configuration. I am sorry clustering is my weakness
and I not very good at it, so if the question sounds wrong please let me know.

Configuration we are aiming for (Configuration A):
Node 1: Default Instance (SQL2005) and Named Instance (NI01)
-> Set to Fail Over to Node 3
Node 2: Default Instance (SQL2005) and Named Instance (NI01)
-> Set to Fail Over to Node 3

Configuration I was thinking we should do (Configruation B):
Node 1: Default Instance (SQL2005
-> Set Fail Over to Node 3
Node 2: Named Instance (NI01)
-> Set Fail Over to Node 3

Could someone please tell me if Configuration A is possible? Or do we have
to choose Configuration B as main route?

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

Reply With Quote

#6

Old

Linchi Shea

Posts: n/a

RE: Cluster Configurations - 09-20-2008 , 10:42 PM

No, you cannot have two default SQL Server instances in the same cluster. So
your configuration A doesn't work.

Linchi

"Mohit K. Gupta" wrote:

Quote:

Hi,

We are currently looking at setting up 3-Node Cluster with
Active/Active/Passive configuration. I am sorry clustering is my weakness
and I not very good at it, so if the question sounds wrong please let me know.

Configuration we are aiming for (Configuration A):
Node 1: Default Instance (SQL2005) and Named Instance (NI01)
-> Set to Fail Over to Node 3
Node 2: Default Instance (SQL2005) and Named Instance (NI01)
-> Set to Fail Over to Node 3

Configuration I was thinking we should do (Configruation B):
Node 1: Default Instance (SQL2005
-> Set Fail Over to Node 3
Node 2: Named Instance (NI01)
-> Set Fail Over to Node 3

Could someone please tell me if Configuration A is possible? Or do we have
to choose Configuration B as main route?

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

Reply With Quote

#7

Old

Linchi Shea

Posts: n/a

RE: Cluster Configurations - 09-20-2008 , 10:42 PM

No, you cannot have two default SQL Server instances in the same cluster. So
your configuration A doesn't work.

Linchi

"Mohit K. Gupta" wrote:

Quote:

Hi,

We are currently looking at setting up 3-Node Cluster with
Active/Active/Passive configuration. I am sorry clustering is my weakness
and I not very good at it, so if the question sounds wrong please let me know.

Configuration we are aiming for (Configuration A):
Node 1: Default Instance (SQL2005) and Named Instance (NI01)
-> Set to Fail Over to Node 3
Node 2: Default Instance (SQL2005) and Named Instance (NI01)
-> Set to Fail Over to Node 3

Configuration I was thinking we should do (Configruation B):
Node 1: Default Instance (SQL2005
-> Set Fail Over to Node 3
Node 2: Named Instance (NI01)
-> Set Fail Over to Node 3

Could someone please tell me if Configuration A is possible? Or do we have
to choose Configuration B as main route?

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

Reply With Quote

#8

Old

Linchi Shea

Posts: n/a

RE: Cluster Configurations - 09-20-2008 , 10:42 PM

No, you cannot have two default SQL Server instances in the same cluster. So
your configuration A doesn't work.

Linchi

"Mohit K. Gupta" wrote:

Quote:

Hi,

We are currently looking at setting up 3-Node Cluster with
Active/Active/Passive configuration. I am sorry clustering is my weakness
and I not very good at it, so if the question sounds wrong please let me know.

Configuration we are aiming for (Configuration A):
Node 1: Default Instance (SQL2005) and Named Instance (NI01)
-> Set to Fail Over to Node 3
Node 2: Default Instance (SQL2005) and Named Instance (NI01)
-> Set to Fail Over to Node 3

Configuration I was thinking we should do (Configruation B):
Node 1: Default Instance (SQL2005
-> Set Fail Over to Node 3
Node 2: Named Instance (NI01)
-> Set Fail Over to Node 3

Could someone please tell me if Configuration A is possible? Or do we have
to choose Configuration B as main route?

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

Reply With Quote

#9

Old

Linchi Shea

Posts: n/a

RE: Cluster Configurations - 09-20-2008 , 10:42 PM

No, you cannot have two default SQL Server instances in the same cluster. So
your configuration A doesn't work.

Linchi

"Mohit K. Gupta" wrote:

Quote:

Hi,

We are currently looking at setting up 3-Node Cluster with
Active/Active/Passive configuration. I am sorry clustering is my weakness
and I not very good at it, so if the question sounds wrong please let me know.

Configuration we are aiming for (Configuration A):
Node 1: Default Instance (SQL2005) and Named Instance (NI01)
-> Set to Fail Over to Node 3
Node 2: Default Instance (SQL2005) and Named Instance (NI01)
-> Set to Fail Over to Node 3

Configuration I was thinking we should do (Configruation B):
Node 1: Default Instance (SQL2005
-> Set Fail Over to Node 3
Node 2: Named Instance (NI01)
-> Set Fail Over to Node 3

Could someone please tell me if Configuration A is possible? Or do we have
to choose Configuration B as main route?

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

Reply With Quote

#10

Old

Linchi Shea

Posts: n/a

RE: Cluster Configurations - 09-20-2008 , 10:42 PM

No, you cannot have two default SQL Server instances in the same cluster. So
your configuration A doesn't work.

Linchi

"Mohit K. Gupta" wrote:

Quote:

Hi,

We are currently looking at setting up 3-Node Cluster with
Active/Active/Passive configuration. I am sorry clustering is my weakness
and I not very good at it, so if the question sounds wrong please let me know.

Configuration we are aiming for (Configuration A):
Node 1: Default Instance (SQL2005) and Named Instance (NI01)
-> Set to Fail Over to Node 3
Node 2: Default Instance (SQL2005) and Named Instance (NI01)
-> Set to Fail Over to Node 3

Configuration I was thinking we should do (Configruation B):
Node 1: Default Instance (SQL2005
-> Set Fail Over to Node 3
Node 2: Named Instance (NI01)
-> Set Fail Over to Node 3

Could someone please tell me if Configuration A is possible? Or do we have
to choose Configuration B as main route?

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

Reply With Quote

Reply

Page 1 of 11

1

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.