dbTalk Databases Forums  

sql 2005 sp2 cluster - how to add an additional instance.

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.clustering sql 2005 sp2 cluster - how to add an additional instance.

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


Discuss sql 2005 sp2 cluster - how to add an additional instance. in the microsoft.public.sqlserver.clustering forum.



Reply
Page 1 of 2 1 2 >
 
Thread Tools Display Modes
  #1  
Old   
William Delgado
 
Posts: n/a

Default sql 2005 sp2 cluster - how to add an additional instance. - 05-07-2008 , 06:06 PM





Hello,

I am running into an issue here. I want to create an active/active cluster.
So far I created an active/passive cluster with 1 named instance (no default
instance).

Now I want to create another virtual server group (with IP, Name & Disk
resources) with another named instance. the end result should look like this

CLUSTER_HOST_1
Cluster Group (quorum)
IP Res
Name Res
Disk Res
MSDTC Res
SQL01 Group (named Instance)
IP Res
Name Res
Disk Res
SQL Server (named instance 1)
CLUSTER_HOST_2
SQL02 Group (named Instance)
IP Res
Name Res
Disk Res
SQL Server (named instance 2)

My issue here is that every time I start SQL 2005 SP0 setup, I get an error
that I have to run setup via the command line and include UPGRADE=1.

Long story short, I need to create a new sql 2005 with sp2 instance in my
cluster. Does anyone know how I can get this started?






Reply With Quote
  #2  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: sql 2005 sp2 cluster - how to add an additional instance. - 05-08-2008 , 07:49 AM





Are you starting the install from the CD/DVD or from Add/remove programs.
To add a new instance, you should start from CD (or a local copy of the
install media.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"William Delgado" <WilliamDelgado (AT) discussions (DOT) microsoft.com> wrote in
message news:0FD752D3-E022-4530-8F37-34B374847D78 (AT) microsoft (DOT) com...
Quote:
Hello,

I am running into an issue here. I want to create an active/active
cluster.
So far I created an active/passive cluster with 1 named instance (no
default
instance).

Now I want to create another virtual server group (with IP, Name & Disk
resources) with another named instance. the end result should look like
this

CLUSTER_HOST_1
Cluster Group (quorum)
IP Res
Name Res
Disk Res
MSDTC Res
SQL01 Group (named Instance)
IP Res
Name Res
Disk Res
SQL Server (named instance 1)
CLUSTER_HOST_2
SQL02 Group (named Instance)
IP Res
Name Res
Disk Res
SQL Server (named instance 2)

My issue here is that every time I start SQL 2005 SP0 setup, I get an
error
that I have to run setup via the command line and include UPGRADE=1.

Long story short, I need to create a new sql 2005 with sp2 instance in my
cluster. Does anyone know how I can get this started?


Reply With Quote
  #3  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: sql 2005 sp2 cluster - how to add an additional instance. - 05-08-2008 , 07:49 AM


Are you starting the install from the CD/DVD or from Add/remove programs.
To add a new instance, you should start from CD (or a local copy of the
install media.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"William Delgado" <WilliamDelgado (AT) discussions (DOT) microsoft.com> wrote in
message news:0FD752D3-E022-4530-8F37-34B374847D78 (AT) microsoft (DOT) com...
Quote:
Hello,

I am running into an issue here. I want to create an active/active
cluster.
So far I created an active/passive cluster with 1 named instance (no
default
instance).

Now I want to create another virtual server group (with IP, Name & Disk
resources) with another named instance. the end result should look like
this

CLUSTER_HOST_1
Cluster Group (quorum)
IP Res
Name Res
Disk Res
MSDTC Res
SQL01 Group (named Instance)
IP Res
Name Res
Disk Res
SQL Server (named instance 1)
CLUSTER_HOST_2
SQL02 Group (named Instance)
IP Res
Name Res
Disk Res
SQL Server (named instance 2)

My issue here is that every time I start SQL 2005 SP0 setup, I get an
error
that I have to run setup via the command line and include UPGRADE=1.

Long story short, I need to create a new sql 2005 with sp2 instance in my
cluster. Does anyone know how I can get this started?


Reply With Quote
  #4  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: sql 2005 sp2 cluster - how to add an additional instance. - 05-08-2008 , 07:49 AM


Are you starting the install from the CD/DVD or from Add/remove programs.
To add a new instance, you should start from CD (or a local copy of the
install media.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"William Delgado" <WilliamDelgado (AT) discussions (DOT) microsoft.com> wrote in
message news:0FD752D3-E022-4530-8F37-34B374847D78 (AT) microsoft (DOT) com...
Quote:
Hello,

I am running into an issue here. I want to create an active/active
cluster.
So far I created an active/passive cluster with 1 named instance (no
default
instance).

Now I want to create another virtual server group (with IP, Name & Disk
resources) with another named instance. the end result should look like
this

CLUSTER_HOST_1
Cluster Group (quorum)
IP Res
Name Res
Disk Res
MSDTC Res
SQL01 Group (named Instance)
IP Res
Name Res
Disk Res
SQL Server (named instance 1)
CLUSTER_HOST_2
SQL02 Group (named Instance)
IP Res
Name Res
Disk Res
SQL Server (named instance 2)

My issue here is that every time I start SQL 2005 SP0 setup, I get an
error
that I have to run setup via the command line and include UPGRADE=1.

Long story short, I need to create a new sql 2005 with sp2 instance in my
cluster. Does anyone know how I can get this started?


Reply With Quote
  #5  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: sql 2005 sp2 cluster - how to add an additional instance. - 05-08-2008 , 07:49 AM


Are you starting the install from the CD/DVD or from Add/remove programs.
To add a new instance, you should start from CD (or a local copy of the
install media.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"William Delgado" <WilliamDelgado (AT) discussions (DOT) microsoft.com> wrote in
message news:0FD752D3-E022-4530-8F37-34B374847D78 (AT) microsoft (DOT) com...
Quote:
Hello,

I am running into an issue here. I want to create an active/active
cluster.
So far I created an active/passive cluster with 1 named instance (no
default
instance).

Now I want to create another virtual server group (with IP, Name & Disk
resources) with another named instance. the end result should look like
this

CLUSTER_HOST_1
Cluster Group (quorum)
IP Res
Name Res
Disk Res
MSDTC Res
SQL01 Group (named Instance)
IP Res
Name Res
Disk Res
SQL Server (named instance 1)
CLUSTER_HOST_2
SQL02 Group (named Instance)
IP Res
Name Res
Disk Res
SQL Server (named instance 2)

My issue here is that every time I start SQL 2005 SP0 setup, I get an
error
that I have to run setup via the command line and include UPGRADE=1.

Long story short, I need to create a new sql 2005 with sp2 instance in my
cluster. Does anyone know how I can get this started?


Reply With Quote
  #6  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: sql 2005 sp2 cluster - how to add an additional instance. - 05-08-2008 , 07:49 AM


Are you starting the install from the CD/DVD or from Add/remove programs.
To add a new instance, you should start from CD (or a local copy of the
install media.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"William Delgado" <WilliamDelgado (AT) discussions (DOT) microsoft.com> wrote in
message news:0FD752D3-E022-4530-8F37-34B374847D78 (AT) microsoft (DOT) com...
Quote:
Hello,

I am running into an issue here. I want to create an active/active
cluster.
So far I created an active/passive cluster with 1 named instance (no
default
instance).

Now I want to create another virtual server group (with IP, Name & Disk
resources) with another named instance. the end result should look like
this

CLUSTER_HOST_1
Cluster Group (quorum)
IP Res
Name Res
Disk Res
MSDTC Res
SQL01 Group (named Instance)
IP Res
Name Res
Disk Res
SQL Server (named instance 1)
CLUSTER_HOST_2
SQL02 Group (named Instance)
IP Res
Name Res
Disk Res
SQL Server (named instance 2)

My issue here is that every time I start SQL 2005 SP0 setup, I get an
error
that I have to run setup via the command line and include UPGRADE=1.

Long story short, I need to create a new sql 2005 with sp2 instance in my
cluster. Does anyone know how I can get this started?


Reply With Quote
  #7  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: sql 2005 sp2 cluster - how to add an additional instance. - 05-08-2008 , 07:49 AM


Are you starting the install from the CD/DVD or from Add/remove programs.
To add a new instance, you should start from CD (or a local copy of the
install media.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"William Delgado" <WilliamDelgado (AT) discussions (DOT) microsoft.com> wrote in
message news:0FD752D3-E022-4530-8F37-34B374847D78 (AT) microsoft (DOT) com...
Quote:
Hello,

I am running into an issue here. I want to create an active/active
cluster.
So far I created an active/passive cluster with 1 named instance (no
default
instance).

Now I want to create another virtual server group (with IP, Name & Disk
resources) with another named instance. the end result should look like
this

CLUSTER_HOST_1
Cluster Group (quorum)
IP Res
Name Res
Disk Res
MSDTC Res
SQL01 Group (named Instance)
IP Res
Name Res
Disk Res
SQL Server (named instance 1)
CLUSTER_HOST_2
SQL02 Group (named Instance)
IP Res
Name Res
Disk Res
SQL Server (named instance 2)

My issue here is that every time I start SQL 2005 SP0 setup, I get an
error
that I have to run setup via the command line and include UPGRADE=1.

Long story short, I need to create a new sql 2005 with sp2 instance in my
cluster. Does anyone know how I can get this started?


Reply With Quote
  #8  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: sql 2005 sp2 cluster - how to add an additional instance. - 05-08-2008 , 07:49 AM


Are you starting the install from the CD/DVD or from Add/remove programs.
To add a new instance, you should start from CD (or a local copy of the
install media.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"William Delgado" <WilliamDelgado (AT) discussions (DOT) microsoft.com> wrote in
message news:0FD752D3-E022-4530-8F37-34B374847D78 (AT) microsoft (DOT) com...
Quote:
Hello,

I am running into an issue here. I want to create an active/active
cluster.
So far I created an active/passive cluster with 1 named instance (no
default
instance).

Now I want to create another virtual server group (with IP, Name & Disk
resources) with another named instance. the end result should look like
this

CLUSTER_HOST_1
Cluster Group (quorum)
IP Res
Name Res
Disk Res
MSDTC Res
SQL01 Group (named Instance)
IP Res
Name Res
Disk Res
SQL Server (named instance 1)
CLUSTER_HOST_2
SQL02 Group (named Instance)
IP Res
Name Res
Disk Res
SQL Server (named instance 2)

My issue here is that every time I start SQL 2005 SP0 setup, I get an
error
that I have to run setup via the command line and include UPGRADE=1.

Long story short, I need to create a new sql 2005 with sp2 instance in my
cluster. Does anyone know how I can get this started?


Reply With Quote
  #9  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: sql 2005 sp2 cluster - how to add an additional instance. - 05-08-2008 , 07:49 AM


Are you starting the install from the CD/DVD or from Add/remove programs.
To add a new instance, you should start from CD (or a local copy of the
install media.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"William Delgado" <WilliamDelgado (AT) discussions (DOT) microsoft.com> wrote in
message news:0FD752D3-E022-4530-8F37-34B374847D78 (AT) microsoft (DOT) com...
Quote:
Hello,

I am running into an issue here. I want to create an active/active
cluster.
So far I created an active/passive cluster with 1 named instance (no
default
instance).

Now I want to create another virtual server group (with IP, Name & Disk
resources) with another named instance. the end result should look like
this

CLUSTER_HOST_1
Cluster Group (quorum)
IP Res
Name Res
Disk Res
MSDTC Res
SQL01 Group (named Instance)
IP Res
Name Res
Disk Res
SQL Server (named instance 1)
CLUSTER_HOST_2
SQL02 Group (named Instance)
IP Res
Name Res
Disk Res
SQL Server (named instance 2)

My issue here is that every time I start SQL 2005 SP0 setup, I get an
error
that I have to run setup via the command line and include UPGRADE=1.

Long story short, I need to create a new sql 2005 with sp2 instance in my
cluster. Does anyone know how I can get this started?


Reply With Quote
  #10  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: sql 2005 sp2 cluster - how to add an additional instance. - 05-08-2008 , 07:49 AM


Are you starting the install from the CD/DVD or from Add/remove programs.
To add a new instance, you should start from CD (or a local copy of the
install media.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"William Delgado" <WilliamDelgado (AT) discussions (DOT) microsoft.com> wrote in
message news:0FD752D3-E022-4530-8F37-34B374847D78 (AT) microsoft (DOT) com...
Quote:
Hello,

I am running into an issue here. I want to create an active/active
cluster.
So far I created an active/passive cluster with 1 named instance (no
default
instance).

Now I want to create another virtual server group (with IP, Name & Disk
resources) with another named instance. the end result should look like
this

CLUSTER_HOST_1
Cluster Group (quorum)
IP Res
Name Res
Disk Res
MSDTC Res
SQL01 Group (named Instance)
IP Res
Name Res
Disk Res
SQL Server (named instance 1)
CLUSTER_HOST_2
SQL02 Group (named Instance)
IP Res
Name Res
Disk Res
SQL Server (named instance 2)

My issue here is that every time I start SQL 2005 SP0 setup, I get an
error
that I have to run setup via the command line and include UPGRADE=1.

Long story short, I need to create a new sql 2005 with sp2 instance in my
cluster. Does anyone know how I can get this started?


Reply With Quote
Reply
Page 1 of 2 1 2 >

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear 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.


Contact Us - dbTalk Databases Forums - Archive - Top