Dear Ekrem
thanx for giving me the link...
so it means that I'll have to run SQL setup each time I want to create an
Instance. what I know is that I'll be using a different instance name for
different instances, but what about Clustername and Sql servername and Ip
address that is going to be used by clients. shall i have to provide this
information same for every instance or what ?
and one more thing for active/active cluster that i want to confirm ie.
after having
installed sql server on 2 nodes, tell me what i'll have to do to create
instances of
databases. shall i have to create the instances on both nodes or just one
node,
because its the datbases contained by instances.
in our scenairo, we are going to have more than one instances, clear me that
shall I
have to install one instance on first node and 2nd instance on 2nd node ? or
just
install both instances on the same node which will be owned by the 2nd node
in time of failover...?
i think that it will be created on first node(both instances) in the
active/active cluster and the other second node will own it when the first
fails, correct me if im wrong...

Regards
--
DBA

You would not ask these questions if you read that article... It's for your
good to read it, not for me.

You must start SQL Server setup when you want to install an instance of SQL
Server.

You'll use different IP addresses and Virtual SQL Server Names for all your
instances and nodes. Your clients will be using Virtual SQL Server Names to
connect to those SQL Server instances.

You'll install your SQL Server insances after installing MSCS and add your
nodes to the Cluster. Your both nodes must be running when you are
installing your SQL Server instances.

If you run your SQL Server instances on both nodes at the same time, it's
gonna be an active\active SQL Server Failover Cluster, so this structure
will need a SQL Server license for each active server.

--
Ekrem Önsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCTS: SQL Server 2005, MCITPBA, MCSD.Net, MCSE, MCT



"SQLWay" <SQLWay@discussions.microsoft.com> wrote in message
news:1801FD84-F7AC-4492-9DBB-556ACB8CE15F@microsoft.com...
> Dear Ekrem
> thanx for giving me the link...
> so it means that I'll have to run SQL setup each time I want to create an
> Instance. what I know is that I'll be using a different instance name for
> different instances, but what about Clustername and Sql servername and Ip
> address that is going to be used by clients. shall i have to provide this
> information same for every instance or what ?
> and one more thing for active/active cluster that i want to confirm ie.
> after having
> installed sql server on 2 nodes, tell me what i'll have to do to create
> instances of
> databases. shall i have to create the instances on both nodes or just one
> node,
> because its the datbases contained by instances.
> in our scenairo, we are going to have more than one instances, clear me
> that
> shall I
> have to install one instance on first node and 2nd instance on 2nd node ?
> or
> just
> install both instances on the same node which will be owned by the 2nd
> node
> in time of failover...?
> i think that it will be created on first node(both instances) in the
> active/active cluster and the other second node will own it when the first
> fails, correct me if im wrong...
>
> Regards
> --
> DBA