Hi all I have just installed a SQL2000 cluster on Win2000. The last thing I did was install sp3a from Node A (both Nodes were online) Checked the version by using @@version - both instances came back with sp3a. However, in EM, Node2 is showing in properties as RTM and Node 1 is showing ...more >>

Are there any 'gotchas' that one needs to consider before running this on a single node - anything different than a stand-alone server? Thanks! Darryl Pollock Squirrel Consulting ...more >>

Hi, I'm currently looking in the possiblities for a SQL server install. The web project needs a SQL database with a high availability. Speed and size are not that important as the load will be medium (especially for the new enterprise class servers), but it cannot eb offline for more then m...more >>

I need to change all of the ip's on my two node cluster including the nic cards and all of the virtual devices. What i am asking what is the best way to do this with out crashing the whole thing. Also i need to get this done today!!!!!...more >>

Hello I'm about to install a active/active sql cluster on windows 2003 server. I've installed the cluster service without any problems. My question is concerning the DTC service on each node of the cluster. I've yet to configure the MSDTC as a cluster resource, and I can't start the DTC ...more >>

Hi, Sometimes, in my application, when i browse a record, it takes very fast 1/2 seconds but sometimes it seems like hang there and take a very long time around 10 minutes to finish, is it because of clustering? How to check and prevent from clustering? thanks. regards, ...more >>

Hi, Sometimes, in my application, when i browse a record, it takes very fast 1/2 seconds but sometimes it seems like hang there and take a very long time around 10 minutes to finish, is it because of clustering? How to check and prevent from clustering? thanks. regards, ...more >>

hi everyone, i had a question regarding Expectation-Maximization algorithm used by microsoft for data mining in ole db. Does anyone know how good this algorithm is when compared to the latest clustering algorithms like chameleon, cure, rock. Does EM create clusters of hybrid shapes or else ...more >>

Hi all, From what I've read, dynamic disks are not supported as shared drives when using a Windows 2003 cluster, only basic disks. What happens when you want to add more capacity to your cluster's shared disk by adding more physical disks to the SAN? Will it work if the shared disks are...more >>

I have a established cluster that I have to move to another SAN. Any words of wisdom?...more >>

Hi all, If I have a striped mirror set (RAID 1 + 0) on my SAN for my SQL Server data files, would I be able to put the mirrored drives in different drive enlosures? I'm trying to cater for the case where a SAN drive enclosure catches fire by putting the disks that mirror the disks in the...more >>

I'm aware of KB article 239885 about how to channge SQL accounts on a SQL virtual server. However, is there an easier way to ensure the account has the correct privileges (i.e. run the SQL Server installation setup again and set the accounts there)? Thanks in advance for your help....more >>

Hi, on a two node cluster, Do I need two seperate SAN boxes If i have to run SQL Servers on a Active/Active clustering?. Regards Chip...more >>

We needed to change the drive path for one of our SQL Server Instances. All system databases have been changed, but we are having trouble changing the FullText. We have edited the Registry, but the FullText service still fails with a path error when attempting to bring online within Cluster A...more >>

Hi all, Assume I have a two node Windows 2003/SQL Server 2000 cluster, with each node connected to a SAN via a single fibrechannel HBA. Will failover be triggered upon failure of the active node's HBA? (thereby severing its connection to the shared disk)? Or is failover only triggered i...more >>

Hi, Could someone please explain to me in an idiots guide kind of way!!! How Active Active clustering works when the underlying Windows 2003 cluster is Active\Passive using mscs with a central SAN. I dont understand how you can run SQL on both nodes when only one node can see the actual SAN ...more >>

I'm planning on building a SQL 2000 cluster, on 3-nodes using W2K3, with 10 instances. All nodes will be active. Each node will have 16GB RAM and 4 CPU's, connected to a SAN. Q1, is it true I can only build a max 4-node sql cluster on W2K3 EE. Q2, Does anyone have any documents on how to ...more >>

Very new to Windows2000/SQL2000 Clustering, recently set up an Active/Passive 2 node SQL Cluster. Unfortunately one of the Collation settings needs to change. After spending some time looking Microsoft site and other support sites it seems that the easiest/quickest way to do this is detach th...more >>

All: We presently have a 2 node SQL 2000 Cluster running on Win2k Adv. Server. What is the Microsoft recommended way to change the SQL Server service account and SQL Server Agent service account running on a win2k adv. server cluster? All help is MUCH appreciated! Thanks, thrillerIT...more >>

Howdy, IIS6 Win2003. Set up the group on Node1. During testing I can down Node1 and groups and resources failover to Node2. After Node1 comes back online, the IIS Service Group failsback to Node1. Did I miss something? TIA for any assistance. Bill...more >>

Hello Clustur Gurus We have an active/pasive mode cluster set up in prod environment. We had a n/w maintainence last weekend. both the nodes were up and running. Due to some error(which is not known why) the cluster failed over to the secondary node. Now the primary node services would not star...more >>

Hi, I am new in Clustering server. Can someone tell if I have one virtual Clustering server named DB01, under that I have two physical nodes named DB02 and DB03, when I install SQL Server 2000 Enterprise Edition which server (virtual or physical node) should I login as administrator? ...more >>