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 >>