Thanks for the reply. I notice that the processor utilization is almost uniform even though the "max degree of parallelism", "config_value and...

Manoj Kumar

01-31-2007 06:45 PM
Manoj Kumar

We have a 2-node single instance SQL 2005 EE SP1 cluster running on Windows 2003 EE SP1 and using a SAN. Suppose a disk drive is configured as a...

Jeff Swearingen

01-31-2007 09:54 AM
Jeff Swearingen

No, I have not yet seen this message. Things I would check: The account you logged in as has administrator privileges on both nodes. That you...

Juanjo

01-31-2007 04:52 AM
Juanjo

Hello. We have a SQL Server 2000 2-none Active-Active Cluster configuration. There are (3) physical NICs in each node. Within Cluster...

nada.cascadia@gmail.com

01-31-2007 03:17 AM
Edwin vMierlo

We have a A/P W2K3 cluster running SQL 2005. This morning the following error was recorded: The Cluster Network Driver has lost contact with Cluster...

DTully

01-29-2007 10:36 PM
Anthony Thomas

Does the Cluster Service Account have all those same permissions? Why are the cluster resources and SQL resources in the same group? Can you start...

Kevin3NF

01-29-2007 08:17 PM
Anthony Thomas

Does MS SQL 2005 support Compute Cluster Server /HPC? If so where can I find details? Thanks Bill

William F. Kinsley

01-28-2007 05:21 PM
William F. Kinsley

Hi Guys, Have a weird one. I was running windows update on my nodes. My passive node reports that it needs SP1 My active node doesnt need it . Any...

Padraig

01-26-2007 08:50 AM
Edwin vMierlo

Hi I am looking into finding a cheap solution for a .Net/sql server web app that gives high availability and hardware redundancy. Given that...

Henry

01-23-2007 03:05 PM
Joe Yong

New instance requires disk resources. I don't have disk resources available. Or is 2005 that much different... -- Kevin Hill 3NF...

Kevin3NF

01-23-2007 09:01 AM
Kevin3NF

I am really curious with all these SAN technologies and that all of it calls for quiescing the disks i.e. stopping writes for a brief sec(s) to take...

Hassan

01-23-2007 03:12 AM
Edwin vMierlo

For a 2-node system, we typically use just a network cross-over cable. If you expand this cluster for additional nodes, the heartbeat uses...

Russ Kaufmann [MVP]

01-22-2007 07:45 AM
Anthony Thomas

We have been running a standalone SQL2005 box which uses a dedicated webserver for the last 12 months and both sit on our perimeter (DMZ) zone. The...

Enghps1

01-22-2007 07:34 AM
Anthony Thomas

Hi all, We are considering hardware upgrade.Can SQL Server 2005 Enterprise and Standard Edition fully take advantage of the Quad Core architecture...

Sezgin

01-20-2007 01:50 PM
Anthony Thomas

I fully agree, that would not be sufficient, hence I mentioned the TF/SIM option, to let the OP know there are tools to do this properly. To be...

Russ Kaufmann [MVP]

01-20-2007 10:51 AM
Anthony Thomas

Yes. If you go to a command prompt on the problematic cluster node and type the following, it will delete the cluster service from the node: cluster...

John Toner [MVP]

01-16-2007 01:28 PM
Rodney R. Fournier [MVP]

It works nicely. Though nothing beats a dry run where you actually test the tool. Cheers, Rodney R. Fournier MVP - Windows Server -...

Rodney R. Fournier [MVP]

01-16-2007 01:01 PM
Kevin3NF

Hello, We are looking into migrating a two-node clustered win2k3 system from SQL Server 7 to SQL Server 2005. Because we use database clustering,...

Andy Johnson

01-16-2007 06:27 AM
Hilary Cotter

Yes, quite a bit actually, but it is still doable, kind of like clustering SQL Server on 6.5 or 7.0. Anthony Thomas -- "WalidSQL2k5"...

Anthony Thomas

01-15-2007 12:16 PM
Anthony Thomas

Hi, Can someone guide me through setting up the LogShipping The environment I'm working on is a 2 node Failover SQL 2k Cluster on Windows 2000 Adv...

Vick Shaw

01-15-2007 10:31 AM
Hilary Cotter

Good Morning, I need to demote a two nodes SQL Server 2000/Windows 2003 cluster domain controller to member server. I have 2 other...

Fra - let it B

01-15-2007 08:05 AM
Fra - let it B

We have datawarehouse servwer with Active/Active cluster. One node has 8GB Ram and another node has 12GB. Right now I have configured for both the...

DKRReddy

01-14-2007 11:20 PM
Anthony Thomas

Yes you can. (as long as you have a drive-letter available for doing so) rgds, Edwin. "johnisccp" <johnisccp (AT) discussions (DOT) microsoft.com>...

Edwin vMierlo

01-14-2007 10:46 PM
Anthony Thomas

I would try option 2, but be prepared for option 1 if it does not work. Unfortunately, this is not something you can test will in a virtual or...

Geoff N. Hiten

01-14-2007 10:38 PM
Anthony Thomas

By default, the Default instance is assigned TCP 1433, Named Instances use Dynamic Ports; however, this same manual states that the best practice...

Khwaja Arshaduddin

01-14-2007 01:39 PM
Anthony Thomas

AMD makes both x86 and x64. Intel makes IA-32 (x86), IA-EM64T (x64 compatible), and the only one that makes IA-64 (EPIC). When you say mixed,...

Bryan Aldrich

01-14-2007 01:25 PM
Anthony Thomas

I'm trying to setup a SQL2005 cluster and in the setup dialog I get to the Domain Groupa for Clustered Services before I get an error. I'm logged...

cw

01-11-2007 12:47 AM
Dillon

Not sure if this is the proper place but i felt that this would be a good start, i have some general questions and hope that someone with real...

Lyghtnin

01-06-2007 02:48 PM
Lyghtnin

Hi, I have a two node SQL Server cluster running under Virtual Server 2005 environment (Windows 2003 Server RD2, SQL 2005 Dev, sp1). After...

Daniel

01-06-2007 01:12 PM
Daniel

Hello I have a Windows 2003 SP1 IA-64 cluster with four nodes. On this cluster I have two SQL Server 2000 SP4 IA-64 Virtual Instances installed and...

Carlos Selonke

01-05-2007 02:14 PM
Carlos Selonke

I'm not aware of any .NET classes for this (from Microsoft), but would love to be surprised. Linchi "Chris" wrote:

Linchi Shea

01-05-2007 01:49 AM
Jasper Smith

On the entry screen of Surface Area Configuration, click on , and type in the virtual server name of the instance (without the instance name, if it's...

Linchi Shea

01-04-2007 11:29 PM
Linchi Shea

Linchi is correct, you need a separate clustered group and network name for every instance. Now onto the VMP issue. I think you are confusing disks...

brimoore@state.pa.us

01-03-2007 08:08 AM
Rodney R. Fournier [MVP]

Check...

Tom Moreau

01-02-2007 05:29 PM
Tom Moreau

You cannot install two default instances within the same cluster. Best to go with 2 named...

Tom Moreau

12-30-2006 08:36 AM
Andrew J. Kelly

I need to add two additional SAN attached volumes to be dependencies for my SQL Server Cluster resource. Do I have to restart the cluster service...

zoneranger@gmail.com

12-28-2006 09:28 PM
Linchi Shea

I think what Linchi is trying to point out is that it is difficult to make blanket statements about performance because performance depends to a...

Anthony Thomas

12-28-2006 12:39 PM
Roger Wolter[MSFT]

No where near enough information to help you. I suggest you find someone that knows the application to help you. -- Arnie Rowland, Ph.D. Westwood...

Arnie Rowland

12-26-2006 02:24 PM
Hassan

Hi Is there any TSQL query/function/procedure that would return the metadata about the SQLServer cluster?? I need to write a program to get...

Vijay Ram S

12-26-2006 01:40 PM
Linchi Shea

I haven't set up a failover cluster before and hope someone can help. It is Windows 2003, SQL Server 2005 failover cluster. We have set up 2...

dmcmillan via SQLMonster.com

12-24-2006 03:11 PM
Geoff N. Hiten

Hello, We have SQL 2005 installed on Windows 2003 active/passive cluster. A domain account is used in the cluster setup. The sql server name has...

Wilson U

12-24-2006 10:07 AM
Anthony Thomas

That's ok. And I would agree: Microsoft documentation over an unknown on the inet, Microsoft wins. However, I strongly urge you to read the...

Anthony Thomas

12-22-2006 11:11 PM
Anthony Thomas

OS: Windows 2003 SP1 64bit Enterprise Ent. SQL 2005 Standard Ent SP1 installed. Active/Passive Cluster setup I have evicted and rebuild the node and...

Wayne

12-21-2006 05:11 PM
Wayne

With log shipping or database mirroring you have two complete copies of the databases and the copies can be separated by thousands of miles...

MB

12-21-2006 03:59 PM
Roger Wolter[MSFT]

we have a 2 nodes win2k server cluster which installed sqlsrv 7.0, the primary one failed, and the secondary take over the service as design. we do...

linbiao

12-20-2006 09:53 PM
rex zhen

Thank you both for your responses. I've a bit more confidence now. Andrew

adb2303

12-20-2006 12:59 PM
adb2303

Hi All, I would like to know if it's possible to have on the same cluster instance, the cluster server and the analysis services. Or if I have to...

Xavier Catillon

12-20-2006 10:12 AM
Edwin vMierlo

Hi all, I need a bit of help with a really strange problem we've got with out SQL cluster. The setup is - 2 windows 2003 nodes, sharing a das,...

kristan.mcdonald@googlemail.com

12-20-2006 07:58 AM
Anthony Thomas

Hi, We need to implement a solution in which two Windows 2003/ SQL Servers 2000 based servers being located behind firewalls in two different...

Alex

12-20-2006 03:25 AM
Edwin vMierlo

We're attempting to add a second node to a single node SQL Server cluster running on Win2k SQL2k SP4. The install appears to work OK but when trying...

Lightning-dave

12-18-2006 08:18 PM
Anthony Thomas