I have a Active Passive cluster on 2 DL380 compaq prolient servers. I have installed WQuin's File screen and Disk quota and ever since this if I move the resources to the other node it freezes up and i have to reboot the node with the active resources, they then become available on the other no...more >>

How can i install the SQL MSDE (sp3a) with a instance name on a windows 2003 cluster server. A custumer has a windows 2003 cluster server. When i run our setup, with parameters like intsance=myprogram, the software installs normaly on the server. Our client software louks voor %Server%\...more >>

Is there an elegant way to clear out the ADO connection pool used by the SQL Server State Service following a cluster failover? We are using a SQL Cluster to store both the ASP Session State database and our application database. When the SQL Server cluster is failed-over, any "pointers" to ...more >>

Hi all, Firstly let me apologize if any of my questions sound stupid. I am a newbie when it comes to SQL Server. We currently have 1 server running SQL with a couple of databases collectively approaching 2GB. The HDD's are configured on a RAID 5 and everything has been running OK. We just recentl...more >>

Few questions and problems. My config: 2x HP DL380 Servers with local c: and d: EMC SAN providing 3 disks to me (100gig, 150gig, 4gig) 4 gig is configured a the quarum drive. 4 gigs of ram My Goal: Active/Active configuration of SQL Server 1st node running SQL Server Ent Ed...more >>

Environment: Windows Server 2003. 2 node Cluster single instance of SQL Server 2K sp3a. 1 SAN. Cluster groups are: - Cluster group with its own default resources. - Oracle group with its own resources. - SQL Server group with its own resources (Server,services,disks,ip address....) Disk ...more >>

OK, here is the scenario. We have bought some nice new servers to replace our 3 year old ones. Also, we are migrating to Win2K3. Managed to upgrade the current active/active cluster to Win2K3 and all is well. Following a Microsoft whitepaper on how to upgrade, it tells us that we need to evict...more >>

Hi all, We have 3 server, compaq 570ML and try to find out the way to increase availability and fault tolarency with MS SQL 2k server, W2k AS. I heard SQL failover clustering is not possible without disk array, is it no way? Regards ...more >>

Hi, We're in the process of architecting a very large SQL2K database. We believe this database will grow 2TB per month. 99% of the inserts will be done via bulk inserts. Approximately 3-4 per day an application that we wrote will query and pull approximately 6 million records at a time. ...more >>

Hi, Is it possible to have 2 sql servers inserting into the same database. In my specific case, the servers would be inserting to different tables and there would be no overlap. I don't want to split the database because reporting would be based on data from the whole database. I guess this...more >>

I have a server that has SQL Server 2000 with SP3A with Windows 2000 Advanced Server with an Active/Active. We are presently not using the SQL Server 2000 Fulltext. How can I disable the SQL Server 2000 Fulltext service? How could stop the service and disable the service to restart whe...more >>

Hi! I have two-node cluster on Windows 2000 Adv Server sp4. There are two instanses of MS SQL 2000 Server sp3, one on each node. I have one physical disk owened by the first node, that is not used. I need to transfer it to the second node, name it with the letter this node already has (rem...more >>

This corresponds to the Microsoft Article 819546. On a clustered instance of SQL Server 2000, data storage on mounted drives is not supported. This applies to Windows 2000 and to Windows Server 2003. Mounted drives are sometimes referred to as "mounted volumes," as "m...more >>

I have a SQL Server 2000 Enterprise Edition on a Windows 2000 Advanced Server. This cluster is set up as Active/Active. Periodically the SQL Server FullText service stops. How should I change my cluster dependency settings so that if the SQL Server Fulltext stops it does not effecti...more >>

Hi, I want to test the clustering environment before implementing the same on production servers. The resources i have with me are high end ( p4 2G , 512MB RAM ) personal computers. I can install 2k3 on two systems .. what do i use for "shared storage".. can i use the shared drive of another d...more >>

Our goal is to monitor the event when our Active/passive cluster fails over to the second node, indicating a problem on the primary node. We are thinking of monitoring thru SNMP with a MIB. Question 1: Where can we find a MIB to minitor Cluster failover to the secondary node? Question 2: I...more >>

I have a concern with a clustered SQL server pair which had a failed node recently replaced with a new server. I am understanding that when I replaced the node, the install of SQL from the original node copied over all binaries, including SP3 files to the new node. But, with the original node as a...more >>

At the bottom of KB article 827449 there is a link to KB article 812666 which is exactly what is needed to recover the Full text search option in a SQL cluster. By following the link or searching can't find it. Any ideas? ...more >>

Our failover has worked before, but this time the sql server agent cannot start. Any suggestions at all about where to start looking?...more >>

Here's an odd one; I was changing the password on a 2-node failover cluster (via enterprise manager, of course) when it asked to restart SQL Server (aka a failover). A normal operation. But, after the failover completed, I was unable to connect to SQL Server via web apps. I was however able ...more >>

I thought of opening a new thread, so it does not get overlooked.. So my problem is that I can't install sp3a on a virtual SQL 2000 server, installed on a Windwos 2003 cluster I have preinstalled MSDTC as a clustered app (according to Q301600) so I guess the install of SQL just skips it, because...more >>

Are there any issues or downtime when running ComClust.exe on a cluster after SQL 2K has been installed? Thanks, John...more >>

Hi, Is it possible for both nodes in a SQL Server 2000 cluster to open up the same .MDF & .LDF file on the shared array simultaneously and still be able to perform standard SQL calls (SELECT, UPDATE & INSERT) without causing corruption, performance degradation and/or sharing issues. I ...more >>

Hi, Where does the msdtc.log file need to be located on a Win2K setup with SQL7 ? ...more >>

Hi, If I have two machine in a cluste - if I install SQL on one will the installation replicate on the other or do I have to install both seperatly - if I have SQL operating on both nodes and I write SQL to one will it replicate over automatically (does it remove the need for SQL redundancy - wou...more >>

Does any one have any experience with MS Clusters and GeoCluster from NSI? Also, does any one have any experience of installing sp3 for SQL Server on a Virtual SQL 2000 on a Windows 2003 Cluster? ...more >>

Hi, we are trying to install "SQL-Server Version 8.00.780 SP3" on a Win2003 2-node Cluster. The Installation breaks, and in the sqlstp.log we find the Message "remsetup.exe not find". In the Knowledge Base we find problems with Terminal Service (no TS installed) and with special character in con...more >>

I have a question regarding licencing on a sql server active/passive cluster. If we have more than 1 instance of the sql server do we have to have to buy another licence for each additional instance?...more >>

I am trying to install SP3 for sql on a Win2k cluster with 4 nodes. I get the following error when it is running. Unable to verify state of SQLServer for upgrade. Please verify SQL is runnable and you have entered a valid password. This happens with either NT Auth or SQL Auth. I am lo...more >>

Can some point to a doc (cookbook) for building a 3 node sql2000 cluster on win 2003. thanks, JR ...more >>

Hi all I'm in the starting phase on planning a cluster enviorment. I'm really a newbie at clustering. I have one question that I will be very glad if you could help me with I thinking of configuring a 2 node, single instance cluster. The reason for the cluster if of course high availability. To ...more >>

Hi, Can I implement logshipping in Clustering sql server?thank you ...more >>

I meet problem when one node of cluster servers go down. The backup node take the shared disk and IP , network name, ..., but can not bring the sql server service on line , failed several times. Does anyone have pro exp. on this senario? thanks David Liu MCSE/MCDBA ...more >>

My question is, How much is going to effect?is the performance degraded to 80%...?If I use raid 10,is going to solve this problem, thank you for your help. ...more >>

We have problem on our 2 original sql instances in a 4-node cluster. Both the 2 old instances get one warning and one error message in the event log. This is the warning message for one of the instances: **** Source: Microsoft Search Category: Gatherer Event ID: 3055 Description: T...more >>

I have installed a dual node active passive W2K3 Clusters with SQL 2K. The cluster has RAID10 for data and RAID1 for Quorum and Transaction Logs. How do I put the Transaction logs on the RAID1 disk as at install SQL2K only asks where you would like to put the SQL data ? Any tips appreciated. ...more >>

Hi final question for now! I have installed an active passive 2 node cluster and it works fine. What things should I look out for which don't behave the same way as when you have a normal non-clustered installation? I realise this is a vague question, but any advice would be welcome TIA Fred...more >>

Hi what is the recommended way of applying a service pack in a 2-node active-passive cluster Regards Fred...more >>

Hi what is the standard way of getting notified on failover TIA Fred...more >>

We can't get SQL 2000 to load on the new node (successfully added to the cluster). We are using the procedure How to add nodes to an existing virtual server (Setup)(from BOL). When asked for computer name we entered the SQL cluster name for the virtual server. When asked for the logon we used the...more >>

Given tempdb is recreated on startup is there any reason it must reside on a shared cluster resource After installation to the shared resource (because other systemdbs will need to reside here), i would like to move tempdb to internal disk Has anyone tried this? Or have any reference material th...more >>

I am running a sql server 2000 cluster on a windows server 2003 machine. Every time I try to install MSDTC it fails and this is what is in the Event Viewer: MS DTC setup failed to populate the shared cluster registry. The DTC resource will not be able to come online.Error Specifics: d:\n...more >>

What is the right procedure to start an instance of a clustered Active/Active Sql Server The online-book unspecifically writes From a command prompt, enter: sqlservr.exe -c - But some KB Technet articles say do start/stop SQL instance only from cluster administrator So how to do it Thanks...more >>

Looking for some advice on an issued that just popped up. Not sure if this was the cause but after applying MS04-011 and 012 MSDTC will not run on the primary Node. Main application error message is: "MS DTC was unable to start because the installation of was not configured to run on a cluste...more >>

Hi All, I'm posting it here since it seems that the way we access an SQL server in Culster could be very similar. I'm trying for quite a few days, without any success, to find out how to obtain basic info from a Clustered Exchange 2000, such as Mailboxes list, Storage Groups..., etc. How sha...more >>

Has anyone had difficulty with UDF's in a clustered environment? We have some DTS code that references a user defined function. When we run the DTS package on non-clustered servers, the DTS package executes in several minutes. However, when we run the same code against the database in a clus...more >>

Hi, I got this error occasionally. I am using two nodes SQL Server 2000EE cluster running on Win server 2003, it's an Active/Passive configuration, and they pull data from a public external RAID. I have applied all latest SPs and installed MSDTC properly. SQL is still working fine. It s...more >>

Environment: Clustered SQL Server 2K sp3a (single instance) Product version: 8.00.760 Problem: I end up in error 17883. I am aware that the solution is to apply this patch: 821277 MS03-031:Security Patch for SQL Server 2000 Service Pack 3. I am also aware that after you install this cumulat...more >>

Hi all I'm looking for step guide to set up SQL 2000 with W2K3. I could only find SQL2000 with Windows 2000 Thanks Cheers Kok-Mun, Ho...more >>

We are looking at installing a 2 Node ACTIVE/ACTIVE SQL Server configuration utilizing two DELL PE6600 servers, both connected via FIBRE to a DELL CX200(CLARION). The OS will be clustered in a ACTIVE/ACTIVE configuration as well. The main purpose for attempting this is more for spreadi...more >>