How to configure cluster sql actif/actif

hello,
I'd like to configure an actif/actif/ sql cluster
I've done a actif/passif which works well !
But my "actif/actif" cluster works like an actif/passif
I dont understand clearely, how the pc client application
(for exemple access 2000) it's possible to keep active a session odbc
with a virtual sql server?
Here what i've done:
2 advanced servers 2000
1 array disks with 2 logicals disks (e: f
Cluster with 2 groups
Each group in the server
group1 / server1
group2 / server2
Setup sql
1 virtual sql server (name = sqlvirtual1) , instance = default / server1 /
group1
1 virtual sql server (name = sqlvirtual2) , instance = instance2 /server2
/group2
From my client
odbc connection to sqlvirtual2 ok
but when the server2 shutdown, my odbc session shutdown too
I need to wait that the server1 "wake up" to work correctly again
I try to used the round robin in the dns with a virtual server name
sql = ip (sqlvirtual1) and ip (sqlvirtual2) which used the ip addresses of
my 2 virtuals sql servers.
But without results
I try to install a wins with multi-resident adress, but without results
I would like to know how it's possible for the "access" client connected to
a virtual sql server name (ex: sqlvirtual2) using the other group on the
other cluster node?
Thank in advance for your help
Vincent
Once again, the old, incorrect naming system claims another victim.
'Active/Passive', 'Active/Active', and all the multi-node variants are
obsolete terms that do not apply to SQL 2000 clustering. 'Active/Active'
implies a load-balanced setup which SQL simply does not support. The
correct term is 'multi-instance' and the behavior you described is normal
failover behavior. One reason Access makes such a poor SQL client is that
it does not automatically reconnect after a service failure. .
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"vincent" <vincent@.discussions.microsoft.com> wrote in message
news:DFEF2441-1BD9-4875-BF6D-6E0DE6150A8B@.microsoft.com...
> hello,
> I'd like to configure an actif/actif/ sql cluster
> I've done a actif/passif which works well !
> But my "actif/actif" cluster works like an actif/passif
> I dont understand clearely, how the pc client application
> (for exemple access 2000) it's possible to keep active a session odbc
> with a virtual sql server?
> Here what i've done:
> 2 advanced servers 2000
> 1 array disks with 2 logicals disks (e: f
> Cluster with 2 groups
> Each group in the server
> group1 / server1
> group2 / server2
> Setup sql
> 1 virtual sql server (name = sqlvirtual1) , instance = default / server1 /
> group1
> 1 virtual sql server (name = sqlvirtual2) , instance = instance2 /server2
> /group2
> From my client
> odbc connection to sqlvirtual2 ok
> but when the server2 shutdown, my odbc session shutdown too
> I need to wait that the server1 "wake up" to work correctly again
> I try to used the round robin in the dns with a virtual server name
> sql = ip (sqlvirtual1) and ip (sqlvirtual2) which used the ip addresses of
> my 2 virtuals sql servers.
> But without results
> I try to install a wins with multi-resident adress, but without results
> I would like to know how it's possible for the "access" client connected
> to
> a virtual sql server name (ex: sqlvirtual2) using the other group on the
> other cluster node?
> Thank in advance for your help
> Vincent
|||Thank very much Geoff
Ok for the terms "multi-instance", I'll communicate with them !
Have a good day
Vincent
"Geoff N. Hiten" wrote:

> Once again, the old, incorrect naming system claims another victim.
> 'Active/Passive', 'Active/Active', and all the multi-node variants are
> obsolete terms that do not apply to SQL 2000 clustering. 'Active/Active'
> implies a load-balanced setup which SQL simply does not support. The
> correct term is 'multi-instance' and the behavior you described is normal
> failover behavior. One reason Access makes such a poor SQL client is that
> it does not automatically reconnect after a service failure. .
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "vincent" <vincent@.discussions.microsoft.com> wrote in message
> news:DFEF2441-1BD9-4875-BF6D-6E0DE6150A8B@.microsoft.com...
>
>