Re: about another instance of virtual server on sql2000 cluster

Precisely. Multiple instances on a cluster look and act just like multiple
instances on a stand-alone box. I typically use only named instances on a
cluster just to avoid naming confusion.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

<io.com> wrote in message news:%233DO2ipzFHA.268@xxxxxxxxxxxxxxxxxxxxxxx
> Sorry , a lat question :
>
> i have isntalled the new virtual server and it work fine but i see that
> the new instance of sql virtual server is myclustersql02\myclustersql02
>
> Why ?
>
> The first instance was call only "mycluster01" ....
> Perhaps because all new instance of virtual server that i install are a
> "sql named instance" ?
>
> Thanks.
>
> "Linchi Shea" <linchi_shea@xxxxxxxxxxxx> wrote in message
> news:ex9%23QsezFHA.3924@xxxxxxxxxxxxxxxxxxxxxxx
>> No matter whether it's clustered or not, each SQL2000 instance has its
>> own location for its binaries (well some binaries for the tools are
>> shared). You can specify the same path, and the install will create a
>> different folder under that path for each instance. For instance, if you
>> specify D:\MyDir for the binaries (program files), the install will place
>> the binaries under D:\MyDir\MSSQL for the default instance, and under
>> D:\MyDir\MSSQL$<InstanceName> for a named instance.
>>
>> Check out the section titled "File Paths for SQL Server 2000" in BOL.
>>
>> Also, technically you don't really install another virtual server on the
>> passive node. Rather, you install another virtual server in the cluster,
>> and when you install it, the binaries are placed on all the nodes. You
>> can configure the virtual server to run on a particular node in its
>> normal operating mode.
>>
>> Linchi
>>
>> <io.com> wrote in message news:%23c$txrdzFHA.460@xxxxxxxxxxxxxxxxxxxxxxx
>>> Hi,
>>>
>>> i have a cluster a/p windows 2000 & SQL2000 , now i would like install
>>> another virtual sever SQL on passive node for make this cluster
>>> active/active.
>>>
>>> The question is :
>>>
>>> When i start a SQL wizard for add a new virtual server when installation
>>> wizard aask me a path for sql binary i must use the same exist path use
>>> for the virtual sql server installed or i must choice another path for
>>> ex. c:\.....\SQL\Virtual2 ?!?!?
>>>
>>> Thanks.
>>>
>>>
>>> --
>>> ---
>>>
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: I Surrender.....Help?
    ... Name resolution is critical to cluster ... Verify the Edition of SQL you are installing. ... Install the SQL client tools only on your primary install node. ... account is a domain account with local admin rights on each node. ...
    (microsoft.public.sqlserver.clustering)
  • Re: sql 2005 cluster setup questions
    ... Thanks again, Geoff. ... Here is the official instructions on how to rip SQL 2005 out by the roots. ... to 2nd node to install work station component, ... want to take Microsoft recommended approach not to cluster SSIS but I ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... I did test and it did not install the client tools. ... http://www.clusterhelp.com - Cluster Training ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... http://www.clusterhelp.com - Cluster Training ... actually do the install to catch that one. ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Default or named instances??
    ... this with SRV records, i didnt see a _sql records, lots of other types.. ... I've setup the cluster and tried to install the second instance as ... For each instance I need a virtual server name and an instance name ... The second named instance is accessible by the new virtal servers' name ...
    (microsoft.public.sqlserver.clustering)
Loading