I have a data warehouse transactional replication environment in which we have muliple Publisher/Distributors(100+) and a single subscriber. All...

rum63

03-15-2005 11:20 AM
Geoff N. Hiten

I am attempting to install my 3rd cluster into an ip5000 iscsi SAN and I am encountering some very odd behaviour. I have finally concluded after...

The Lorax

03-15-2005 04:52 AM
Mike Epprecht \(SQL MVP\)

I've read about a thousand different things and really need a straight answer: I'm setting up clustering on a dual-node W2K3 cluster. If the...

A. Robinson

03-14-2005 10:06 PM
Linchi Shea

Hi, I am getting the above error on the production box which has SQL 2000, sp3a build 8.00.780 with AWE and PAE enabled and SQL Server...

kneel

03-14-2005 09:55 PM
Linchi Shea

Is there a way to break my Active/Active cluster back to have a single stand-alone SQL server? internal politics and a rogue admin who applies...

Ron Griffin

03-14-2005 10:29 AM
Rodney R. Fournier [MVP]

Hi, I am using SQL Server 2000 on Windows 2000 server. Here is my problem: @String = 'word1word2word3word4word5' - This value is passed to...

Vanessa Lee

03-13-2005 10:28 PM
Vanessa Lee

Hi there guys I am having a problem with a clustered default instance. During the process of changing the statup parameters with the intention...

News.telkomsa.net

03-11-2005 06:26 PM
Dave Whitney [MS]

Hi there. I am having problems with MSDTC on a 2-node clustered server. I currently have it added as a resource in a group with disk storage, SQL...

len

03-11-2005 05:59 PM
Dave Whitney [MS]

There on and accessable through Explorer and Disk Management. However when I try to install SQL as a new virtual instance I only have access to my...

dibblm

03-11-2005 05:55 PM
Dave Whitney [MS]

Hi Guys, rirht now my databases running on two seperate sql servers server1 and server2 and ecah having MSDTC . Now i am planning to shift these two...

Bijupg

03-11-2005 05:43 PM
Dave Whitney [MS]

Hi, Can I put the MSDTC resource in Defaul Cluster Group ? I dont have available disk to it. thanks, Rubens

Rubens Luque Sanches Jr.

03-11-2005 05:41 PM
Dave Whitney [MS]

I am configuring a two node SQL cluster and i have 5 physical disk arrays and i intend to use them in the following order disk array 1 for...

slawal

03-11-2005 05:40 PM
Dave Whitney [MS]

Where I would use each of the following index types in relation to query type and/or data set: Hashed, Sorted, Bitmapped(Ranked), Clustered

ManuTop

03-11-2005 05:01 PM
ManuTop

Right Click My Computer - Properties - Remote tab - Allow users to connect remotely to your computer (check it). Cheers, Rod MVP - Windows Server...

Joe K.

03-10-2005 04:03 PM
Rodney R. Fournier [MVP]

You might want to check to to see if the other node is a possible owner of all of the resourses. I had a problem like that and there on resource that...

Joseph Barger

03-09-2005 07:54 AM
Joseph Barger

Can you Implement Log Shipping between geographically dispersed clusters. The main aim is to provide DR for 2 clusters to a single cluster located...

Adrian56

03-08-2005 09:09 PM
Geoff N. Hiten

Does anyone have any advise or information on how to configure EFS on a Windows 2003 Enterprise server Cluster running SQL Server 2000? We...

Mike Z.

03-08-2005 11:13 AM
Mike Z.

Does any one have experiences with Mixed mode cluster? I am trying to add a windows 2003 node as primary node to an existing window 2000 active...

Anand Musunur

03-07-2005 09:34 AM
Geoff N. Hiten

2 out of 4 instances on my 3 node cluster wil not come online on one off the clusternodes, unless I add an alias (which I removed after installing...

Hans de Bruin

03-04-2005 10:01 AM
Hans de Bruin

Hi Everyone, I have an Active/Avtive 2 node cluster running WIN 2003 with SQL Server 2000 (SP3a). Over the last couple of days i have been...

PK via SQLMonster.com

03-03-2005 03:21 PM
Priyanga Karunathilake via SQLMonster.com

Hello, I'm trying to set up alerts for jobs and backups, using sql mail. Will this work in a clustered enviroment? if so, can you please forward...

Calvin Do

03-01-2005 11:34 PM
Greg D. Moore \(Strider\)

I'm looking for help in locating a script that would allow deliberately causing a cluster to failover. (For demonstration and testing purposes.) And...

Arnie Rowland

03-01-2005 02:26 PM
Arnie Rowland

Can anybody tell me the differences, advantages or disadvantages in installing an active/active cluster...

Steve

03-01-2005 01:19 PM
Steve

Hello, I have a sql 2000 box that has roughly 15 datbases. How do i determine how much memory/cpu a particular db is using? thanks! Calvin

Calvin Do

03-01-2005 12:50 PM
Calvin Do

Hello, may be a dumb question, but how do i determine if i've setup msdtc correctly on a sql 2000 cluster? thank you Calvin

Calvin Do

02-28-2005 08:55 PM
Calvin Do

we have an active-active sql cluster configured as follow: server A - 4gb ram - sql server instance #1 server B - 4gb ram - sql server instance...

Ettore Pancini

02-28-2005 06:30 PM
Mike Hodgson

I receive a "Cannot generate SSPI context" error message when you try to connect to a SQL Server 2000 SP3 server computer. According microsoft's...

Yianni

02-28-2005 05:04 PM
Simon Lidberg [MSFT]

I have setup a new 2 node A/P SQL cluster on W2K3 ent. When the server is running on node 1, if i open a new data source or server registration i...

Lapchien

02-28-2005 03:18 PM
Lapchien

I am trying to install a named instance on an active/passive cluster using sql 2000 and windows 2003 both entrprised editions. HEre is the latest ...

Anand Musunur

02-27-2005 10:29 PM
Anand Musunur

What is the better to use in active/active SQL 2000 cluster ? 1 Default instance and 1 named instance or 2 Named Instances ? There are any...

Rubens Luque Sanches Junior

02-27-2005 05:27 PM
Mike Hodgson

Does anyone know how to enumerate cluster info (Microsoft cluster server 2000) through VBS. But more specifically, is there a way to execute the...

news.cox.net

02-25-2005 01:43 PM
Shon Shah [MSFT]

To keep the number of driveletters to a minimum, have the same directory structure on the instances and do something with disks and performance I...

Hans de Bruin

02-25-2005 10:49 AM
Mike Epprecht (SQL MVP)

Dear All, I have recently setup an active-active Microsoft SQL 2000 cluster on Windows 2003, and I am starting to wonder how such a setup can...

Patrice

02-25-2005 10:08 AM
Patrice

Hi, I was told by someone that after install clustering SQL Server 2000 named instance, it must remove that before installation made the alias. Is...

Chen

02-25-2005 08:46 AM
Donna Lambert [MS]

Hi Nik, In addition to the great advice/comments that Geoff had, I wanted to add that SQL Mail is not supported on a...

Donna Lambert [MS]

02-24-2005 05:38 PM
Calvin Do

Jerrick, Geoff's answer is dead on! The only other thing to consider is that there can only be ONE default instance PER CLUSTER. The second instance...

Donna Lambert [MS]

02-24-2005 04:45 PM
Donna Lambert [MS]

I have an Active/Active cluster with Windows 2003 with SQL Server 2000. I am trying to move the cluster disk T: owner to my other group. I keep...

Joe K.

02-24-2005 04:38 PM
Donna Lambert [MS]

Hi, How many instances of SQL server I need to install in 2 - node server cluster for Active/Active and for Active/Passive mode 'on each node'...

Pankaj

02-24-2005 04:36 PM
Donna Lambert [MS]

Hi Tim! Yes, you can remove and reinstall MSDTC 'underneath' SQL. However, the health of this cluster sounds pretty suspect! I would caution you to...

Donna Lambert [MS]

02-24-2005 04:32 PM
Donna Lambert [MS]

Joe, This could indicate a variety of things. You might want to consider opening a support incident with PSS. They would take you through a...

Donna Lambert [MS]

02-24-2005 04:23 PM
Donna Lambert [MS]

Hi, I completely understand that SQL-Clustering is failover technology and not a load balancing technology. 1. What I'm wondering is when you go for...

Pankaj A. Chitriv

02-24-2005 04:15 PM
Donna Lambert [MS]

I have a SQL Server 2000 Cluster with Windows 2000 Server. The Cluster was set up as a Active\Active and I would like to change it...

Joe K.

02-23-2005 09:52 PM
Geoff N. Hiten

This past weekend I was challenged a little in resolving what I hoped was a simple collation issue. We are running Win2K3 Ent. Clustering Services,...

MikeH

02-23-2005 06:49 PM
MikeH

I have read that SQL Server with MSCS supports an Active/Active setup via a NAS, however, DOES NOT support and Active/Active setup via a SAN....

TABMCSE

02-23-2005 12:19 PM
TABMCSE

Hello, Node 1 & 2 event logs (system) display the following. What does this mean? Thanks - Covi Event Log (System Message) follows: An anonymous...

Covi

02-23-2005 10:43 AM
Covi

Hello: I have installed SQL 2000 Enterprise in a Microsoft Cluster Windows 2000 several times. I am trying now to install it on a MSCS Windows 2003...

j05e

02-23-2005 07:55 AM
Mike Epprecht (SQL MVP)

Services or applications using ActiveX Data Objects (ADO) 2.0 or greater may intermittently return empty recordsets on queries that should be...

Gabriel Mejía

02-22-2005 03:23 PM
Gabriel Mejía

Hi I have 2 questions, but related! We currently have a Windows 2000 Adv server running SQL Ent 2000 as a 2 node cluster. Each node currently has...

02-22-2005 01:47 PM
Rodney R. Fournier [MVP]

Hi , is there any command to display current cluster name through query . Thanks ARR

Aju

02-22-2005 09:58 AM
Ayad

The cluster is not running with the required access. Pls check the access by giving the correct user / pass Regards Nirvan "Joe P." wrote:

Nirvan Biswas

02-21-2005 07:02 PM
Mike Hodgson