I understand this is not recommended, but is it technically possible to have a non-clustered Default instance on a physical node and a clustered virtual Default instance running on the same node in the cluster group? I don't see how the operating system would allow for two MSSQLServer services t...more >>

Hi All, this is my current setup. i hv a SQL 2000 on a Windows Cluster (active - active) serving my application. I need to scale out. Is it possible to add one more set of SQL 2000 Windows Cluster and NLB them both. Is this possible. Any pointers appreciated. i searched on google but i couldnt find...more >>

I have a 2 part question about adding a new 'named' Virtual Server to an existing Clustered SQL Server 2000 install. I have a 2 node Cluster (WIN2K advanced Server sp4) with a default instance to which I added a second Virtual SQL Server (named instance). After many problems, finally got the se...more >>

So here is the situation: We have an Active/Active 2000 SQL Cluster that has a single instance with SQL running on it (the other instance has been taken offline b.c. we are in the process of retiring the cluster). We also have an Active/Active/Active/Passive 2003 SQL Cluster that has two i...more >>

Hello, Recently I failed one of our production sql server clusters over and back. When the sql server service started, I got this message in the sql log- " Performance monitor shared memory setup failed: -1". None of the sql performance counters are available. I have seen this before on on...more >>

Can I hae a Cluster consisting of: 2 servers - 1 With Windows NT Ent and MSCS - 1 With Windows 2003 ent - Clustering SQL 2000 SP3 ? can I, huh, huh? can I... ...more >>

Hello, I thought log shipping was supposed to be so strait forward and easy! It does not appear to be a reliable fail-over or "warm standby" solotion After setting up log shipping I have four databases that continue to try an load the first_file_000000000000.trn log, that is created when the pla...more >>

this is a test. please ignore....more >>

Finally got the cluster service running (2k3) and SQL 2000 successfully installed. Looks like everything is running properly as indicated by Cluster Administrator and Enterprise Manager but I cannot connect to the SQL server. Netstat shows no 1433 listeners on either cluster box... what did I ...more >>

hello, I first need to upg the sql to sql 2000 w/ latest sp... What comes next is where mt boss and I have issues... I say, -break cluster, upg that svr to win 2003 and sql 2000 and add back to the cluster.. -then break cluster and upg the other server to win 2003 and sql 2000... h...more >>

Hello, I am running a 2 node cluster with 3 instances of SQL. One of the instances, SQLSERVER01, is used exclusively by a front end Windows Server 2003 Web Server. Problem I am having is, when the SQLSERVER01 instance resides on a specific node of the cluster, the web server can communicate wi...more >>

Hello, I am hoping that someone may be able to help with a problem on a W2K Advanced Server with SQL Enterprise 2K. The problem is that we had a massive hardware failure of the cluster and both servers due to a faulty UPS and high voltage surge. This rendered the cluster unusable. We have...more >>

I am getting the following error. 00000a94.00000fb4::2004/02/29-05:22:25.943 Microsoft Search Service Instance <SQL Server Fulltext>: An error occurred in the configuration monitor for instance <SQL Server Fulltext>: 800700b7 - Cannot create a file when that file already exists. It knocks M...more >>

Trying to setup a new cluster (will be a SQL cluster) and when the setup wizard reanalyzes prior to starting the actual setup process, it fails on authentication. The error states that the trust relationship has failed between this workstation and the primary domain... it also says the user acc...more >>

Does anyone know of any good books that discuss how to implement both NT and SQL Server clustering. What is is really called? Network Load Balancing (NLB) or Clustering Service? Are these the same? I assume, its just a fault tolerance thing. There is no replication of NT or SQL Server ...more >>

Hi Does anybody know of any official documents comparing 64-bit SQL Server performance against 32-bit on a similar hardware platform? Apologies for any cross posting that may have occurred only I need answer ASAP. Ideally I need OLAP & OLTP benchmarks. Regards. ...more >>

Does anyone know of any good books that discuss how to implement both NT and SQL Server clustering. What is is really called? Network Load Balancing (NLB) or Clustering Service? Are these the same? I assume, its just a fault tolerance thing. There is no replication of NT or SQL Server ...more >>

Hello, I was wondering if anyone knows if there are any issues with failover clustering a SQL 2000 EE 32 bit and 64 bit server? I am looking into creating a SQL failover cluster with a 64 bit primary node and 32 bit secondary. Thanks in advance!...more >>

We currently have active/passive clustering and we are planning to tes active/active clustering. I understand that active/active require atleast 2 nodes and each node has an sql instance running on it. Bot the nodes are totally independent and do not share any data o processing what so ever. ...more >>

What is the reason for wanting the quorom drive on a seperate physical drive than the data drive for SQL Server Is it just so that if SQL would fail, then the quorum & cluster would still be up? If so, then is there really any pressing reason to seperate them if my clustered server is ONLY used f...more >>

I am trying to install SQL 2000/E on a 2 node cluster of Win2000 servers When doing the installation, I get the following error The drive chosen for the program files installation path, C:, is not valid on all nodes of the cluster. Choose another drive to install the program files. I've read th...more >>

Is there a way to determine the currently active node in a cluster? I would prefer to use .Net to determine which node is currently active. Anybody have any insight into this? I think I could do this with WMI on Windows Server 2003, but I need to get this information for Win2k Thanks in advance...more >>

What is the correct procedure to set up a file share directory on a Cluster server? So that the cluster has control of the file share directory. I have a server with Windows 2000 Advanced Server and SQL Server 2000. Thank You, Dan...more >>

With Windows 2000 Server or Advanced Server when it comes to install MSDTC on Cluster we had to run on both nodes "COMCLUST.EXE" Is this true also for Windows Server 2003 or it is enough to follow the instrunctions of the MS Knowledge Base number 301600 Here is the link http://support.microsoft.c...more >>