Is there anything different to setup a MSDTC cluster resource other than running comclust.ext in windows 2003 ? ...more >>

While setting up windows cluster in 2003, my external array which is logically partiotioned into P and Q appear as one disk group. If i wanted to setup an active/active SQL cluster, how can i seperate into 2 groups, so that one node owns P and SQL instance 1 has data files on P and the other nod...more >>

Setting up sql 2K cluster (single instance) on win2003 Does the path for the program files have to reside locally i.e on the local disk subsystem and not the shared disks ? Also my internal array i.e. local disks are broken up into C and D drive.. When i install SQL on node 1 and spe...more >>

Setting up sql 2K cluster (single instance) on win2003 I already have win2003 cluster service setup. I have a virtual server name and a virtual IP.. Now when I install SQL , what do I enter when i select virtual server ? Do I put in the same name as the Win2003 virtual server name I ent...more >>

I managed to successfully install the Windows clustering service on Node 1 of my active\passive setup environement on win2003. The only thing i had done on Node 2 was install the OS and did not configure the shared disks on the shared array... I now powered Node 2 and wanted to go to disk ma...more >>

Hi! I have a customer with a 2-node active/active sql2k cluster hosted on w2k. We now want to run this on w2k3 and we also want to build up the cluster to have a 4-node active/active/active/active sql2k cluster. Our plan is to do it in two steps as follow. We take the current 2 nodes of...more >>

Hi, I have installed SQL 2000 Enterprise Edition SP3 on a Windows 2000 SP3 Cluster. Everything went perfect. The database server is running. But when I initiated a failover to the other node, the SQL Server Cluster Resource fails. In the event log on the node where the resource failed I get...more >>

I want to setup SQL clustering but I seem to be hosed at setting up Windows Clustering. I want to setup a single instance ( Active/Passive ) using Windows 2003 EE and SQL 2000 When do i power up the second node ? Is it only after you configure Node 1 and even set up the cluster service ? I see...more >>

I would think there should not be a problem, but I just want to make sure. We have 2 win 2k servers in lets say Cluster 1 (running sql 2000). We are wanting to upgrade these 2k servers to 2003 server (obviously running sql 2000 since we don't have a choice). Our plan is to fail one s...more >>

Hi, We have recently setup a new cluster server. At the moment the resources have swapped over so that 1 is running on node 2 and vice-versa. However this appears to be causing a problem with the SQL scheduled tasks. All tasks in the list have (Date and Time are not available) under '...more >>

Hi, The Jobs in my sql server 2000 are hanging.The backup job backs up all the 30 databases except 2 of them,but the job never completes. I have to cancel it each time.I dont find any errors in the Win Event viewer or SQL error logs.When I use check db on tempdb I see two temp tables with the...more >>

I have a client that's having an issue where after changing the SA account password the SQL server is throwing a security error stating that the SA account doesn't have access to view XYZ. The application calls a stored procedure that builds a query string that is run against a fully qualified v...more >>

I will be replacing the shared storage system for a 2 node Windows 2000/SQL2000 cluster in a Windows NT4 domain. Replacing Compaq RA4100 with an HP MSA1000. My plan is to completely deconstruct the cluster and SQL virtual server, reinstall operating systems on nodes, recreate the clust...more >>

Almost everybody might have come accross this situation and handled it easily, but we are at the first step in setting up SQL Server cluster. I am contact person for the setup in my organization and I have no idea how to set up, and at the same time the NT person is also new to windows clustering. W...more >>

We change the IP addresses on the cluster and now are having problems with performace. We had to search through the registery and find instances of the old ip address and make changes to the registery. If I had to do this over I would not have done it. But to late now. NEED help. Thanks...more >>