I have an existing, two-node Windows 2003 cluster running four instances of SQL Server 2000, SP3a. I have two additional nodes that I now want to merge into the cluster. I connected the existing cluster disks to the new servers. I ran SQL2K setup and successfully laid down the binaries. I ...more >>

We moved a large database & application from a single server with RAID drives to a clustered server with a SAN and are not seeing any performance gains. Statistics were updated, procs recompiled, etc. after the move. The CPU load is lower (as seen in perfmon), and the SAN disks are also not wo...more >>

Hi! I have a problem with a 4-node cluster. It was a 2-node sql2k on w2k. We installed new hw with w2k3 and installed the old instances there (restore). After that we added 2 more w2k3 nodes and installed the original 2 instances on all 4 nodes. We also set up 2 new instances to be a total of...more >>

We’re having a problem with our web applications connecting to the SQL DB virtual server cluster. We are running SQL 2000 an '03 Server Cluster. The front-end web servers are Win2K, IIS 5. The web servers and the database server reside on the same LAN and the front end can ping the backend u...more >>

I have a SQL 2000 cluster and have applied SP3 to it. However, when running on one side of the cluster SQL reports a different version to when it is running on the other side. Is this normal / expected or has it not applied SP3 to the other node correctly? e.g Running on node 1 select @@ve...more >>

Hello all... Win2k3 enterprise SQL 2000 2 nodes I had 2 instances of SQL installed. I had to run setup to remove clustered SQL so I could break the disk array and make it larger. Now, I install instance 1 on node 1 just fine. But when I run setup on node 2 to install instance 2, it tells...more >>

I have setup a production sql server cluster, as ususall I setup MSCS first and do the failover test. I use dual fiber channel card for redundancy, but I meet prob: Broke one fiber connect. Passed it did not fail over because it is redundant. Broke second fiber connection. CLUSTER FAILE...more >>

A client of ours wants to run a clustered instance of SQL and not have it dependent on name resolution for anything. Since it appears that SQL is heavily dependent on AD and DNS for the virtual server piece, does this dependancy constitute a single point of failure? ...more >>

I'm in the process of upgrading the operating system from Windows 2000 Advanced Server to Windows 2003 Server. The server is clustered one is Windows 2000 Advanced Server and the other Windows 2003 Server. Before I upgraded the operated system both Linked Server worked fine. This is...more >>

We have a 4 node Windows 2003 cluster with 3 Instances of SQL Server 2000 already installed. I am trying to install a 4th node on the cluster and the install fails right after I enter the Virtual IP for the 4th Instance. I'm using all the same settings as the first 3 Instances. Any sugg...more >>

Question, can SQL Server 2000 SP3 (not SP3A) be applied to a windows 2003 cluster? I tried this recently (two times) and received "the required operations did not complete". However, the sqlsp logs state that the installation was successful. Will soon be migrating some databases over fr...more >>

Hi All, we are having following Servers: 1) Webserver 2) Application Server 3) DataBase Server All are running on Windows 2000 Advanced Servers Application server and Database server are in a one domain namely ABC.com and...more >>

I found several great step by step articles on clustering in windows 2000. What do I need to change in order to work with windows 2003? I read the previous posts and it seems the setup is almost identical. Thanks for your help Andrew...more >>

Hi: I cannot install SQL 2000 on a win2k3 cluster, I get the error: Setup Failed to Perform Required Operations on the Cluster Nodes. Here is the SQLSTP.log file: 13:22:32 Begin Setup 13:22:32 8.00.194 13:22:32 Mode = Normal 13:22:32 ModeType = NORMAL 13:22:32 GetDefinitionEx returned...more >>

Hello: I'm sort of new to clustering and some of these questions popped into mind: - From an administrative perspective, which of the two is more easily manageable, Active/Active or Active/Passive? - When would one want to use A/A or A/P (i.e. how to evaluate key objectives to determ...more >>

Hi all gurus I am having a strange problem. I am having a cluster box win 2000 Advance server running Sql server in Active/Passive mode. Currently we are having 250 + prod database on that box.I wanted to do some Perf. Tuning on the box But i cannot see any of the Sql related Performance Count...more >>

Hi! I need to make an active/active cluster out of two servers. One of them is critical and has huge number of published tables, so I want it to be available the sooner the better. What is the best way to do this? When moving critical servers I practiced this aproach: 1. Stop sql-serve...more >>

Hello to everyone I have two dell Poweredge 2650 units and a 6 Shared Hard drives with format RAID -5 . The two units are clustered together via windows clustering services. Software called PowerSun on each machines along with the cluster owner tells which has ownership of the SAN. Wha...more >>

Hi, My client is getting a new SAN solution. It will use VRAID5 and will have seemingly boundless storage cabability. I am happy enough with the storage aspects. The bit I am worried about is the Virtual RAID from a performance point of view. There is not much info out there on it. -...more >>

Hi, We are in process of upgrading all Win2k boxes with 2 node clustering which includes SQL server 2000 failover clustering to Win2k3 2 node clustering. What are the pros and cons. pls point me to some resources or share your personal experiences. Thanks Chip...more >>

I have a SQL cluster I built about two weeks ago on Windows 2003, now we are trying to restore a database to the server from a different location (non cluster) and we are unable, database seems to go but sql manager states the database is in a still loading state, is there anything I have to d...more >>

Setup Failed to Perform Required Operations on the Cluster Nodes I try to setting up a cluster on two Dell with EMC SAN drives with no success. I have tried everything it's a nightmare. Logfile: 18:28:12 szModifiedList = 18:28:12 szRemovedList = 18:28:12 End Action DialogShowSdVirtualSer...more >>

help! We are running a win2k3 cluster with sql2000, MSDTC seems to be running, and it is added in the cluster resource. I have done the dtctester and I get this result Password: 1paSS4twf tablename= #dtc25732 Creating Temp Table for Testing: #dtc25732 Warning: No Columns in Result Set From Ex...more >>

Hi all, For performance reason, I want to devide all databases over multiple instances. Say 3 instances in a 4-node cluster(win2K3).Active/Active/Active/Passive In this case, the application would need to know on which VirtualServer/Instance the database resides. If there is no way to tell...more >>

Hello, when i purposely cuase a failure of the public nics, why doesnt my node1 failover over to node2? is this by design or is there something i can set in cluster administrator to do this? thank you calvin ...more >>

Hi, We are planning to make clustering with our SQL Server database in our main servier. But I heard once it is been done, all the application which is point to this database should be rework. Is it true?If soo how is it? Regards, Sachi ...more >>

I have a Cluster of Windows 2003 Enterprise Edition, When I try to install a SQL 2000 Enterprise Edition the setup option of Virtual Server appear unavailable I only choose between Local Install or Remote. Thanks for your help ...more >>

Morning, We are running Win2k AD. Ed. SP4 and SQL 2000 SP3a Failover is working fine, and now MSDTC service is required. What are the safest steps to take to setup MSDTC on a live envirmoent? Thanks Carmen...more >>

From what I have read you do have to apply COMCLUST.exe to a Windows 2003 Server on a cluster server with SQL Server 2000 Enterprise? If this is not correct, I have already loaded Windows 2003 Server on a cluster with SQL Server 2000 Enterprise. How would I correct this problem? Tha...more >>

hello, is MSDTC required in order for a 2003 sql cluster to work correctly? ...more >>

I recently moved a cluster out of a one domain to the next. Worked through all the issues and I am still having a problem I can not seem to resolve. When I try to fail over to the second node, I see that SQL Network Name(virtualnamegiven)in cluster administrator fails. When I look in even...more >>

is there anywhere i can get a step by step order for installing an active/passive sql2000 cluster on a win2k3 platform that shares an attached san drive. i have not performed this before and am not sure about how to set up the san drive. do i set up the disks on one or both systems. or do ...more >>

I am trying to setup a SQL cluster with the an active/passive cluster for production. On the passive node, I have been told to create a separate disk and install a developers edition of SQL to use as a test environment. The developers edition will be a named instance of SQL to help isolate...more >>

in an active/active clustering, do the two nodes have the instance of sqlserver with the same name ? can we say that we were serving on two hosts load balancing ? thanks ...more >>

Hi, I am a complete newbie with windows clustering - still reading the white papers etc. From what I have read it seems that I need a Windows Domain in order to run clustering. Is this true? Is there any way I can cluster SQL server without having to setup a domain? thanks christos ...more >>

I am running a multiple instance cluster. Each server has 8 CPUs with 16GB ram. I have a database on each server active where if one node fails, they failover to each other. Any documentation or information for instant notification when there is a failover? Notification by email etc. ...more >>

We have been having a problem where the cluster controller does not get a response from the SQL Server from the "are you alive" request ( select @@SERVERNAME ). It seems that the SQL server does not respond within a couple of minutes and the request times out. The Cluster controller then ...more >>

This is my first cluster setup. I have two identical servers, a RAID array, Wondows 2000 Server Advanced and SQL Enterprise. All new hardware and on the HCL. I create a MS failover cluster, then install the SQL Cluster. I now have (2) physical servers and (2) virtual servers, each complete...more >>

Hi all, i must upgrade the RAM from 2 GB to 4 GB on the Windows 2000 ADV Cluster A/P on both node. There is any problem with the cluster service or SQL to do it ? May i do it first on the passive node , swith istance on the passive (now active) node and upgrade the passive node (previous a...more >>

I have a couple clusters (each with eight processors total, and 16 GB RAM total), but am not getting the performance desired. I "inherited" these, I didn't build them. Can anyone recommend any resources on tuning the cluster and tuning the SQL service for the best performance? ...more >>

Hi all, I have a two-node database cluster built on Windows 2000 AS. After rebooting one of the nodes for updates, it started to reboot on the logo screen when the progress bar reaches the end (just before switching to the blue background and login dialog box). I'm trying to figure out if th...more >>

I am attempting to upgrade SQL2000 enterprise edition on Win 2000 advance to a clustered default instance. I run SQL setup as per the books on-line instructions but on the Existing Installation screen, the option to "Upgrade your existing installation to a clustered installation" is greyed out. ...more >>

Is it possible to setup a second instance of SQL Server Enterprise on a box and setup clustering? I have someone asking me that has only one Server to do this with and they want to learn about Clustering. Win2003 <-> Win2003 (SameBox) OR Can you run SQL Server on an XP machine and still...more >>

I've just installed clustering on a pair of Intel Itanium boxes running 64 bit Server 2003 Enterprise. I've followed the setup instructions in 301600 and 817064 for MS DTC. The disk, ip address and network name resouces come online ok, but the MSDTC resource fails with the following event log ...more >>

Cluster services gives the high availability needed - that is great. But I have never seen any discussion about what happens when a node fails - what do you do to get everything back to the active-passive tandem. I imagine there is not much difference in terms of recovery procedure for eit...more >>

SQL Mail is not cluster aware on a failover, but having it is better than not, I believe. What tasks can be scheduled to check for the proper functioning of SQL Mail on a cluster . Are there any third party tools that can help in doing this?...more >>

We have just setup two servers running a copy of SQL 2000 on Windows 2000 server. Each of these servers is running vendor software that interrracts with the databases. One server is primary and one is backup. Clients only interract with the vendor process on the servers and not the SQL directly. ...more >>

Hi, I have a big doubt about... We have near 20 dbs with many applications that work with. During the days there are many problems about coesistence, because some applications are very CPU and disk expensive. nevertheless the are some applications that require failover architecture so we u...more >>

I joined a company as a DBA the company has cluster servers set up. I was given the 3 ip addresses. i for the cluster and 2 for for the ones the cluster is made up of. and my login is set up to use SQL Server Authentication. How do i connect to the server. I do not know if they are active/act...more >>

We would like to implement 2 node active-passive clustering coupled with log shipping. Clustering is for high availability and log shipping for DR purpose. Do we have any white papers for this kind of setup? Is it possible to host the log shiiping secondary database on the inactive cluster serve...more >>