The client I'm working with has a 2-node Failover cluster.  Owing to their
environment, they have several machines accessing the many databases.  For
cost reasons, they went with SQL standard.
As to securing the traffic.  I understand that IPSec isn't supported for

Hiya,
We have several servers that have SQL Server and an application installed,
therefore they are not just dedicated to SQL.  Some of these applications
have services, other have exe's that are launched by users over the network.

I have a SQL 2005 cluster running, now the client would like to have the
dataset replicated to another SQL server offsite for further redundancy.
For the time being, the offsite server will be a stand-alone, however in the
future it could become another clustered solution.

We are starting to look into a high availability solution to ensure
operation of our business in the event of a localized disaster
(i.e.. building fire). We are planning on a remote site, maybe
25 miles away, that will provide virtual servers and resources via

Hello to everyone,
I have a question relative with the Network Load Balancing mechanism in my
pilot
network with 2 windows 2003 streaming servers.

Can someone recommend a good book that covers SQL clustering? And maybe even
SQL Mirroring?
I'm going to install my first SQL Cluster and I want to be as prepared as
possible.

I'm interested to hear from anyone about their experiences with 64-bit
clustering with Windows Server 2003 and SQL Server 2005  - both good or bad.
This is before I move with this new platform. Currently doing it with 32bit.
cheers.

I created a one node Cluster in Windows 2003 enterprise server. I then loaded
a SQL 2000 Vitrual server. I now need to add a second node.  The cluster sees
the new node.  However when I attempt to load the SLQ executables on the
second node the only option I have once I choose ...

I have SQL 2005 failover Clusterring on windows 2000 adv. server with
physical memory 8 GB , i can increase the max memory to 6000 MB in the first
node but when i move cluster to second node i can not increase the max memory
to more than 2100 MB , i want to the second to be ...

I am new to sql 2005 and clustering I too have made the same mistake as
wayne see Geoff response on the 5th of Feb.  I have a 2 node cluster and I
have installed SQL within the cluster.  I just need clafication that I only
need to run the setup and just select integration ...

Can I rename my virtual cluster name that has SQL 2005 installed after I
build it for example if the virtual name is MASTER_New to MASTER?
thanks,

I was trying to move the msdtc resource to the msdtc group and I have messed
up the cluster by taking too much offline in an attempt to move it. now I
don't have access to the cluster as the cluster ip, network name are
offline.

I need your advise on migrating a two node SQL 2000 cluster to new hardware
including servers and disks.
thanks.
Amila

WE have a 2 node win 2k3 x64 cluster (also x86 clusters with same problem)
with 2 instanses of SQL 2005 x64 and the MSDTC resource  in the admin.
cluster group (quorum group).
This is a active/passive cluster, all 3 groups/vir. servers on same node.

Can anyone give me some tips on enabling encryption on an active/active
cluster?   the particulars as I understand them:
1.  Encryption is enabled on each node, and
2.  Each nodes encryption is based on a certificate from Certificate