Hi all, I'm new to clustering. Just some question to ask u all. Do we have to configure separate static ip, network name and physical disk for the MSDTC? Or we can use the same static ip, network name and physical disk(Q:quorum disk) that we configure for server clustering? Appreciate...more >>

Can anyone advise as to the best practices for installing mulitple instances of SQL into a cluster? Specifically as to the harddrive quantity and configuration. I already have 1 instance in a cluster and need to add more to it. So, my cluster already has a drive for OS (Mirrored), a drive...more >>

Hi, I need to install sp3a in a recently added node, but I added this second node after I had installed SP3A in the active node, so, when I installed SP3a in the first and active node, it was not installed in other servers. I have the following scenario 1st node (active) : Win 2K3, SP1,...more >>

I see that there was a another query about this. But to confirm If I wish to have active\active SQL on a server with 6Gb of memory should I use AWE enabled PAE enabled But not /3Gb (even though there are articles which state that you should for 4 to 16Gb of memory server) What recom...more >>

I have two node SQL Enterprise installed on a Windows 2003 cluster running active -active. I would like to add a third node so that it would become 2 active and 1 passive . Is this feasible ? Also , can someone tell me how can I make the third node standby for the other two ? Do I have to ins...more >>

Hi, I am new to SQL clustering. I have a two nodes windows 2003 enterprise server in a cluster with sql 2000 enterprise server installed. Following the SQL installation screen I have create a virtual server ( for SQL ) and installed the first sql instance using "default" as the name .So far...more >>

The instal fails when we try to cluster SQL 2000 on windows 2003 server. I tried new instances or standalone instals but i had the same results<<failure>> ...more >>

The sql server service doesn't start b/c it appears the password isn't being stored after the node reboots. I've gone into Enterprise Mgr to retype the domain acct and pwd and save... I've also retyped the pwd from Manage/Services. It stores it up until the node is rebooted. Then the pwd is ...more >>

Hello All Has anyone created a clustered sql2000 instance on windows 2003 in different geographical areas? I gather this can be done, but there is no shared storage as such. I believe one has to replicate data another way. I am looking for some docs on this before I dive in! Thanks Simone ...more >>

hi, i wanted to have my 2 node server cluster as active-active. DO i need to put the named pipes in both servers before i install sql2000 or just on the one that i wanted to install the instance?i will have VSS1/INST1 and VSS2/INST2. do i need to put both of them in CNU and install sql on firs...more >>

OK. This is getting frustrating. I have tried over and over to set up SQL Server 2000 in my 2 node cluster. I keep getting the following messages: This one occurs during the setup: ----- CUT ----- The cluster resource failed to come online. If extended information was reported by the clus...more >>

I am looking to see if anyone has had this problem or ideas of what I might try. We have been running a Windows 2000 cluster connected to a powervault for two years as a single instance with no problems. I am in the process of setting of a Windows 2003 Active-Passive two node cluster conne...more >>

Just wondering if this is correct. I have SQL 2000 set up across a Server 2003 cluster. Say I have PhysicalNode1 and PhysicalNode2 and VirtualServer1. VirtualServer1 is sitting on top of PhysicalNode1 and I go into Enterprise manager and make some configuration settings to SQL server li...more >>

hi there. I've got a bit of a problem on a clustered sql server. I don't know if the cluster has anything to do with it, this is an entirely new configuration for our company. We've moved out of the days of using "white-box" pcs for servers to two dl380s clustered with an msa 1000 via fibre...more >>

Hi, is there any step by step guide on setting up multiple instance of Microsoft SQL server cluster with more than 2 /3 active nodes ? There is no such training course available anyway ? Thanks A Lot ! George Norman ...more >>

Hello, We are moving from a 2 node, Acitive-Passive cluster to a 4 node cluster; 3 Active 1 passive. We have 3 Virtual Servers. We have defaulted one virtual server per active node. I want to be able to run a different version of our software on each virtual server; thus three folders ...more >>

Has anyone clustered SQL server 2000 using a NAS server (eg. Dell PowerVault 745N) as the shared storage? I know that SAN is recommended but costs are vastly higher. Any reasons as to why it shouldn't be done would be helpful. thanks - pete. ...more >>

Recently set up a cluster and it seems to be working up to a point. Have run into a problem trying to ping the cluster IP address from a node not owning any resources, or from outside the cluster. Pinging from the node that owns everything works, and if I move over the MSDTC then the second node...more >>

Is it possible to create Fail-over Cluster with 64-bit (Itanium2) and 32-bit (Intel Xeon) nodes?...more >>

I'm looking for some "best practices" help from the SAN gurus out there. We're looking to move some of our databases to an EMC SAN. Currently we run full backups every night and tran logs every 15 minutes, which are then used by logshipping to restore to warm standby servers. After moving to...more >>

My boss issued a challenge at lunch today: Find out if SQL can cluster to support thousands of end-users with hundreds of thousands of trans per minute, or we start looking at Oracle. What do I say to him? Thanks Richard ...more >>

Building an Active/Active/Passive SQL 2000 cluster on top of a 3 node 2003 server cluster. As I go to install I end up getting a "An error occured while creating virtual server resources for clustering. The system cannot find the file specified." I've gone through KB 815431 and made sure ...more >>

I'm looking for a best practices page that may help us in configuring our SAN to SQL's best interest. Is there anything?...more >>

Hello I want backup my SQL Server Cluster (two nodes) and to restore it on other two nodes on another site. I need to know that procedure to test my DRP. I know that the best would to have a geocluster but for now (budget limitations) I just want to be able to restore the cluster. I wou...more >>

In a multi-instance cluster, how can you match a named sql server instance with an instance of sqlservr.exe? When setting up counter collection in perfmon, I choose the "process" performance object, then the "% processor time" counter". In list of instances, I can see sqlservr#1, sqlservr#2, e...more >>

Hi everybody, due to a busy server (the 2nd node), I couldn't install the two nodes in one step, and I was forced to install a cluster with one node, and bring it online with the production database. Now everything works fine (in one node of course) and I'd like to install the second node....more >>

Hi, I have problems with sending mails within clustered MS SQL Server 2000. I configured mail profiles on both nodes (with the same name) - I can send mail within MS Outlook (which is a default mail client). There is no profile on drop down list in SQL Mail section (server properties). Whe...more >>

Hello I have a SQL Server 2000 64 bits running on an two node cluster (NODE1 and NODE2) with two SQL Server instances (SQL1 and SQL1\2). Instance SQL1 is running on NODE1 and instance SQL1\2 is running on NODE2. MSDTC is configured on a exclusive group and it is running on NODE1. The Cluster...more >>

Hi everyone, First please excuse my ignorance. I am a consultant and generally work with small business servers and I have no experience with clustering. I have a nonprofit client that has a need for a small database (500mb or so) and wants to use 2 Dell workstations as the servers. I kn...more >>

Hi, How can I know how much memory is used by SQL Server in Cluster? as I believe on nodes I cannot see that. thanks in advance ...more >>

Hi, I have been setting up a WIN2K3 Cluster here today and having some problems. I can get SQL Installed ok and everything works fine until I set my Application Servers to point at the new SQL Server, at which point my Component Services Components start getting MSDTC errors - 'New transac...more >>

How is best performance and support.? ...more >>

HI, I have a Windows 2003 two node cluster and am trying to install sql 2000 I go through the first steps of the install ok then it hangs after I have put the virtual ip address in for the virtual sql cluster The extract from he setup log below suggests that it has trouble doing something wi...more >>

Hi everyone We have 2 cluster servers and each server has 3 instances (under WINDOWS 2003), all these is under a domain IDBPA\IDBPINSTA1 IDBPA\IDBPINSTA2 IDBPA\IDBPINSTA3 IDBPB\IDBPINSTB1 IDBPB\IDBPINSTB2 IDBPB\IDBPINSTB3 We want o to migrate these instances to another 2 new ...more >>

Hello! First excuse me for my english. J have a cluster windows 2003 EE , and j have installed an instance non virtual in the first node, with datafile in shared disk. Well, when j go for upgrade this instance in cluster instance whit sql cluster wizard, the option upgrade instance in virt...more >>

I have a cluster SQL 2000 server running on Win2003 Because of a connection error, i found an article http://support.microsoft.com/default.aspx?kbid=328306 in one section of this document, it suggests: change the name pipe setting in server network utility to \\.\pipe\sql\query from my pre...more >>

I am running a 3active/1passive node cluster on W2K3 and SQL 2k. The passive node has the ability to have any of the active nodes to failover to it. In addition to it being the failover node it also has 3 instances that match the active nodes. Since all the drive letters must be shared be...more >>

I need to move my cluster out of a domain and into a workgroup. Is there any documentation available on this procedure? So far an online search has come up empty....more >>

Hi, We have a HP EVA 5000. SQL 2000 Cluster is using 150 GB(Drive R:) on the EVA for all database files. I want to defragment Drive R:. Fýrst I intend to stop SQL Server and SQL Server Agent,then backup up all system and user databases to Tape Backup(.mdf and .ldf files).Alternatively I may...more >>

Hi, We have W2K/SQL 2000 Cluster server (Active/Passive mode) and attached to NT domain. We want to move this to AD Domain. Is there any Microsoft KB article to follow the migration procedure for this cluster to AD domain? Thanks...more >>

My user wrote asp apps previous ran fine against SQL 2k sp3a on win2k. Now we upgrade our SQL server to Windows 2003 Failover Clustering SQL 2k sp3a. Then even she changed her connection string to new sql server, but her asp program is no longer make connection to SQL Server. I grante...more >>

I was wondering if any of you could offer some help with my cluster. I'm troubleshooting an existing problem within the company where the website crashes because the clustered SQL servers' 8x CPUs reach 100%. I've looked in the event logs of the SQL Servers and the only error is on one inthe...more >>

I have 2 Windows 2003 servers running SQL2000. They each have separate databases. I am in the process of clustering these 2 machines together. I have purchased a shared external SCSI PowerVault appliance to put the quorom and the shared databases on. I want to create a Virtual SQL server u...more >>

Hi all, I was wondering if any of you could offer me some help with my cluster. I've been dropped in the deep end and currently experiencing a serious 'in the deep end' moment. We have the requirement to emulate a setup whereby two (or more) machines are going to be clustered together to ru...more >>

We are using an Access database with Employee Pictures. However, we find that the size of the database is pretty large as images are stored as BMP format in Access. We would like to know which datatype should be used for storing photos in SQL Server 2000 ? Does it justify for us to upsi...more >>

Hi all - i am fairly new to clustering and here is what i am trying to accomplish: - 2 DL380 g4 with 5 drives each. - 2x Raid 1 for sys files - 2x Raid 1 - 1x Raid 0 I dont have an external SAN device for shared external disk and my question is A)do I need external SAN device to c...more >>

Hi, We have a processes which is completed in 3 hours on a machine with scsi hard drives with data on RAID 5 with 4 hard drives and log on a mirrord hard drives it have 2 GB of memory and dual processor. Now we are running the same processes on a 64 bit cluster with two noedes each have 12 ...more >>

Hello - We are considering implementing a clustered SQL scenario over 2 different datacentre locations. At the moment we are thinking of probably going down the hot standby situation where we run the primary server in one datacentre and the failover in the other with some replication software ...more >>

Need a SAN/NAS but (by cost) need a software solucition. Suggest? ...more >>

Hello to all, I'm investigating an application outage issue on a 2-node W2K Adv Server cluster. A Generic Application is running on the cluster in a remote site, and connects to a UNIX-based Oracle db at my site. There are intermittent MRxSMB 3019 Event IDs which I'm not too worried about...more >>