This is probably the best place to start: SQL Server 200 Failover...

Geoff N. Hiten

04-01-2004 12:15 PM
Geoff N. Hiten

You can check a few things 1. Make sure your domain trust(s) are still in place and functioning correctly. If you don't have the W2K support tools...

Stephen Strong

03-31-2004 11:36 PM
Stephen Strong

Someone within your organisation seems to be getting confused between server products and desktop products. Foxpro is a desktop product. Another...

Stephen Strong

03-31-2004 11:16 PM
Stephen Strong

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

bajjee

03-07-2004 06:11 PM
bajjee

Try to install sql client first then add an alias for the server name you're trying to install. evict one node and try to install it succeeds....

JGarcia

03-07-2004 06:01 PM
HW

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

Marc

03-07-2004 12:23 AM
Marc

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

Tom Rabaut

03-06-2004 01:31 PM
Geoff N. Hiten

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

jpotucek

03-06-2004 09:26 AM
jpotucek

Finally got the cluster service running (2k3) and SQL 2000 successfully installed. Looks like everything is running properly as indicated by Cluster...

Nate

03-05-2004 05:53 PM
Nate

Hi Guys, We have been having issues with the SQL Server 70 cluster (Active/Passive) sp3 which was installed even before i joined my client. It keeps...

Karthik

03-05-2004 03:13 PM
Karthik

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

Greg

03-05-2004 02:54 PM
Geoff N. Hiten

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

Onset

03-05-2004 02:52 PM
Geoff N. Hiten

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

tbones

03-05-2004 01:23 PM
Geoff N. Hiten

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

Fonkberry

03-05-2004 10:41 AM
Fonkberry

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

DavidM

03-05-2004 08:53 AM
JBailey

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

Martin Johntone

03-04-2004 06:01 PM
Shon Shah [MSFT]

Currently on IIS 5 win2k we use SQL2k Client network utility for the network libraries to connect and encrypt our data to our back end SQL DB. 2003...

dpower

03-04-2004 03:40 PM
dpower

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

Nate

03-04-2004 12:56 PM
Deepali Ananth [MS]

We are looking for a highly skilled SQL "INFRASTRUCTURE" person rather than SQL Server DBA or Developer/Designer. The person should have...

Qasim Tabrez

03-04-2004 09:39 AM
Qasim Tabrez

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

JBailey

03-04-2004 09:08 AM
JBailey

hi, have setup sql servers as a standalone. I need to configure a new server using clustering. Can someone point me to how to set up sql clustering...

Moe

03-04-2004 08:41 AM
Rick m

andrew.collins (AT) quest (DOT) com I have a Windows 2000 advanced 2 node cluster setup. I used VM Ware to build both nodes and I have virtual...

Andrew

03-03-2004 11:06 PM
lab

Hi, I am trying to setup SQL 2000 Ent. on 2 node Windows 2003 Cluster in Active/Passive mode. The setup hangs at the point where it needs to display...

aln143

03-03-2004 07:10 PM
Deepali Ananth [MS]

We currently have an existing W2K Advance Server running SQL 2K EE and are planning on implementing a cluster using the existing server. Anyway to...

EdrieL

03-03-2004 03:36 PM
EdrieL

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

chiefnerd

03-03-2004 05:45 AM
Simon Lidberg [MSFT]

We currently have active/passive clustering and we are planning to tes active/active clustering. I understand that active/active require atleast 2...

gopal

03-03-2004 01:46 AM
Stephen Strong

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

DavidM

03-02-2004 05:13 PM
Carlos Eduardo Rojas

Are the install files on a network share? I have seen problems with that. -- Geoff N. Hiten Microsoft SQL Server MVP Senior Database...

mdh333

03-02-2004 01:21 PM
mdh333

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

mdh333

03-02-2004 10:05 AM
Geoff N. Hiten

I wanted to run my thoughts by the gurus here. I think I'm on the right track, but I just want to get some confirmation. This morning I tried to...

Kripes

03-02-2004 06:31 AM
Kripes

Hi I have SQL2K SP3 on W2k SP4 in an active passive cluster. Recently I have had problems with the cluster either failing over or attempting to and...

JonathanS

03-02-2004 06:26 AM
JonathanS

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

Dan

03-01-2004 04:31 PM
Stephen Strong

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

Franco

03-01-2004 04:21 PM
Stephen Strong

Hi, I really would appreciate any help on this. Can a very large transaction log have a negative impact on write performance?? We were having a...

Christian Bouche

02-29-2004 08:41 PM
Stephen Strong

Does anyone have a step by step for setup of a SQL 2000 A/A/P cluster on Windows 2003? I just want to make sure I get all the components...

Jason

02-28-2004 04:11 PM
Geoff N. Hiten

Hi, I need to have the Virtual SQL Server listen on an additional IP address, which is actually bound to a MS Loopback Adapter. Both the nodes will...

zrb

02-27-2004 10:04 PM
zrb

Hi, We are setting up Virtual IPs for all the services that we provide to clients. The virtual IP address will reside on a network equipment, a...

zrb

02-27-2004 08:16 PM
zrb

Our quorum size in the MSCS folder is stuck at 32kb. The Reset quorum log at: is set to 4096 With it being at 32kb for sometime now is it best to...

todd paulson

02-27-2004 03:40 PM

I have a slight issue that I've been trying to find information on without much success, so I thought I'd get with the experts here. I've configured...

Fonkberry

02-26-2004 01:51 PM
Fonkberry

Can I have another Virtual SQL Server on the existing Cluster (MS SQL 2000 Cluster)?. Current configuration is SQL SERVER 2000 EE in...

Olutimi

02-25-2004 04:14 PM
Rand Boyd [MSFT]

I have a working 4-node cluster on 2003 that installed just fine. Did you check: PRB: Installation of a Named Instance of SQL Server 2000 Virtual...

Geoff N. Hiten

02-25-2004 01:13 PM
Geoff N. Hiten

Hi I want to implement Active/Passive clustering sql server, I am wondering if I can access to the idle server and run program (for instance,...

Li

02-25-2004 08:49 AM
Li

We have a pair (active passive) of SQL 2003 running in a cluster. The problem is that the virtual SQL server only appears on one of the two networks...

Simon JJJJ

02-25-2004 02:00 AM
Bjornmob

Hi All, I'm facing a problem reinstalling SQL2000 on windows 2003 cluster. As I'm trying to do migration, I did a test installation with a default...

tinklebell78@yahoo.com

02-25-2004 01:52 AM
bjornmob

Enter the Windows Server 2003 Challenge for your chance to win a grand prize worth $15,000 USD! 2nd Round ends March 28, 2004 Tell us how Microsoft...

Windows Server 2003 Challenge

02-24-2004 01:56 PM
Windows Server 2003 Challenge

I received following error: The redirector failed to determine the connection type. My clustered Windows 2000 Advanced Server with SQL Server 2000...

Dan

02-23-2004 03:11 PM
Dan

Hi I wanted to configure Failover cluster for SQL Server 2000 on Windows 2000 advanced servers I have only 2 no.s of windows 2000 advanced server...

Babu V.T

02-23-2004 01:50 PM
Chandrasekar Gopalan

Hi there Are any of you using merge replication to increase the availability of your sql server? I have a clustered sql server 2000 but I need...

Karen Sundquist

02-23-2004 01:42 PM
Chandrasekar Gopalan

I know that standard edition doesn't support Clustering, but my question is, can we still install SQL server Standard edition with the processor...

dw

02-23-2004 01:31 AM
Shirley Kelly [MS]

I have a two node cluster. One node has crashed and I need to know the best approach to rebuild the second node. In my case the node crashed from a...

billet

02-22-2004 10:24 PM
Geoff N. Hiten