2 node cluster - Witch Instance name ?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "CK" <fhf@xxxxxx>
Date: Tue, 20 Nov 2007 21:33:06 +0100

Hello

I will setup a 2 node sql 2005 std. ed cluster with multi instance.

How maney instance can i run (16 total in standard ed.) ?, there is a small base with low traffic inside each instance.

Witch instance name & virtual name shoud i use SQLINST01\SQLINST01 or can i use the Cluster VIP name someshow.

If someone report a error on a instance is will be nice that we quick know on with cluster it is.

If my cluster name is SQLCLU01 can i use that in the instance names: SQLCLU01INST01\SQLCLU01INST01 or

Eksamble:

SQLCLU01\INST01
SQLCLU01\INST02
SQLCLU01\INST03

SQLCLU01INST01\SQLCLU01INST01
SQLCLU01INST02\SQLCLU01INST02
SQLCLU01INST03\SQLCLU01INST03

.

Follow-Ups:
- Re: 2 node cluster - Witch Instance name ?
  - From: jason

Prev by Date: Re: Changing SQL Service account passowrd on a cluster configurati
Next by Date: Re: Changing SQL Service account passowrd on a cluster configurati
Previous by thread: Re: Changing SQL Service account passowrd on a cluster configuration
Next by thread: Re: 2 node cluster - Witch Instance name ?
Index(es):
- Date
- Thread

Relevant Pages

Re: SQL 2005 Standard and Enterprise editions on the same cluster.
... cluster running Standard and then add another instance using Enterprise? ... Of course SQL Server 2005 for everything and 64-bit:) ...
(microsoft.public.sqlserver.clustering)
Re: SQL 2005 Cluster with 2K
... will have to install 2000 Enterprise along side 2005 Standard. ... I will use SS 2005 standard for the cluster. ... Previously I would have to buy 2K enterprise to support clustering so I ...
(microsoft.public.sqlserver.clustering)
Re: SQL 2005 Cluster with 2K
... therefore by default be clustered as part of the 2005 standard installation? ... Attaching a 2000 database to a 2005 instance is the same regardless of ... whether that instance is a standalone or a failover cluster instance. ... will have to install 2000 Enterprise along side 2005 Standard. ...
(microsoft.public.sqlserver.clustering)
Re: [PATCH 0/7] dlm: overview
... >> I'm saying that in my experiance there isn't any standard or reliable way ... >> claim to educate me on what I'm missing becouse a reliable UUID for linux ... > Linux system for over ten. ... cluster membership, becouse I assumed that the generation of an ID would ...
(Linux-Kernel)
Re: Move from active/passive cluster to active/active
... loose your connection, as it offlines the group completely when moving. ... I've installed a Windows 2003 Cluster with SQL 2005. ... Now i want to make this cluster active/active (multi instance) so no ... connection is lost when a node goes down, but can't find any info on ...
(microsoft.public.sqlserver.clustering)