I have a consultant telling me that there is no such thing as an active/active sql cluster. I want to install 2 seperate instances on 2 seperate sql 2005 servers in a cluster. The consultant is telling me that this is active passive because only 1 instance is active at a time on 1 server. ...more >>

Hi I had a Maintenance Plan with a scheduled job setup in SQL 2005. I have deleted the Plan without deleting the scheduled job. Now I cannot delete the job without the Plan. Any help will be great appreciated....more >>

I would like to add 2 instances of SQL 2000 into one Disk group within the cluster IE I have InstanceOne utilisng setup in cluster group using a drive (O:\) and would like to install InstanceTwo into the same cluster group using the same drive (0:\) When you go through the installation...more >>

We have SQL Server 2005 cluster setup, active/passive, 2 nodes, on Windows 2003. If I try to add a maintenance task using sql management studio on my pc I get error: "apply to target server failed for job". If I try it using management studio while on the active node of the cluster I get err...more >>

The client I'm working with has a 2-node Failover cluster. Owing to their environment, they have several machines accessing the many databases. For cost reasons, they went with SQL standard. As to securing the traffic. I understand that IPSec isn't supported for failover cluster, owing t...more >>

Hiya, We have several servers that have SQL Server and an application installed, therefore they are not just dedicated to SQL. Some of these applications have services, other have exe's that are launched by users over the network. We are looking at high availability options for these serv...more >>

I have a SQL 2005 cluster running, now the client would like to have the dataset replicated to another SQL server offsite for further redundancy. For the time being, the offsite server will be a stand-alone, however in the future it could become another clustered solution. The network conne...more >>

I am administering a 2005 SQL active/passive cluster. The sql services are all running under a domain logon that has "Domain Admin" rights, and I'd like to change that. According to http://support.microsoft.com/kb/915846/en-us, it seems that doing so might necessitate re-installing the ent...more >>

Hi , I am new to sql 2005 and clustering I too have made the same mistake as wayne see Geoff response on the 5th of Feb. I have a 2 node cluster and I have installed SQL within the cluster. I just need clafication that I only need to run the setup and just select integration services no o...more >>

I have SQL 2005 failover Clusterring on windows 2000 adv. server with physical memory 8 GB , i can increase the max memory to 6000 MB in the first node but when i move cluster to second node i can not increase the max memory to more than 2100 MB , i want to the second to be online with max mem...more >>

I was trying to move the msdtc resource to the msdtc group and I have messed up the cluster by taking too much offline in an attempt to move it. now I don't have access to the cluster as the cluster ip, network name are offline. Can I tweak the registry somehow to regain access to it? Stupid...more >>

Can I rename my virtual cluster name that has SQL 2005 installed after I build it for example if the virtual name is MASTER_New to MASTER? thanks, ...more >>

WE have a 2 node win 2k3 x64 cluster (also x86 clusters with same problem) with 2 instanses of SQL 2005 x64 and the MSDTC resource in the admin. cluster group (quorum group). This is a active/passive cluster, all 3 groups/vir. servers on same node. The problem appears when one of the SQL se...more >>

Can anyone give me some tips on enabling encryption on an active/active cluster? the particulars as I understand them: 1. Encryption is enabled on each node, and 2. Each nodes encryption is based on a certificate from Certificate services 3. Certificate services that must be installed on...more >>

Hello Is there any brief howto to configure SQL 2000 Cluster on a VM? Thanks ...more >>

Hello Is there any published document to setup a SQL 2000 cluster for demo on VMs? Thanks ...more >>

Realise it is a common question and have searched through the group: I have a Windows 2003 R2 cluster (with SQL 2000 SP4) which needs to be renamed (Nodes, cluster name) Is there any way to bypass re-installing SQL 2000 after this has been completed? (Various non microsoft sites point tow...more >>

Hello, I'm interested to hear from anyone about their experiences with 64-bit clustering with Windows Server 2003 and SQL Server 2005 - both good or bad. This is before I move with this new platform. Currently doing it with 32bit. cheers. ...more >>

Hello, I need to install a new instance of SQL Server 2000 on a cluster. Currently, we have three instances. Each instances stores program files on the E:\ Drive. Each instance has its own drive for data and another for logs. However, there is no more unallocated space on the array to ...more >>

We are implimenting a 2005 2 node failover cluster to migrate our existing 10 SQL 2000 databases. Will the server be able to handle 10 instances of SQL 2005? Is there anything else I should be considering while migrating these databases? Thanks for your help, Neil....more >>

I created a one node Cluster in Windows 2003 enterprise server. I then loaded a SQL 2000 Vitrual server. I now need to add a second node. The cluster sees the new node. However when I attempt to load the SLQ executables on the second node the only option I have once I choose the virtual serv...more >>

Hi...I got some basic questions in regards to setup a lab environment with two nodes cluster over Windows ent 2003, ent SQL 2005 and SAN storage. 1) Would the following hardware be enough: SAN storage, fiber channel switch, two intel servers, 4 HBA (2 for each servers) ? 2) what is the differen...more >>

I need to migrate our SQL 2000 cluster to a new set of hardware and name the new cluster with the same name as the existing one so that none of the applications are affected. How do I change name of a SQL Cluster ? Amila ...more >>

I know in SQL Server 2005, the recommendation is to break the datafile up into equal part--1 for each CPU because TEMPDB is used so much more. My question is under what circumstances should I do that in SQL Server 2000 64-bit. I have a problematic instance where a lot of sorts and some sto...more >>

Currently, I have 3 production database servers, each one with it's own backup server for mirroring the databases. So that's 6 servers for 3 default instances of SQL Server 2005. I now need to turn each of them into a cluster for automatic failover, and quite frankly, I think having 3 clust...more >>

Has anyone used SQL 2000 on a Veritas Cluster? Is setting up exactly the same as on a "regular" cluster? Thanks. ...more >>

Can someone recommend a good book that covers SQL clustering? And maybe even SQL Mirroring? I'm going to install my first SQL Cluster and I want to be as prepared as possible. All your help is much appreciated. Thanks....more >>

Hi, I'm trying to implement Log Shipping on a 2 Node SQL Cluster for certain DB's. As far as I understand, I've to share the folder where the transaction logs are backed. My questions are: a) I cannot configure the DB to back the TRN's on a network drive, it says "Not Allowed" The drive s...more >>

After allocating a fixed port in a multi-istance cluster and SQL Server = 2005, istances don't do on-line. Help! SP...more >>

I have a two nodes Windows Server 2003 Ent Edition Sp1\SQL Server 2005 Ent Edition cluster. I use RAID5 drives for data and RAID10 drives for TLog. I use: - letter to access data drives (es. K:, M:, ecc...) - mounted drive to access log drives (es. K:\SQL2005_LOG ---> first RAID10 drive...more >>

Hi All, We need to replace our SQL 2000 servers and SAN with new servers and SAN. I hope that someone can give me some advices on what is the best way to do it. We hope not to make any changes on applications using this SQL server. Current Setup 2 nodes SQL 2000 Cluster Server Windows 2...more >>

We have a 2 node SQL2K active/passive cluster on WIN2K3 OS configured with single virtual server with deafult instance. What is the procedure to change this to active/active cluster so that we could use both servers processing power to the same virtual server default instance?...more >>

Hello, I want to set up a two-nodes SQL 2000 Win2003 R2 x64 failover cluster and I've got some questions: - I've got 2 DELL servers, the shared storage is: 4 disks (73GB 15K) in direct attached storage. If I mirror 2 of these disks to use them as Quorum Disk and mirror the other 2 disks ...more >>

Hi, I have a 2 node SQL 2000 Cluster When I run the dtctester.exe I run into the following error : ===================================================== DSN: dtctest User Name: ****** Password: ****** tablename= #dtc24358 Creating Temp Table for Testing: #dtc24358 Warning: No Columns in Re...more >>

We have SQL Server 2005 on windows 2003 server +SP1. In the application log I noticed the following errors . But there was no fail over. No errroe messages in the SQL Server error log. Event Type: Error Event Source: MSSQL$SQL Event Category: (3) Event ID: 19019 Date: 2/13/2007 Time: 6...more >>

How to upgrade SQL 2000 stand-alone to SQL 2000 cluster? ...more >>

I have SQL 2000 stand-alone that I will need to move to a new cluster hardware and upgrade to SQL 2005 without impacting replecation. Can I do that and If so how ? Thanks in advance! ...more >>

My production system is on stand alone Server and it is a publisher on the replication system. I need to Migrate to a new hardware with fail over cluster and upgrade to SQL 2005 . I need to do that with out impacting replication. What is my options? Can I do that Or not If this was to stand...more >>

Hello, I'm following this article to configure SSIS as a cluster resource on my two node A/P SQL 2005 Cluster. This issue I'm getting is that for some reason, the SSIS cluster resource I configure will come line, however, the registry change that is made to point the config file to a "Shar...more >>

I have a SQL Server 2005 Enterprise version running at my Central Office in a 2 node clustered configuration. We would like to establish a Hot Site for DR purposes....I have been looking at the DB Mirroring and/or Log Shipping to accomplish this for our user DB's... I realize this requi...more >>

Hi, Is there a way to set up a SQL Server 2005 (Standard edition) cluster without a domain controller? It will be 2 nodes, Active/Passive configuration. If there is no way to get around a domain controller requirement, can the 2 nodes of the cluster be configured as the domain controlle...more >>

Hello, I just setup a few instances on a cluster. But somehow I cannot conntect to the instances remotely using SQL Server Management Studio. I can connect to them locally. I can also connect to the default instance fine. Any idea? Thanks!...more >>

Hello to everyone, I have a question relative with the Network Load Balancing mechanism in my pilot network with 2 windows 2003 streaming servers. I have 2 windows 2003 servers and i want to enable Load balancing between 2 servers but i am confused in a step of the whole proccess. we...more >>

Hi Again, I am trying to install sql 2005 on my cluster but the setup failed to start on the remote machine. The cluster is working fine and all nodes and shared disks seem to be OK. Any idea what is going on? Here is the error message: "Setup failed to start on the remote machine. Check the ...more >>

I need your advise on migrating a two node SQL 2000 cluster to new hardware including servers and disks. thanks. Amila ...more >>

We created an ODBC datasource on a SQL Server in the cluster. Then there was a hardware failover and subsequently unrelated DTS processes failed because the data source wasn't defined on the failover machine. Even though those processes did not use the ODBC source, in fact nothing used the ODB...more >>

Thanks everybody for the help on AV software for SQL cluster! I have another question on installing multiple virutal sql servers on a 2-node cluster. Should I go through the installation process again for the second virual SQL server? Will it overwrite the program files for the previous SQL v...more >>

Hi everyone, I have problem installing MS-SQL 2000 enterprise on Windows Server 2003 Ent. cluster. The message I'm getting is "Setup failed to perform required operations on the cluster nodes." The only thing "cluster.log" says in regards of the MS-SQL is that "the virtual SQL server name can...more >>

I've started working with a customer who wants to deploy a 2-node Active/Passive SQL2005 cluster at their primary datacenter. They also want another 2-node cluster at the DR datacenter to act as a failover for the production cluster. The 2-node cluster at the datacenter will consist of 2 pas...more >>

Hello, We have a Production SQL 2000 Cluster and are now developing on SQL 2K5 as we plan to migrate shortly. We'll be introducing new hardware into production with 2K5 installed. We would like to use a 'straddle migration' method by utilizing both 2K and 2K5 in production at the same tim...more >>