Check out KB 244980. There appears to be an error near the bottom where it
talks about changing the subnet mask. After step 10, it says "To make sure
that the SQL server IP address is changed, follow these steps:
 a. Check the registry on both nodes for the key that is mentioned ...

I have a SQL Server 2000 Enterprise server with 16GB of RAM.  I have
installed SP4 and the AWE hotfix.
I have 3 instances running on the box:
If I have 1 instance using 7GB and the other 2 are using 4GB each, does

I currently have a single node SQL 2000 cluster running on 2003 Server. I now
want to add the second node, but want to make sure I fully understand the
process. I run the SQL setup from the new node and select the advanced option
for failover clustering. It all seems very ...

I am installing SQL 2005 on a two node 2003 SP1 cluster and get an error
after selecting components and I have narrowed it down to Shared Tools.  The
error is:
"The drive specified cannot be used for program location.  Program files

I am installing SQL 2000 on a Microsoft Windows Server 2003 clustered
environment.  This is a two node active/passive setup.  The servers and
OS were setup/installed and are being housed by an external company.
The setup is as follows:

When I try to connect via IP to a newly created Active Active cluster I
have to add the port to the IP for it to work.  An example is if my IP
is 10.0.0.1 and I try to connect it times out.  if I try 10.0.0.1,1433
then it works fine.  Am I missing a setting somewhere to make this ...

We are going to design our SQL Server databases on either Active/Active or
Active/Passive of Windows 2003 clusters.
Has any one seen real time risk and their real experiences of using
Active/Active clusters?

Iam planning to install multiple instances in active/active cluster.Will
there be ant problem if I use the same name for virtual server and the
instance name ?Any disadvantages?
Thanks

I am installing an SQL Server 2000 Active Active cluster on a Windows
2003 cluster.  I am unable to install the Virtual SQL Server as a Named
Instance.  I can succefully install SQL Server as a local or default
named instance.  I have added the client config utility to both nodes

Does anybody know how I can programmatically detect the name of the virtual
server if sql 2005 is running on a cluster?
In previous sql versions I looked up the following registry entries:
Default instance: "HKLM\\SOFTWARE\\Microsoft\\MSSQLServer\\Cluster" REG_SZ

I would like to rename a cluster name {network name}
from INTSQL1 to lets say INTSQLVS
whats the procedure ?

We have 4 systems that was initially planned to be joined into an
Active/Active/Active/Passive cluster with SQL 2005.  
Can anyone offer a suggestion on the number of instances to install per node?
Does each instance need seperate Disks for the Database, Logs and TempDB?

Hello -- I hope this is the right group.
I have a particular ecommerce application at work that currently runs on one
IIS 6.0 and SQL Server 2000 box.  The web application reads various "theme"
data for out customers to display their particualr theme when they log on.

We have an active-active cluster where SQL server instances are created on
node 1 and Analysis services are installed on node 2. We need to upgrade the
H/W for both nodes? Can I do a rolling upgrade i.e. replacing one node at
time in above configuration?

Hi All, Cluster Group is failing to come online due to cluster name.
Unfortunately running MSCS on Win2k Adv Server so most of the help mentioned
is towards Win2k3...Any luck guys...?
Event ID: 1052 and 1069