I am confused! I can build a cluster SQL without the use of an iSCSI? Or be, barely with a SAN + FC? In which situation would need to use iSCSI in an environment of cluster SQL? Thanks! ...more >>

Hello, I have a 3+1 windows 2003 enterprise with sql 2000 installed. Is it possible to add a SQL 2005 node into this cluster? Thank you Calvin ...more >>

Considering the platform: 4-way, 16GB RAM running Windows 2003 (32-bit) Enterrise Edition and SQL 2000 Enterprise Edition. With only 2GB (or 3GB with /3GB switch) of pagable memory to work with, how is this memory shared across multiple SQL instances within a clustered environment? This is a n...more >>

1.I want ti install SP4 on 2 node Active/Active cluster but problem is i forgot SQL Server Virtual server name . How to find that. 2. don't remember on which server first i installed the sql serverIs the server hosting thw quorum drive is the primary node of the cluster. Kindly help... ...more >>

Please, do you have any step by step to implement SQL Server 2005 in a active/active cluster configuration. I have some doubts about the virtual machines and how the installation should be done. Regards, Marcio ...more >>

Hi, I have the problem with bringing the SQL Server 2005(SP1) cluster server online. Because the shared drive failed, after SA fixed drive, my database including master, model, msdb, temp, etc. data & log files all gone. And also my backup files since I only have one shared disk per SQL. So...more >>

I would like to know if it's possible for the nlb to detect a close connection from my server when SQL Server service is stopped ? I can perfom the stuff with IIS (by updating metadatabase file), I would like to know if something like this can be done with Sql Server 2000 (on Win 2003). Bes...more >>

Dear all, My client would like to set up a SQL Server with Active/Active Clustering with SAN. Is it possible to do a loadbalancing of the database in SQL Cluster environment? Such as, can I using same/difference instance to mount the same database resources in the SAN disk? Thanks ...more >>

Hi We have a server with 8Gb memory, and 4 SQL Server instaces. Should we run AWE?? Thanks ...more >>

Hi Can anyone point me to some documents details how to set up SQL Server in a Load balanced Active-Active configuration?? We are using SQL Server 2000 (Enterprise), with Windows 2000 Advanced Server. I don't think this is possible with Standard (??) Thanks ...more >>

Hello all, Could any one here help me in converting a Julian date (1970) into a standard date and time using vb6.0? For example, ( Julian date ) 11659 = ( converted standard date ) 03/12/2001 Thanks in advance Jack ...more >>

Hi, I currently have 2 separate SQL Servers under the same domain, running different databases each and having different hardware. We are getting an SAN to centralize the data. If i move the data of both SQL Servers to the SAN then can i configure both sql's to be as one cluster? Are t...more >>

Hello All: I am looking to set up a Single Node cluster on Windows Server 2003 SP1 with SQL Server 2000 SP4 on top of it. We will eventually add a second node when that machine is ordered,built and shipped. Until then we need to get SQL up and running for this application. The goal is to ha...more >>

This is a SQL2005 active/passive cluster. We noticed that doing a manual failover on Group0 works fine (group0 has all the SQL volumes, service, and name). There is also a cluster group, which has the Cluster IP, Name, Q:\ volume (quorum), and the MSDTC. When we manually fail Group0, th...more >>

Gurus, Running two instances of SQL on a SQL Server 2000 cluster. Windows Server 2003 SP1 is the OS. Are there any special rules I must follow to execute the SQL hotfix on each node of the cluster? I am assuming I just need to apply the SQL hotfix to each cluster node and that's it. I a...more >>

I have 2 instance of SQL Server 2000 Enterprise ED in active/active 2 node cluster. Each node box have 8GB RAM. If i enable /3GB switch on each node. In case of failover, when both the sql instances are running on a single node, will both node will take 3GB each OR total of 3GB have to be sha...more >>

I have a pair of Dell Poweredge 6650s and each has a 340 gig powervault. How do I rewire this rascal so both servers sees the same powervault? I know that there are a pair of SCSI connections into the PV, but they separate the PV into separate devices, or so it looks to me when I use our t...more >>

I'm trying to install SQL Server on a two-node cluster. The setup program fails with the following error message: -- QUOTE -- Setup failed to start on the remote machine. Check the Task scheduler event log on the remote machine. For help, click: http://go.microsoft.com/fwlink?LinkID=204...more >>

What are the step to be followed change the SQL Server Virtual IP address. SQL Server 2000 Enterprise version with SP3 Windows Server 2003 Enterprise Edition...more >>

Hi There, I am planning to move the system databases[Master,Model, Msdb and Tempdb] from a drive to a different drive in the SAN [All part of the shared resource]. My plan is to initiate a fail over to the passive node , perform this task and restart the SQL Server services in the primar...more >>

We currently have a 2 node active/passive cluster (Win2000sp4SQL2000sp3). We have several drives configured with multiple databases on the different drives. The SQL drives are on a SAN. We want to move the SQL virtual instance to new 2 node hardware with Windows 2003 freshly installed...more >>

Can the clustering gurus and users provide their experiences? Thanks ...more >>

curious if it is possible to have all 4 talk to each other through a switch?...more >>

I want to configure a 4 node cluster I have setup a 2 node prior, I have a question regarding heartbeat. Is it possible to have all 4 nodes communicate on a private set of ip through a switch instead of a cross over cable connecting 2? I want all 4 to talk to each other on the heartbeat si...more >>

Hello, I Have some questions as regards the cluster of the SQL Server active/active. - Which I calculate of memory for the environment to it? - The two virtual nodes will access to same data base? - The two nodes will be accessing the same storage shared? Thanks! ...more >>

salve, vorrei realizzare un cluster usando server IBM (Xseries) per un'applicazione che girà su DB SQL Server. L'attuale dimensione del DB è di circa 2 GB con 40 utenti connessi ma si prevede un incremento a circa 60/80 utenti. Non è molto stressante come applicazione ma vengono eseguit...more >>

I had an odd issue which I still have not figured out. We sadly had Automatic Updates for Windows turned on and 3 updates were installed at 3:00 AM on both of our SQL2005 cluster members: http://support.microsoft.com/kb/917159/en-us http://support.microsoft.com/kb/914388/en-us http...more >>

hi, we have a 2-node cluster of sql2k EE 32bit running on w2k3 R2 x64 EE sp1. so far so good. it's running apparently fine and also the database works without troubles. officially this seems to be a supported configuration and we found others running it in the newsgroups. now to the problems:...more >>

Hi, I need to remove SQL 2000 from an old Windows 2003 (No SP) Active/ Passive cluster system which has not been used in long time and install SQL 2005 instead. Before removing SQL 2000, I tried to bring SQL Server resource online but it failed with following errors in application event log: ...more >>

First of all, thank all of you all for all your hard work that give us folks light and guidance in what seems like a real dark room sometimes. I have a single SQL server that I am looking to put into an Active/Passive cluster. Unfortuantly, I have a truckload of applications out there who are ...more >>

Can I setup two SQL 2005 clusters on a single Windows 2003 (4 nodes) cluster? Or I need to setup 2 windows 2003 clusters? one for each SQL 2005 cluster ...more >>

I need to design an architecture to support what will become a heavily hit web site. We have a UNIX guy looking after the web servers and it is my job to sort out the SQL side. The ratio of reads to writes in the database will probably be 75:25. Availability and scalability is very important....more >>

We moved our databases from a single sql server to a clustered instance several months ago. I'm not sure if the Full-Text Search's stopped working just then, or sometime since then, but they are currently not working and I get the following messages in my event log, whenever I either try to cr...more >>

I'm supporting SQL Server 2000 EE SP4 on a Windows 2000 cluster. There are currently 3 databases on the server not including the system databases. Several months ago we began receiving 605 and 823 errors on one of the databases. We disabled write caching to the drives. Since that time we h...more >>

I have 2 HP proliant DL 360's with G4P's running SQL 2000 in an active passive configuration. My problem is that I also have 2 network load balanced font end servers running on apache web server which are supposed to access the SQL cluster but when they cant access the active node failover doesnt...more >>

This is what is happening: Cluster service is running "Is Alive" check every 1 minute on SQL server I validate this by profiling the SQL server and see that "select @@servername" command being executed by cluster service every minute There are times when the server is stressed, thus connections...more >>

I have two SQL servers configured in a cluster and when the first server goes down it wont fail over. For some reason the cluster believes that the first server is still up and running and nothing is loged in the event viewer. Any suggestions would be helpful at this point....more >>

Guys first of all I am lost I need some serious HELP> 1.. What I want to do is create and Active/Active Clustering environment. Using Windows 2003 and SQL2000 For Hard Ware I am using two DELL PowerEdge 2850 servers and a PowerVault 220. The Windows part is done or so I believe I...more >>

Guys first of all I am lost I need some serious HELP> What I want to do is create and Active/Active Clustering environment. Using Windows 2003 and SQL2000 For Hard Ware I am using two DELL PowerEdge 2850 servers and a PowerVault 220. The Windows part is done or I believe so I have...more >>

I am trying to convince "the powers that be" that we must cluster our test environment if we are definitely clustering our production environment. The question I need the community’s help with is: WHY? Can you give me some hard facts as to why it is not recommend to cluster one environmen...more >>

Hi all, trying to resolve n MSDTC issue, on a clustered server, and I enabled network access by DCOMCNFG->MSDTC->Security configuration->network access ... now I want to turn network access off, but the "security configuration" button is disabled. MSDN doesn't help .... can anyone h...more >>

I nee to configure sending alerts thru email in SQL Server 2000. This is a clustered server which is not part of the domain. Any hints on how to do it? I've only done it in a non-clustered, Exchange-based scenario....more >>

Hi, Is adding DTC as a resource to my cluster necessary or it is used for particular purpose? My database does not perform any distributed query/xact. Do I have to add DTC resource to the cluster? Thanks in advance, Leila ...more >>

Hi, I setup the clustering test environment by the following specifications: OS: Windows 2003 SP1 for both nodes Hardware: Not in HCL Storage: DAS, consisting of two SCSI disks, no RAID, one disk for Quorum, the other for user data Network: Public network connection via HUB, private network...more >>