Active/Active Cluster Installation Failed

Hi All,
I am trying to install active/active two nodes cluster (Windows Server
2003/SQL Server 2000 â' sp3). I had successfully install the first instance.
But the name instance failed. â'Error: The cluster resource failed to come
online.â'
Also, I did not see any option to choose log file location (only able to
choose data file location). Would you please give me some hints?
For the first instance, I named the first virtual server as SQLVR1 and the
first instance as default.
For the second virtual server, do I have to name it as SQLVR1\xxxxxx? Can I
give the virtual server and the name instance same name or they have to be
different?
Thanks,
AlimI didn't think SQL Server's clustering was Active/Active capable - only
Active/Passive.
--
TheSQLGuru
President
Indicium Resources, Inc.
"alim" <alim@.discussions.microsoft.com> wrote in message
news:8C2E1F14-C448-497B-AFB2-E26F2B57BD29@.microsoft.com...
> Hi All,
> I am trying to install active/active two nodes cluster (Windows Server
> 2003/SQL Server 2000 - sp3). I had successfully install the first
> instance.
> But the name instance failed. "Error: The cluster resource failed to come
> online."
> Also, I did not see any option to choose log file location (only able to
> choose data file location). Would you please give me some hints?
> For the first instance, I named the first virtual server as SQLVR1 and the
> first instance as default.
> For the second virtual server, do I have to name it as SQLVR1\xxxxxx? Can
> I
> give the virtual server and the name instance same name or they have to be
> different?
> Thanks,
> Alim
>|||First, use the term "multi-instance" instead of "Active/Active". It is much
less confusing to everyone.
The Application Event log should tell you you why the cluster resource did
not come on line. My guess is this is the problem:
Installation of a named instance of SQL Server 2000 virtual server on a
Windows Server 2003-based cluster fails
http://support.microsoft.com/kb/815431/en-us
You can change the log file location after the system is up and running.
You can only specify one file location during the install.
And yes, the virtual server name and the SQL instance name must be the same.
I usually use only named instances on a cluster to keep from having to
explain why the names look different.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"alim" <alim@.discussions.microsoft.com> wrote in message
news:8C2E1F14-C448-497B-AFB2-E26F2B57BD29@.microsoft.com...
> Hi All,
> I am trying to install active/active two nodes cluster (Windows Server
> 2003/SQL Server 2000 â' sp3). I had successfully install the first
> instance.
> But the name instance failed. â'Error: The cluster resource failed to come
> online.â'
> Also, I did not see any option to choose log file location (only able to
> choose data file location). Would you please give me some hints?
> For the first instance, I named the first virtual server as SQLVR1 and the
> first instance as default.
> For the second virtual server, do I have to name it as SQLVR1\xxxxxx? Can
> I
> give the virtual server and the name instance same name or they have to be
> different?
> Thanks,
> Alim
>|||> And yes, the virtual server name and the SQL instance name must be the same.
Hmmm... They can be the same or different. We typically just name the
instances SQL1, SQL2, etc. so that we can easily tell/communicate which
instance it is.
Linchi
"Geoff N. Hiten" wrote:
> First, use the term "multi-instance" instead of "Active/Active". It is much
> less confusing to everyone.
> The Application Event log should tell you you why the cluster resource did
> not come on line. My guess is this is the problem:
> Installation of a named instance of SQL Server 2000 virtual server on a
> Windows Server 2003-based cluster fails
> http://support.microsoft.com/kb/815431/en-us
> You can change the log file location after the system is up and running.
> You can only specify one file location during the install.
> And yes, the virtual server name and the SQL instance name must be the same.
> I usually use only named instances on a cluster to keep from having to
> explain why the names look different.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "alim" <alim@.discussions.microsoft.com> wrote in message
> news:8C2E1F14-C448-497B-AFB2-E26F2B57BD29@.microsoft.com...
> > Hi All,
> > I am trying to install active/active two nodes cluster (Windows Server
> > 2003/SQL Server 2000 â' sp3). I had successfully install the first
> > instance.
> > But the name instance failed. â'Error: The cluster resource failed to come
> > online.â'
> > Also, I did not see any option to choose log file location (only able to
> > choose data file location). Would you please give me some hints?
> > For the first instance, I named the first virtual server as SQLVR1 and the
> > first instance as default.
> > For the second virtual server, do I have to name it as SQLVR1\xxxxxx? Can
> > I
> > give the virtual server and the name instance same name or they have to be
> > different?
> >
> > Thanks,
> > Alim
> >
>|||Thanks all for the comments. I think I will go with active/passive
configuration which is much easier.
Thanks!
"Linchi Shea" wrote:
> > And yes, the virtual server name and the SQL instance name must be the same.
> Hmmm... They can be the same or different. We typically just name the
> instances SQL1, SQL2, etc. so that we can easily tell/communicate which
> instance it is.
> Linchi
> "Geoff N. Hiten" wrote:
> > First, use the term "multi-instance" instead of "Active/Active". It is much
> > less confusing to everyone.
> >
> > The Application Event log should tell you you why the cluster resource did
> > not come on line. My guess is this is the problem:
> >
> > Installation of a named instance of SQL Server 2000 virtual server on a
> > Windows Server 2003-based cluster fails
> > http://support.microsoft.com/kb/815431/en-us
> >
> > You can change the log file location after the system is up and running.
> > You can only specify one file location during the install.
> >
> > And yes, the virtual server name and the SQL instance name must be the same.
> > I usually use only named instances on a cluster to keep from having to
> > explain why the names look different.
> >
> > --
> > Geoff N. Hiten
> > Senior Database Administrator
> > Microsoft SQL Server MVP
> >
> >
> >
> >
> > "alim" <alim@.discussions.microsoft.com> wrote in message
> > news:8C2E1F14-C448-497B-AFB2-E26F2B57BD29@.microsoft.com...
> > > Hi All,
> > > I am trying to install active/active two nodes cluster (Windows Server
> > > 2003/SQL Server 2000 â' sp3). I had successfully install the first
> > > instance.
> > > But the name instance failed. â'Error: The cluster resource failed to come
> > > online.â'
> > > Also, I did not see any option to choose log file location (only able to
> > > choose data file location). Would you please give me some hints?
> > > For the first instance, I named the first virtual server as SQLVR1 and the
> > > first instance as default.
> > > For the second virtual server, do I have to name it as SQLVR1\xxxxxx? Can
> > > I
> > > give the virtual server and the name instance same name or they have to be
> > > different?
> > >
> > > Thanks,
> > > Alim
> > >
> >
> >