1) Query DNS, I'm assuming you know the hostnames. 2) Have you looked at the WMI class MSCluster to see what it makes available on your windows 2000...

Tim Walsh

06-16-2008 04:45 AM
Tim Walsh

Hi Folks, Need a little bit of insight, we *might* be looking at implementing 8-Node cluster. I can set up 2-node cluster without issue...

Mohit K. Gupta

06-13-2008 03:52 PM
Mohit K. Gupta

Hi all, I'm testing the installation of SQL Server 2005 clustering on a Windows Server 2008 Failover Cluster. The Server 2008 cluster setup went...

scorpiuss

06-13-2008 12:00 PM
Geoff N. Hiten

Hi All, first of all, sorry if this kind of question has already been done, but I'm not able to find it (may be I used wrong keywords): I...

T_M_P

06-12-2008 03:47 AM
T_M_P

When failing over to a passive node a customer is getting this error in the SQL Error Log: "Configuration block version nnnn is not a valid version...

Neil W.

06-10-2008 03:43 PM
Neil W.

On a Windows 2003 cluster that has SQL 2000 that has only one node in the preferred nodes. What is the implications of adding all the other nodes in...

Robin9876

06-07-2008 11:24 PM
Linchi Shea

For a SQL 2000 Clustered Server, what is the process to apply a SQL SP to the cluster?

Robin9876

06-06-2008 08:31 AM
Tom Moreau

is there any documentation on how to setup a 8 node active/active sql cluster?

joey

06-05-2008 02:21 PM
Peter Lindberg

Hi folks I am new to sql installation on clusters, they were installed before me. I have 2 questions: 1. how do I install 2 virtual servers on 2 node...

Gene.

06-05-2008 12:43 PM
Tom Moreau

Dear All, I'm installing Active/Active cluster of SQL 2005 64 over Windows 2003 R2 SP2, I need a step by step documentation to do that, any...

MM

06-05-2008 09:17 AM
Tom Moreau

We have an application that requires specific volume labels on the clustered drive. Are there any issues/concerns/gotchas with changing the volume...

VFisher

06-04-2008 09:09 AM
Linchi Shea

Running SQL Server 2005 on Windows Server 2003 Cluster. I am receiving odd messages such as. Any ideas? Error 1 Event Type: Error Event...

Rustom

05-31-2008 03:28 PM
Edu Alcaniz

Thanks in advance for any help. A SQL 2005 Failover Clustering installation (from the RTM disks) failed on Database Services. Please see messages...

=?Utf-8?B?TWljaGFlbEFfQ0NHQQ==?=

05-30-2008 06:17 PM
Edu Alcaniz

FREE Tutorials on HTML XHTML CSS JavaScript XML XSL ASP SQL ADO VBScript, SAP - ABAP visit ebooks.univdatabase.com

univbgp116@gmail.com

05-27-2008 04:37 AM
univbgp116@gmail.com

The 2-note SQL server 2005 sp1 on Windows 2003 R2 sp1 was working until yesterday. In the Cluster Console, Cluster Group is up and running but in...

Ian

05-26-2008 07:38 AM
Ian

Hi, I have a very new SQL 2005 installation. This is a clustered installation though I'm not sure my problem is cluster related, so I hope I posted...

Tony

05-23-2008 05:17 AM
Charles Wang [MSFT]

Hi all, I am going to move my MDFs and LDFs onto our new SAN. Can I use KB224071 to do the move? I have used this article before on a SQL Server...

Eugene

05-23-2008 02:26 AM
Tibor Karaszi

Was able to persuade management to purchase the equipment (listed below) for 2-node cluster and SAN. 2 x Dell PowerEdge 1950 servers with 4GB ram...

tagtagboys@gmail.com

05-22-2008 09:25 AM
Geoff N. Hiten

SQL SErver 2005 Std edition. Nodes are pingable from each as well as the cluster resource. Recieve the following error during install any...

Joe

05-21-2008 02:45 PM
Joe

Hope someone can help me out with this or at least point me to the right direction. We're in the process of implementing an application that is...

tagtagboys@gmail.com

05-20-2008 01:32 AM
tagtagboys@gmail.com

I have a 2 node active/passive SQL 2005 cluster that is connected to fiber channel san. We are going to be upgrading both nodes with completely new...

dave_vandenberghe@yahoo.com

05-19-2008 10:27 AM
Geoff N. Hiten

I have a 2 node SQL2K5 SP2 (build 3042) cluster with 1 instance running on W2K3 SP2 ia64. We are going to replace the hardware and the new will be...

Peter Lindberg

05-14-2008 10:33 AM
Peter Lindberg

Hello, I'm trying to configure Database Mail on our Cluster running 2 SQL server 2005 SP2 node. The configuratoin wizard is running fine and I...

Julien

05-13-2008 03:28 PM
Geoff N. Hiten

I am learning the ropes concerning supporting sql server on a cluster. I have a couple of 2 node clusters running active/passive with SQL 2005. In...

Russell Hardie

05-13-2008 10:40 AM
Russell Hardie

I have a scenario where I have 2 environments. a) Production b) Test We maintain a current copy of our DB for Dev purpose. Currently I'm synching...

VBeachcomber

05-13-2008 09:02 AM
Uri Dimant

DPM Duration is stored in microseconds in SQL Server 2005 as opposed in SQL Server 2000 in milliseconds Many things have changed such SQL Server...

Uri Dimant

05-13-2008 12:02 AM
DPM

Does anyone have procedure on installing Cumulative update package 7 for SQL Server 2005 Service Pack 2 on 2 node SQL 2005 cluster? Thanks. William

William

05-09-2008 12:11 PM
Chris Wood

I have a test domain which include 2-node SQL 2005 clusters. Default instance is running on it well. As installing a named instance INS2 it gave...

murat

05-09-2008 09:10 AM
Geoff N. Hiten

Hello, I am running into an issue here. I want to create an active/active cluster. So far I created an active/passive cluster with 1 named instance...

William Delgado

05-08-2008 08:49 AM
Geoff N. Hiten

Due to a fat finger error the SQL Network Name is incorrect on one of our Clustered SQL 2005 installs. Can I simply change this name without any...

Bruce

05-05-2008 11:15 AM
Tom Moreau

Hi, Using a P4 computer, 2.8GHz, 958 RAM the performance are as follows, Please could someone advise what can be done to improve the performance...

DPM

05-04-2008 11:51 PM
DPM

Hi All: I'm hoping someone can either point me to a whitepaper or let me know if there are any gotchas about setting up transaction log shipping...

geekyguy

05-02-2008 12:13 PM
geekyguy

The SQL 2005 Enterprise clustering checkbox is greyed out when trying to install it for clustering under Windows 2008 Datacenter. SQL and OS...

ja

05-01-2008 11:50 AM
Russ Kaufmann [MSFT]

I have an active/active cluster running under SQL Server 2005 64 bit sp2. After upgrading to build 3239 the SQL Server Agent won't start anymore......

RQ

05-01-2008 09:05 AM
Geoff N. Hiten

Hi, I have installed SQL2000 and SQL2005 on the same computer accessing the same DB When run the following simple queries the performance is as...

DPM

04-30-2008 09:52 AM
Tom Moreau

Hi, I have built a 2005 two node sql cluster and we are seeing very poor client access speeds. Clearly there could be a zillion reasons for this and...

Paul

04-28-2008 08:12 PM
Geoff N. Hiten

I had a cluster named oldcluster. I created a new cluster called newcluster. I evicted node1 from oldcluster, ran "cluster node node1 /forcecleanup....

Paul Riker

04-27-2008 03:25 PM
Anthony Thomas

Hi, I need a simple procedure to upgrade our SQL2005 active/active cluster. It's presently unpatched. From what I understand I need to do the...

MLavoie

04-27-2008 03:21 PM
Anthony Thomas

I have a cluster with 3 nodes, under SYSTEM in the event viewer I receive those Warning message every 3 secondes. ID 1123:The node lost...

Hasan

04-27-2008 03:17 PM
Anthony Thomas

Hi SQL Server 2000 and 2005 Cluster coexisting...?, MS say yes but I wonder if it is a good idea in an production environment... Someone has...

Chevy

04-27-2008 02:59 PM
Anthony Thomas

Hi All, I am running a SQL Server 2000 in an active/passive cluster. I want to move all SQL Server structures (BACKUP, Data, FTDATA, JOBS,...

Eugene

04-23-2008 12:25 PM
Eugene

I have setup Active/Passive in the past with no problems With Active/Active/Passive are all nodes on the same heartbeat? Is the correct Private IP...

Duparoni

04-23-2008 04:00 AM
Edwin vMierlo [MVP]

SQL 2005 Enterprise running on Windows 2003 Enterprise confgured as Active/Passive cluster. Having problems creating the BCM database using...

Bill Board

04-22-2008 02:36 PM
Bill Board

All: I have a 6 yr old SQL2000 server running on Win2000. I have two brand new HP DL380G5 servers that were ditched from another project which have...

haroldsjunkmail@gmail.com

04-21-2008 10:24 AM
haroldsjunkmail@gmail.com

I can run the SQL 2005 Upgrade Advisor against stand alone SQL 2000 Servers and get results but when I ran it against our SQL 2000 Cluster it does...

TimonT

04-21-2008 01:28 AM
Oliver Yao - MSFT

I can run the SQL 2005 Upgrade Advisor against stand alone SQL 2000 Servers and get results but when I ran it against our SQL 2000 Cluster it does...

Lanny Boy

04-21-2008 01:27 AM
Oliver Yao - MSFT

Hello Gurus I have win2k3 cluster (RTM) no sp on os with SQL2000 sp4 running. MSDTC is not configured on the cluster. THe plan is to install MSDTC...

Jason

04-20-2008 04:24 PM
Geoff N. Hiten

PLEEEEEASE HELP I am at my wits end now 3 days 5-6 Install / Un-Installs with trying to get this 2 node Active/Passive to start the SQL Server...

Joe

04-20-2008 12:57 AM
Joe

Hi Audit Profs, Go and get a copy of Secure Auditor to conduct audit, execute penetration tests, enforces compliance and forensics on your...

alvin.amedeus@googlemail.com

04-19-2008 03:03 AM
alvin.amedeus@googlemail.com

Hello, Is there a limit on how many nodes you have within a SQL 2000 enterprise cluster hosted on a Windows 2003 Enterprise cluster? The reason I...

AJ

04-18-2008 02:42 PM
Nirmal Sharma