"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

"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...
> > 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
>
>