I have SQL Server 2000 cluster this is Active/Active. The server has total 4GB of RAM with Windows 2000 Advanced Server. Should the /3GB be applied to the both Active/Active nodes? I would like the primary node to get 2.8 GB and the secondary node to get 1.2 GB of RAM. Please help me wit...more >>

I have an application that uses com components to connect to it's backend sql server db. Right now the db is running on a W2k server (sp4) (non-clustered). I've copied the dbs to the clustered environment that we are migrating all of our databases to, and now the com components do not conn...more >>

I am having some issues installing a second virtual server. The first VS installed fine with no issues and has no issues operating. On the second VS install, the install process makes it all the way through to the point where it creates the cluster resources. But when it goes to bring the SQL ...more >>

We are trying to backup a DB from a W2K3 Cluster running SQL2000Ent. the following is the backup command from the created Job: BACKUP DATABASE [NGProd] TO DISK = N'\\Mviparprtsrv01\NextGenRoot\DBBackup\NGProd_data_dump.bak' WITH INIT , NOUNLOAD , NAME = N'NGProd backup Report Server Bac...more >>

I would like to setup a single node MS cluter with SQL, and I want to migration the application from existing standalone server, during the migration, I have to change the new virtual server name & IP address in order to retain the existing hostname & IP address on standalone server. My qu...more >>

Hi there. I have a MS Distributed Transaction Coordinator qestion which doesnt involve a clustered setup at all. I know this may not technically be the correct forum but I've solved other MSDTC issues here before so I was hoping....! Do you know whether any problems should be anticipated w...more >>

Hello, I have inherited 2 node active/passive SQL Server cluster. I have noticed that SQL Server service is running on active node only. I was wondering if this is normal behavior. In case of failover, will SQL Server service start automatically on passive node? What will happen if new ...more >>

Hello, We are making some changes to our existing SQL 2 Node cluster with Heartbeat cross over. 1). We are adding a third node for Failover. 2). We added new NICS to all three servers and will set the Heartbeat up on a switch. 3). Need to team the other two NICS on each server which I beli...more >>

Hello, I currently have 4 web servers (Windows 2003) and 4 sql servers (SQL 2000) and would like to consolidate these into an entry level SAN. As the web servers are running the same IIS based applications, i'd like to cluster these to use the centralised storage and likewise with the SQL s...more >>

I am looking for some advice on the following problem. I need a redundant SQL solution at our main location and a warm site in a different, off site location. The warm site would only become a hot site if we had a complete failure at the main location. What I was thinking was to create a fa...more >>

Hello, This is my time to setup active/active SQL on two nodes cluster environment. I am very familiar with active/passive in which setup one virtual name such as virtualsql01 and publish to user. For active/active, it seems to me that system does not allow me to have something like virtual...more >>

After running through all the pre-install questions, it begins by saying that it is performing operations on the cluster nodes and then fails with the message: "The path specified in a command line argument is invalid: \\<servername>\admin$\<servername>_MSSQLSERVER.iss" Any thoughts??...more >>

I have a cluster with 16 gb RAM on each server, one instance on each server and no other applications on either server. Do I set the max server memory to 6 gig, 7 gig or 8 gig for each server? I would think 7 gig, if I had a failover I would have 7+7 +2 (for the OS). Do I need to consider ...more >>

I'm building, for learning purposes, a two-node SQL Server 2000 cluster using VMWare; the guest OS is Windows Server 2003, SP1. I managed to correctly configure VMWare to share some virtual disks between two VMs, created a third VM to use as a domain controller, crated the domain, joined th...more >>

Hi, When I install cluster SQL Server in two nodes (active-passive), I used valid administrator account for all nodes. After install, I changed SQL Agent service account for replicate database. SA asked me to change the SQL Server service account to not using currently administrator account...more >>

Hi All, We have a Win2003 Enterprise/SQL 2000 "active/passive" cluster, and we want to split a few larger DB's off to a seperate and new "active/passive" cluster. The reason for the split is to allow this new cluster to control the one application and the other cluster to control the exist...more >>

While away on vacation my company had some software installed that required a new instance of SQL Server 2K to be created on our existing active/passive cluster. Because the techs doing the install did not know the password for our domain cluster user account they created the standalone insta...more >>

hi everyone ! i have one cluster for win2003 mscs , it's active , passive cluster How to change the Cluster service(O/S cluster) account password ? (not sql cluster account..) Thanks.. ...more >>

I have a sql cluster with my virtual server name, IP address, etc. in one group. In the other group I have my sql instance, san attached disk resources, sql agent etc. In this second group I also have a ftp server that utilizes the vbscript for fail over and uses a san disk resource. The ...more >>

Hi, Is it possible to create a single node cluster? I want to have some test for sql cluster, but I only have 1 computer available. a 2nd HD is installed on the computer, i want to use it for quorum, is it feasible? Thanks, Jack ...more >>

Is active/active clustering is also have load balancing . In Active/ Active clustering both the node acces the same database or differnt database , In active/active clustering does the cpu and memory are share by both nodes ? Please clarify the doubts. ...more >>

Hi We are going to upgrade a windows 2000/MSSQL 2000 cluster Anything MSSQL specifics to look out for? I have read the guidelines at: http://www.microsoft.com/technet/prodtechnol/windowsserver2003/library/ServerHelp/2e0186ba-1a09-42b5-81c8-3ecca4ddde5e.mspx tia/Peter ...more >>

Clustering is for availability or for manage a very large database. (10.20.30...TB) Thanks ...more >>

Hello, I inadvertantly mis-edited the SQL startup parameters on a clustered instance and now the instance won't start. I'm wondering if there's a quick fix to correct the problem. (short of uninstall/reinstall <g>) I've researched this and am aware of the problems changing the local regist...more >>

Hi, Sorry if this has been asked before but I can't seem to get a definitive answer on this. If I have a 4 node multi-instance cluster (3 active) does the hardware A. Have to be identical on all nodes or B. That the servers hardware only has to be on the approved cluster HCL? All no...more >>

When trying to configure MSDTC per all KBs I've seen, several resources are required for this configuration. When I get to the point of creating the physical disk for MSDTC, I have no disk to select in the pull down. At that point, it's a stand-still. My partitioning on my array is as fo...more >>

Hi, I have 3 databases on 3 seperate SQL 2000 servers, all are used heavily. There is no high availablity solution. I was thinking of placing the databases in Windows 2003 Cluster. If I do that, in terms of performance shouldn't I use an active\active configuration (i think it's called ...more >>

Hi everyone, I have active-passive two node cluster server, it's already installed two instances with associated two network names and IP addresses. Is there possible to install the third instance in this cluster server, if give the specific network name and IP address but no physical node ...more >>

Hi, Could someone tell me if a SQL Farm is different from a bunch of nodes in a sql clustered environment. What technically is a sql farm? Do people mean a "clustered farm". Thanks...more >>

Note: I have posted this in another group and I only get someone echoing the same issue, without anybody knowing the problem. ============================================ Hi gurus, I hope some experts here may tell me why, I guess this is a SP4 bug. Environment: 2-node clustered, Window 2...more >>

I've on box with MSSQL Server 2000 Enterprise. I'd like to know how many licenses I need to Implement the this my DB in the Cluster? I need 1 License MSQLServer or 2 License? Cluster Ative/Passive...more >>

We are in the process of deploying AS on a 2-node Active-Passive SQL Server 2000 MSCS cluster. I understand there is a MS white paper on how to cluster it which requires lots of manual changes. If we were to follow this paper, would it be possible to have the AS tools shared across with other ...more >>

We are attempting to install a cluster for further SAP installation. I have read the following article: http://support.microsoft.com/default.aspx?scid=kb;en-us;302491 I get this exact error message but (as far as I can tell) I have no invalid characters. The ipAddresses string = 10.10.0.18,2...more >>

Hi, I am not able to install Reporting Services (RS) on a Web Farm, but would like to get it installed and configured on a active/passive Failover Cluster. What do you think about the following scenario? 1. Install RS on one server and create the databases on the SQL Server Cluster. ...more >>

Hi, i have a cluster a/p windows 2000 & SQL2000 , now i would like install another virtual sever SQL on passive node for make this cluster active/active. The question is : When i start a SQL wizard for add a new virtual server when installation wizard aask me a path for sql binary i ...more >>

Are there any white papers and other resources where I may obtain information on setting up active/active clustering in SQL Server 2005? Thank you. -- Mike...more >>

Hi all, I am searching for a list of published hotfix posted after SQL Server SP4. Is there such a link or URL, on the Microsoft site? Thank you for your time. -- Franco...more >>

We cannot seem to figure out why our new SQL 2000 installation will only seem to operate correctly on one of the nodes. When running on Node2, it works fine, but will not start completely when failed over to Node1. Both nodes have been upgraded to SP4, but Node1 has never run correctly. The E...more >>

We have a SQL cluster across 2 Win2k3 servers, running active/passive. About 3 months ago, the power went out in our building briefly (less than one second). All our servers are connected to UPS's, so they didn't miss a beat. However, we do not own the switches (we're at a university, and t...more >>

We have an existing cluster (2003) with a single active node for SQL Server 2000. I added an additional node, ran the SQL 2000 install which copied the binaries, etc to it. But when attempting to failover to this new node, all resources came online except for the SQL Server, agent and fulltex...more >>

For a non-clustered index, would it have a performance difference between varchar(20) and char(20) , using only either one of them. thx!!!...more >>

Hello, Currently I need to deploy a cluster environment for my client. I've found many topics discussing about whether Sql 2000 cluster requires DTC to operate, but still see no final answer for it. Can someone please help me answer this question? Thanks, BN ...more >>

OK. I have a two node SQL cluster. Everything works fine when node 2 is active. When node 1 is active everything comes up fine and is reachable. After about 5 minutes, the sql instance is unreachable by name. Here is the filtered cluster log using cluster diag: 6d4:bd8.10/03[17:11:25.933](...more >>

I have a cluster using adapter teaming and it seems that when the virtual server is hosted on node 1, it is not able to resolve past the local segment. On the other node 2 it works correctly. Anyone have a ny input on this issue? Thanks Aaron ...more >>

Hi, I have a three nodes cluster with Win 2003. On that I have four SQL intances. MSTDC is installed on the Quorum. When a failover happens, the SQL groups start before MSDTC and that create a problem with the transactions after. To assure a good fonctionality I have to restart my SQL Serv...more >>

Hi We Want to do clustering of 2-3 SQL Servers. I m completely new to this concept. Any pointers around the same are most welcome. Regards Priyanka...more >>