Hi, I'm trying to install cluster service on a Windows 2003 Server Enterprise Edition SP1. I've configured Network and Disk. When I try to create a new a new cluster for the first node, I receive this error: ----------------------------------- Found an existing cluster or node with the name...more >>

Is it possible to take 5 servers and make 4 individual clusters and share the 5th server amongst all of them as the failover node? These clusters would be running SQL 2000 and attached to a SAN enviroment. ...more >>

hi we have 2-node active/active sql 2k sp3 environment and planning to deploy sql sp4. we analyzed the microsoft setup documents but they are not clear and user friendly. anyone knows that how we can install sp4 on 2-node active/active cluster. thanks.. ...more >>

Hi, We are using an Active-Passive cluster environment in our project. So far, we made use of only one instance of SQL Server. i.e SQL Server 2000. New architectural change is introduced in the current version of the project. We will have two instances of Database server. One is of SQL Serv...more >>

Current Config On SAN, two node active/active SQL cluster running W2000 Server w/SP4. Two instances of SQL, one uses default port, other does not. Largest SQL database on one instance is 80G and on the other instance 10G. New Config On Blade Server, two node active/active SQL cluster runnin...more >>

Hi, I have an active-active SQL 2000 Cluster running on Server 2003. Both nodes have a vanilla 2003 OS on them. I tried upgrading each nodes to a new custom build (hotfixes, security templates, etc) and it broke both nodes after I patched the first one. Any suggestions?...more >>

I have a Compaq DL380 G2 package cluster. Prior to the Hurricane (scare) for the Houston area, all servers and the cluster were shutdown/powered down. I am looking for the proper shutdown/powerup procedure for the cluster. We had a hard time getting the cluster to be recognized by the server. ...more >>

Good day, I have recently installed a 2 node cluster server with SQL 2000 SP3 in my network. and have found out that users connect to the Virtual cluster server inorder to receive SQL services but they get the replay for the physical node that holds the SQL. I was wondering if this configura...more >>

I am trying to learn about high-reliability clusters (for IIS and Sql in my case) but there is a fundamental thing I don't understand about the approach that keeps me from swallowing the high-reliability kool-aid: Currently, I have a "non-high-reliability" (low-reliability??) system -- i.e...more >>

Hi, I have a 2-node Active/Passive SQL cluster. It has 4 clustered drives (F: G: H: and Q:). All drives are on a SAN. I need to move all this data onto a new SAN, and then get the cluster to look at the new clustered drives as opposed to the old ones. This will also mean migrating th...more >>

We have a pair of identical IBM 445s and would like to run them in an active/active cluster. We have a new IBM TotalStorage DS8100 and an older IBM TotalStorage Enterprise Storage Server Model 800 that along with the servers, are a small part of our SAN. We run Emulex & Qlogic HBAs and McData ...more >>

Hello I was doing some research about Windows 2003 Cluster with Majority Node Set and SQL Server 2000 EE support. I found some messages on the newsgroup saying that SQL Server 2000 is not supported on MNS cluster. I also read on SQL Server 2000 High Availability book on page 158 that SQL ...more >>

Hi group, We have a two node windows 2000 sp4 cluster running SQL 2000 SP3 in active/active mode. We just want to upgrade the hardware now, what is the easiest way? Can you remove one physical node while all sql instances are on the other one. Then take the new hardware, add it to the clus...more >>

we have a sql server instance on a 2003 cluster which was built with the wrong collation. are their any cluster related steps that need to be taken into consideration when running the rebuild master utility to correct the collation? we have multiple instances running on the cluster. does the ...more >>

Hi, I am having a problem when I try to move resource (sql server service) from one group to another. Moving other resources works fine but not SQL. I have two SQL server s 2000 sp3a on two win 2003 servers on an active/passive mode. I got two error messages: "Cluster resource SQL Server (i...more >>

Microsoft’s SQL Server 2000 Failover Clustering doc states the following under miscellaneous configuration issues: “Disable or do not install antivirus software on your cluster” and then gives a link to that KB article. The KB article explains this as the reason why you might disabl...more >>

On a Windows Advanced Server 2000 2 node cluster with SQL 2000 SP3 installed, I'm trying to apply SQL 2000 service pack 4, but at the point where you enter "a username and password that is a valid administrator account on all nodes in the cluster", I do that but get this error: The specified ...more >>

I'm testing SQL 2005's Mirroring capabilities. I need to implement a high-availability solution to the 1-server problem, but without a cluster server ($$$$). So SQL Mirroring is the key. SERVER_A (main) and SERVER_B (backup) holds replicated data. SERVER_C is the "Synchonize server" (I think ...more >>

I am a little confused on what is exactly needed to cluster SQL 2000 on a windows 2003 cluster. Does anyone have a link or a doc to the actual step-by-step instructions for this procedure? Thanks in advance Aaron ...more >>

I have an active/passive SQL 2000 SP3 cluster with a default instance attached to a SAN. The SAN data is replicated to a contingency site. On the contingency site I have a single node cluster. I intend to create a virtual server on the contingency site with the same name as the live server, bu...more >>

Hi, it is good practices to have in a table (Hotels) Index not to cluster on the HotelID column and Index to cluster on the foreign column HotelID in a table details? Thank you -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-clustering/200509/1...more >>

In Rodney R. Fournier's blog it states: "If MSDTC is used with SQL, you should ensure it is in it's own group, on it's own disk resource. Lastly, Microsoft recommends to run the MSDTC & SQL group on the same node, and that the MSDTC is brought online first when the groups are moved." ("http:/...more >>

I have a 2 node SQL 2000 clister running on Windows Server 2003. SQL is patched to SP 3a. Both the cluster service and SQL service use domain account to start up. The domain accounts as members of the local admin group on both cluster nodes. On our active node, everything works fine. When ...more >>

I was hoping to clear up a few points of confusion regarding share-nothing clustering... My experience with clustering is that it is meant to address high availability needs. However, with share-nothing clustering you seem to be addressing scaling out needs, so perhaps my old ideas about c...more >>

Hope fully there is someone who has done a similar stupid thing! We have got ourselves into a bit of trouble when MDAC 2.7 was accidentally (?) installed onto our Windows NT Cluster wich still runs SQL 7.0. The result was that the SQL Agent stopped working. However the 2 applications tha...more >>

Did anyone implement Active/Active cluster configuration in MS Virtual Server 2005 env? I successfully completed it for Active/Passive configuration. -- Posted using the http://www.dbforumz.com interface, at author's request Articles individually checked for conformance to usenet standards ...more >>

Is it possible to set up a 4 node cluster with 3 sql instances using SQL2005 Standard edition. I understand that SQL 2005 will only support two node clustering (failover) under standard edition so what I plan to do is: Primary Node Failover node Instance 1 B ...more >>

Necesito montar la infraestructura para un portal, que estar=E1 desarrollado con ASP contra SQL Server. El sistema ha de ser redundante y a poder ser escalable. Para ello habia pensado en el siguiente esquema : - 2 Servidores W2003 con IIS6 con NLB para el frontend. - 2 Servidores W2003 con...more >>

What is the best way to set up a 2 node cluster for SQL server? We are just beginning and a couple of the apps. One that used DFS and one that mapped a drive were complaining about the clustered environment....more >>

Normally, clustering is setup as a 1-to-1 relationship between active and passive nodes, at least that is my understanding. We have a situation where we are being asked to setup a 2 active node, 1 passive node environment. Here's the question - if one of the active nodes fails, it fails over to t...more >>

Please Help I have spent 2 full days trying to install SQL Server 2000 Failover Clustering on a MS Windows 2003 Enterprise Edition Server, but the installation will not start the SQL cluster resources and complete. Firstly, my MS Clustering service is installed and working. It is a 2-node ...more >>

All, We're currently running Veritas Storage Foundation HA 4.1 for Windows with Veritas Cluster Server Enterprise Agent for SQL. This is a 2 node cluster running 2 SQL instances The OS version is Windows 2000 Standard edition (fully patched) The SQL version is SQL 2000 Standard Edition (fully p...more >>

Hello, I am attempting to change the location of the log files for one of the default SQL instance, every time I click on the .... button under Properties of the instance/Database settings/default log directory, I only receive the single drive that the SQL Server instance was installed on, ...more >>

I am running a Windows Server 2003 cluster with SQL 2000 SP3a. When node 1 fails everything moves to node 2 without any problems. However, none of the users can access the SQL datbases. I am using Windows authentication on the databases. I have verified the security settings from within th...more >>

I am new to setting up clusters and also by no means a SQL DBA. I have some offsite help to assist me with SQL but we are both confused about how to set up MSDTC. I have read the webcast found here: http://support.microsoft.com/default.aspx?scid=kb;en-us;888121 And it speaks of setting up...more >>

I want to use the SQL Server with Network Load Balancing. Can some one please let me know how it is going to work? Anyother technique which i can use SQL Server as Load Balancing in the Clustered Environment. ...more >>

Hello Following on from a previous thread posted on 8/9/2005, titled "Need advise on SQL Server installating in MS cluster 2k3 Majority", I am currently evaluating some solutions to install SQL 2000 on Windows 2K3. One of the requirements is to use current clustering technologies, with pro...more >>

I have a Windows 2003 Enterprise Ed. server running SQL 2000 Enterprise Ed. with SCSI attached storage. I have a new server (identical hardware), HP fiber switches, etc to build a SAN config with the existing storage. I can build the SAN portion fine, but I don't know how to transition the ...more >>

We are going down the road of configuring our server per: KB: "You receive error messages when you perform a distributed transaction when you have a SQL Server 2000 virtual server in a Windows Server 2003 clustered environment" (http://support.microsoft.com/default.aspx?scid=kb;en-us;889706) ...more >>

Hi, We have SQL Server 2000 cluster named instance installed on Windows 2003. I knew that SQL Server services can stop or startup use Service Manager or Cluster Administrator tools. Except those two can I use command line stop and startup the services? Regards! -Chen ...more >>

I had 1 node of a 2 node SQL 2000 SP4 cluster fail. I had to rebuild node 1 and added back to the cluster I installed SQL 2000 to the non-failed node and then applied SP4 to the same non-failed node. The setup failed. There was no NEED_SP_KEY in the registry which I am aware would need to be de...more >>

I like to configure sql cluster with one NIC (two nic but teamed) . Anyone tried it? Does it works. I know MS does not support such configure. Once cluster servers configured? Can I change the server names, and virtual servers and sql virtual server name? Also the ip addresses? And add res...more >>