Yip working fine, Now worrying about SP4 Craig "Willie Nelson" <willie (AT) buymyrecords (DOT) com> wrote

QTex

07-23-2003 06:15 PM
QTex

I'm installing SQL2k Ent on a 2-node (active/passive) cluster. I have 2 drive arrays in a Dell Powervault 221S drive tower, and 2 Dell PowerEdge 2500...

Scott

07-23-2003 09:20 AM
JBailey

is there are a way to load balance SQL server using windows 2000 server cluster? i mean active/active cluster for sql 2000 over the same instant of...

Bassem

07-22-2003 10:47 PM
Michael Hotek

Actually, there is a lot more there than you really need. :) -- Mike Principal Mentor Solid Quality Learning "More than just Training" SQL Server...

Jim Holcomb

07-22-2003 10:46 PM
Michael Hotek

I have two servers and an external RAID. Do you think I can configure a clustering with them? The two servers have Windows 2k Advanced server, and...

whitejul

07-22-2003 10:45 PM
Michael Hotek

May I know how to do it? Run 2 instances of VMWare in the same computer? Would you please provide more information? Thanks a lot. Salo "Michael...

Salo

07-22-2003 10:31 PM
Michael Hotek

I have read the KB articles 230356,244980, and 241828 regarding changing IP's on a SQL cluster. Right now my IPs are 192.168.0.21 & .22 on a subnet...

BVesely

07-22-2003 10:29 PM
Michael Hotek

Are not there....what the hell?

Scott

07-22-2003 04:51 PM
Scott

Take a look at: 820773 FIX: JDBC Driver Leaks Server Cursors http://support.microsoft.com/?id=820773 Cindy Gross, MCDBA,...

Cindy Gross

07-22-2003 03:47 PM
Peter Fournier

Can you setup an ODBC to a single node on a cluster? I can't seem to get it to work. It's not a generally accepted practice, but I'm trying to...

Kevin Stone

07-22-2003 11:14 AM
Kevin Stone

Hello, Is that the cluster nodes cannot be the Domain Controller? If so, I need another computer that act as Domain Controller. Is that true? Salo

Salo

07-22-2003 07:02 AM
Salo

Hi, We have an active/passive cluster which was running fine for months. Then last week the SQL cluster failed over to the 2nd node - we established...

Af

07-21-2003 08:39 PM
Kevin Wallace

Agreed with Samir. A few months ago I've being trying to explain this to an software architect, but the folk prefered mentioning his...

Arun

07-21-2003 03:59 PM
sonyboy

I know. I have a separate drive array to be used as the Quorum disk, and I'm still getting the same message. I've tried moving the data disk into...

Scott

07-21-2003 03:10 PM
Scott

If your public network is enabled to also carry heartbeats, then it should be a non-issue. You can check this in Cluster Administrator by...

Harold

07-21-2003 02:25 PM
Harold

We want to use Windows authentication (not mixed mode) but want to disable "everyone - full control" What are the minimum permissions that are...

Yaron

07-20-2003 08:33 PM
Willis

Hi any one installed SP 4 ?

fraxis

07-20-2003 02:14 AM
Shannon

Hi there, I posted this in the windows clustering group as well, thought it was relevant to here as well though. I have a Windows 2000/Sql 2000...

Andy Driskell

07-18-2003 01:16 PM
Kevin Wallace

Problem solved! We had changed IP's after we deployed on our production network. Turns out all IP connections were failing. AD clients were still...

John Ryan

07-17-2003 11:58 AM
John Ryan

Thanks very much Geoff, that confirms what I'd originally thought, I can now confidently discard the latest 'training material' and be more confident...

Patrick

07-16-2003 04:23 PM
Samir Pandit

Hello, I currently have a website which is based upon a SQL2k cluster. This is fine for fail-over support and does what is required. However, we...

Julie G

07-16-2003 04:14 PM
Samir Pandit

My suggestion is to not let them off the hook so easily. If the problem is hardware, they should be able to provide concrete proof that it is. ...

Michael Hotek

07-14-2003 03:19 PM
Michael Hotek

That's fine. The main point, though, doesn't have anything to do with licensing. It has to do with the perspective with which you approach a...

Michael Hotek

07-14-2003 03:13 PM
Michael Hotek

When you install SQL Server, it has to be done from the node which owns the disk resources where you are going to place the SQL Server...

Michael Hotek

07-14-2003 03:08 PM
Michael Hotek

I am running SQL Server 2000 Enterprise sp2 + hotfixes on Win2K sp4 server. I see from documentation that in configuring SQL Server 2000 for...

Toni Eibner

07-14-2003 02:00 PM
Toni Eibner

hi, I have 2 node sql2k cluster, my spesific program work on cluster, but when active nod stop, the passive nod did not start the services, I did...

H. Ali GÜRSOY

07-14-2003 04:39 AM
H. Ali GÜRSOY

Hi, Does someone know the licensing issues with the following configuration: 2 servers ( physical machines ) with 2 micro-processor on each,...

dbcenter

07-14-2003 04:08 AM
Hina Masud [MS]

Hi, We have two identical servers in an active/passive cluster running Win2K and SQL2K. We want to upgrade on of the servers in the cluster with a...

Terry

07-14-2003 04:00 AM
Hina Masud [MS]

Hello, I'm going to build a database servers cluster but I don't know how can I share the database files disk for both servers so that if a...

Eluardo

07-14-2003 03:54 AM
Hina Masud [MS]

Hi If the users are compaling that the production environment is slow, what are the sequence of steps/files to look into? Thanks vind

vind

07-14-2003 03:41 AM
Hina Masud [MS]

Has anyone had any problems with Windows 2000 service pack 4 on a cluster

Thomas Rae

07-14-2003 03:25 AM
Hina Masud [MS]

And if I can't, is it ok to run again prior to installing SQL?

Tony Wesztergom

07-14-2003 03:19 AM
Hina Masud [MS]

We have a current 2-node Windows 2000 Advanced Server cluster running SQL 2K SP3. We are needing to physically replace the machines in the...

Fred Zelhart

07-14-2003 03:02 AM
Hina Masud [MS]

is there are a way to load balance SQL server using windows 2000 server cluster? i mean active/active cluster for sql 2000 over the same instant of...

Bassem

07-11-2003 10:58 PM
Ray Higdon

Use the following technet article as a starting...

Carlos Eduardo Rojas

07-11-2003 02:19 PM
Carlos Eduardo Rojas

How can I execute procedure when one of the nodes of cluster fail.

Robert M

07-11-2003 11:05 AM
Paulo Ferreira

I run a query through Query Analyzer against a database on a SQL cluster and get the following error Server: Msg 8501, Level 16, State 3, Line...

Ian Robinson

07-11-2003 09:54 AM
Ian Robinson

Hi Everyone, am configuring 3 sets of two node server raid clusters. The first set completed successfully with no problems. The second set am having...

caddo65590

07-10-2003 11:13 PM
caddo65590

Brandon, From 254321 INF: Clustered SQL Server Do's, Don'ts, and Basic Warnings http://support.microsoft.com/?id=254321 SQL Server 6.5 and SQL...

John Gose [MS]

07-09-2003 04:08 PM
John Gose [MS]

Thanks much for the fast answer. But then I don't understand exactly how I will benefit from the cluster if I need to setup a domain controller. Can...

dbcenter

07-09-2003 02:37 PM
G

How is your heartbeat configured? We have ours configured with a crossover cable and as such is not dependent on the network switching hardware. ...

Chris

07-08-2003 03:29 PM
Chris

Have you tried using the domain account that is the SQL server service account? This may help. I have ran into this when trying to install SP3 I...

Chris

07-08-2003 03:22 PM
Chris

I currently support this configuration (Win2K A/S SP3, SQL2K E/E SP2)(Compaq DL580 - 4Proc - 8GB RAM). And have worked with PSS to resolve...

Chris

07-08-2003 03:18 PM
Chris

The challenge is to (programmatically) monitor the status of a SQL Server 2000 cluster, in order that the application can make decisions...

Tony Capps

07-08-2003 03:11 PM
John Gose [MS]

I have a two nodes cluster (sql2000 on Windows 2003) with 16 instances (sql hotel) . I have two subnets on them, one GB net and one 100 Mb(for old...

Mathias Johansson

07-08-2003 02:40 AM
Mathias Johansson

I'd start by checking for hardware errors, running diagnostics on the drives, RAID array controllers, etc.. "caddo65590" <caddo65590 (AT) hotmail...

Doug

07-07-2003 05:59 PM
Doug

291255 BUG: IsAlive Check Does Not Run Under the Context of the http://support.microsoft.com/?id=291255 "service account that the cluster service...

Cindy Gross

07-07-2003 12:09 PM
Jp

Geoff, thanks again for your attention. I'm using Windows 2000 Advanced on both servers, SQL 2000 Enterprise edition also. The client is SQL 2000...

Ivan Gastaldo

07-07-2003 10:31 AM
Chris Spiess

How better setup memory usage on Active-Active cluster for SQL servers? Both physical servers have 8GB memory and 8CPU. I'm using Win2K Adv. Serv....

Alex Rybalov

07-07-2003 08:24 AM
Geoff N. Hiten

I am trying to install SQK 2000 Ent onto a cluster and it fails when trying to show the disks in the cluster. The sqlstp.log file shows 13:04:25...

Clive Flint

07-07-2003 08:21 AM
Clive Flint