Does anyone have a step by step for setup of a SQL 2000 A/A/P cluster on Windows 2003? I just want to make sure I get all the components installed in the correct order. thanks, Jason ...more >>

hi, have setup sql servers as a standalone. I need to configure a new server using clustering. Can someone point me to how to set up sql clustering on win2k please ? TIA MOE...more >>

I wanted to run my thoughts by the gurus here. I think I'm on the right track, but I just want to get some confirmation. This morning I tried to upgrade our NT4(SP5) SQL7(SP2) 2-node cluster. When I ran the Failover Cluster Wizard on the primary node and broke the cluster, it apparently did ...more >>

Hi Guys, We have been having issues with the SQL Server 70 cluster (Active/Passive) sp3 which was installed even before i joined my client. It keeps failing over every night automatically and its because of one of the resources called VSRVSVC.EXE (it says generic service on the cluster admi...more >>

Hi, I really would appreciate any help on this. Can a very large transaction log have a negative impact on write performance?? We were having a problem with VERY slow writes (30 seconds each) to a database. Reads were very fast (0 ms). The app is running on a Windows 2000/SQL 2000 A...more >>

andrew.collins@quest.com I have a Windows 2000 advanced 2 node cluster setup. I used VM Ware to build both nodes and I have virtual SCSI for the quorum and shared disk I successfully installed SQL to the cluster. However I did have to install to each node separately since a "race condi...more >>

Hi I want to implement Active/Passive clustering sql server, I am wondering if I can access to the idle server and run program (for instance, microsoft word, sql enterprise) by using terminal service Thank you very much. ...more >>

Can I have another Virtual SQL Server on the existing Cluster (MS SQL 2000 Cluster)?. Current configuration is SQL SERVER 2000 EE in an Active/Passive two-node Cluster Configuration. For example Cluster Name is CLUST1 and VIRTUAL SQL SERVER is VS1. My intention is to have one named instan...more >>

Hi All, I'm facing a problem reinstalling SQL2000 on windows 2003 cluster. As I'm trying to do migration, I did a test installation with a default name. Then, I wanted to change my instance for production purpose. For some reasons, I could not uninstall from the SQL installation CD, thus...more >>

Our quorum size in the MSCS folder is stuck at 32kb. The Reset quorum log at: is set to 4096 With it being at 32kb for sometime now is it best to stop the cluster service and Start up with the parameter -noquorumlogging Our failover is not allowing all of our home directory shares to ...more >>

We currently have an existing W2K Advance Server running SQL 2K EE and are planning on implementing a cluster using the existing server. Anyway to upgrade the existing database to a clustered install or do we need to uninstall and reinstall after the OS cluster is established? Looking fo...more >>

Hi I have SQL2K SP3 on W2k SP4 in an active passive cluster. Recently I have had problems with the cluster either failing over or attempting to and then hanging in an inaccessible state. The following errors appear in the W2K Application log... [sqsrvres] CheckQueryProcessorAlive: sqlexecdi...more >>

Hi I wanted to configure Failover cluster for SQL Server 2000 on Windows 2000 advanced servers I have only 2 no.s of windows 2000 advanced server m/cs. I dont have any shared disks and SCSI drives. Can I still configure the Failover clustering I would like to know more about the need for the s...more >>

Hi everyone, I have a Design Question about clustering SQL. I know clustering is = an expensive solution but I was given a project to provide high = availablity for Sharepoint Portal Server 2003. The environment = involves over 1400 users and I was given two HP BL20p servers to work = wi...more >>

We have a pair (active passive) of SQL 2003 running in a cluster. The problem is that the virtual SQL server only appears on one of the two networks we have running. The settings under SQL IP in the cluster manager only allows you to select one network. I want to be able to access the vi...more >>

Hi there Are any of you using merge replication to increase the availability of your sql server? I have a clustered sql server 2000 but I need to cover for the eventuality of loss of network connection to the datacenter or other event that would put the cluster offline. At first I set up log ...more >>

This is the error SQLSTP log file from the active node to the passive node which has already joined the cluster. The unattended install failed to kickoff or complete. I have seen another thread which was a terminal server issue. We do not have terminal services enabled. I am using the domain account...more >>

Hi all We are planning to set up the following Cluster design 4 nodes running 2003 EE and SQL 2000 EE. 2 active nodes and 2 passive for fail over. (In the futre a couple more active nodes will be added. Behind the cluster will be an EMC Calriion SAN. All nodes will have 2 HBAs connected to the...more >>

I know that standard edition doesn't support Clustering, but my question is, can we still install SQL server Standard edition with the processor licenses on one of the Clustered servers and not use the clustering capability? Will this even install correctly and if it does, is the licensin...more >>

Setting up a 2 node cluster with SQL 2K on Win2k3. How many servernames/clusternames(virtual servernames) do I need ? Upon setting up with windows clustering MSCS , i need to create a virtual name right and have a virtual IP ? Do I also have to create another virtual name and another virtu...more >>

I have a two node cluster. One node has crashed and I need to know the best approach to rebuild the second node. In my case the node crashed from a hardware failure. This client did not have a good backup of the system state for this node. But I have a working node up and still running. We have evic...more >>

Should I run my transaction log on Raid 1 or Raid 5? How about the data file Right now I have them both running on Raid 5 Thanks for the help....more >>

Hi am looking how many nodes SQL Server is supporting with Windows 2003 depending of the version : 1. Windows 2003 Enterprise with SQL Server 2003 Enterprise and a traditional quorum 2. Windows 2003 Datacenter with SQL Server 2003 Enterprise and a traditional quorum 3. Windows 2003 En...more >>

I have a two-node SQL2k active/passive failover cluster on WIN2k ADV SP3. I would like to install a new instance of SQL2k for another application in the failover cluster. Please advice. Help appreciated...more >>

We would like to setup a two node cluster using windows server 2003. We do NOT have a shared, block-level disk device to use for the quorum disk. Windows Server 2003 however provides an alternative, optional quorum mechanism that is known as the majority node set. The question is: Can this mechanism...more >>

We are going to implement Cluster Server on Win 2003 SQL 2000 SP3 Application is web based and there are some batch process . Need clarification on this 1. If the active node fails and when second node takes over , and if users are modifying data , what happens to these modifications. Bas...more >>

Hi, I have a 4 Gb RAM , 2 Xeon processors machine running SQL Server 2000. I have a large number of records and it seems to be collapsed. I would like to upgrade this configuration , and someone told me about clustering the database. What I would like to know is : - Is a active/active sql clu...more >>

We're in the process of building new servers. One would be Win2k Advanced, Cluster Service, and SQL 2k Enteprise. The question I have is what's the install order I need to take. My intended order is: 1. Win2k Advanced 2. Cluster Service 3. Win2k SP4 4. Patches released after SP4 5. SQL 2k ente...more >>

Hi, I am planning to install two nodes clustered sql server, should I install domain contraoller in both nodes with one is PDC and another is BDC?or it has to be PDC only? ...more >>

This is a Windows 2000 Advanced Server that is clustered with SQL Server 2000 with SP3A. This is a Active/Active Cluster setup with a A and B node. I have two drives that will failover to other node on a failure. On a test we failed the server which caused the SQL Server, SQL Agent, SQ...more >>

Hello all. We've just built a Windows 2003 EE active/active cluster. SQL Server 2000 is installed on each node. MSDTC was installed after-the-fact and is not working properly, i.e. working for some applications, not for others. MSDTC was originally set up in one of the SQL Server Groups, del...more >>

now I had a cluster ,want to add mssearch serive to the cluster,because our sqlserver need to use fulltext,but when I add it to the cluster,the cluster will change to another server immedialtly,but it find the service can't run at the server ,so it change to the former server too,and such happens...more >>

Future Environment: Cluster of 2 node IBM x445 4 CPU 2.0 GHZ 4GB Memory each server. 1 Controller IBM FastT700 with 2 EXP700. 26 FC-HDD 74GB 15K in RAID 1 + 2 Hot Spare Tape and so on... I am in the process of configure this new cluster and I have a question about where to place db files ...more >>

We had a hard disk fail which caused our SQL 2000 database to turn gray and say 'Suspect'. I detached the database and tried to reattach it. I get the following error every time I try to reattach it: Error: 823, Severity: 24, State: 2 I/O error (bad page ID) detected during read at offset 0x00...more >>

Why do we use a cross over cable and not a straight cable for the private n/w of a cluster? What is the difference between the 2 ? ...more >>

What scenarios would result in bringing the cluster down/offline ? I mean.. in situations when you apply OS service packs/security patches or SQL Server service packs.. To apply any of the above , is it as easy as fail over to other node i.e secondary while you apply all the patches on one and f...more >>

Do we need MSDTC for clustering ? Using SQL 2000 ...more >>

Whats the minimum no. of IP addresses I need to setup a SQL Server 2000 cluster and where do I need to use them ? Need to grab some from my n/w admins . Just testing the clusters ...more >>

Hi, I am trying to setup SQL 2000 Ent. on 2 node Windows 2003 Cluster in Active/Passive mode. The setup hangs at the point where it needs to display the disk selection dialog box. Below is an extract from the sqlstp.log file; ********************************************************** 14:49:2...more >>

Hello to all At this time I have problems in configuring a cluster in windows 2003 64 bits it has server itanium, with an external storage Eva3000 HP the problem that gives u the problems es fdisk error Reservation of cluster disk 'Quorum' has been lost. Please check your system and disk c...more >>

Tom, Affinity mask is also set to use all procs. Any other thoughts?...more >>

This is configured to use all processors. Do you have any other ideas what could be causing our problmes? Currently, we have hyperthreading turned off through the BIOS of our machine. Obviously, turning it back on won't hurt, but do you think it will solve our problem. Any help or idea...more >>

We have 2 IBM xSeries 360 servers with 4 processors and 8 GB of ram in each. These machines are setup in a clustered environment. Originally, these boxes had 2 procs in them and we added the additional processors 2 weeks ago. What we have noticed is that our execution plans are not usin...more >>

Hello, I have sucessfully setup a 2 node win2003 cluster w/ sql2000. I can move all sql resources to node 2 just fine when node 1 remains up and running. However whenever i shut down node 1 and all resources bounce over to node2 everything comes back online except: SQL server SQL serv...more >>

Hi guys: I would like to acquire a little hands on building a clustering environment. As per my initial readings, this is what I would need, could you guys let me know what I am missing or misinterpreting? Thanks HARDWARE 1) build two computers, preferable with similar hardware components...more >>

Hi I'm currently setting up a SQL Server 2000. My configuration is: Instance MyCompany running on ServerA Instance TheirCompany running on ServerB TheirCompany is mapped as linked server into instance MyCompany In my situation, the data in TheirCompany is only located on ServerB due to leg...more >>

Hi everyone, As of today, we are unable to connect to the SQL Server connection with Enterprise Manager. The operation fails with the following error message: A connection could not be established to DBCLUSTER01 Reason: Invalid object name 'master..spt_values'. Invalid object name 'maste...more >>

I am trying to move my pubs and northwind log files to a different shared disk on a clustered system (because I have data and logs separated). I am trying to do this via detach and attach db. I can detach the db just fine. However, When I try to copy the .ldf file to its new drive location I get...more >>

I have two servers, one server was set up with Windows 2000 Advanced Server that was clustered as a stand-alone and installed SQL Server 2000 Enterprise with a virtual name. I purchased another server and need to cluster this server with my first server. Both server have SQL Server 200...more >>

Hi al I have a scenary SO Windows 2003 Enterprise edition 64 bits, I built a cluster on two nodes ... than install SQl Server 64 bits i beginning to choose Virtual Server, choose the group SQL Server disk , put the name instance and finished when executing the setup of SQL Server CD again, to cr...more >>