Can one node be configured to belong more than one clusters? For instance, if we have three nodes: N1, N2, and N3, can we configured N1 failover to...

Lijun Zhang

11-28-2008 01:47 PM
Lijun Zhang

Hi, easy question: Which type of RAID should I use for SQL database + logs in Cluster ? Thanks. Marek

Marek Zaremba

11-28-2008 10:30 AM
Marek Zaremba

Hello, I have a cluster with 3 nodes, currently running 6 instance of SQL2005 at SP2. Each node is Windows Server 2003 SP2. I have tried to install a...

Adam Sankey

11-27-2008 10:18 AM
Adam Sankey

Hello. I have some questions...I'm looking for the right answer. Here it is. If a cluster has three nodes with 4 processors in each, what is the...

Donald

11-27-2008 02:16 AM
Mohit K. Gupta

I have a 2 active/passive cluster running Windows Server 2008 Enterprise. I just installed SQL 2005 Server, which had no problems. However, when I...

Virgil Gloria

11-26-2008 03:49 PM
Bavien

Dear all, I have added a new instance for SQL 2000 SP4 on to one of the node in the clustered server. after i have add the second server for fail...

leezy

11-25-2008 08:16 PM
laicalhermes

Hi, On the installation screen we have two options 1. New SQL SERVER failover cluster installation. Launch a wizard to install a single-node SQL...

martin

11-24-2008 10:58 AM
Geoff N. Hiten

2-node cluster sql 2005 x64 on windows 2003 R2 x64 get error : skipping scan to host xxxxx. unable to connect to registry. in run-time log: error...

Krep

11-24-2008 05:11 AM
Krep

Hi, I have been tasked with setting up a sql server 2008 active-passive cluster. To start with I have been giving two windows server 2008 servers...

martin

11-22-2008 11:11 AM
Saddiq

Hi Could you help me find answer for this question please? I’ve just set up two node fail over cluster (SQL 2008 and Windows Server 2008). In...

Piotr

11-22-2008 04:50 AM
Piotr

I have a two server cluster with 32GB mem. I have six SQL instances running with the default memory settings. Min mem 0 Max all. When I look at...

dfeldman

11-21-2008 03:00 PM
Tom Moreau

Hi, I have a scenario involving a two node cluster each running a SQL 2005 (x64) instance. Each node has 64GB of RAM and 'lock pages in memory' is...

Russ

11-21-2008 02:03 PM
Geoff N. Hiten

Hi, Can I configure a SQL 2008 Instance Directory on a Cluster Drive? I would like to put the system DBs on a cluster drive. But when I select a...

Yuhong

11-19-2008 09:48 AM
Yuhong

Hello, We have a situation where we have Qa environment SQL server 2005/2008 with multiple instances each with different collation. I have been...

Tal

11-19-2008 09:34 AM
Tom Moreau

Hi Guys When I run the cluster validation tool it returns an error on the network setup. It creates a virtual adaptor 13 on both nodes with the same...

Rob A

11-18-2008 06:46 AM
Edwin vMierlo [MVP]

For an existing SQL 2005 cluster which is inactive/passive mode, how can you install SSRS as cluster enabled? The only option seem to be a local...

Robin9876

11-17-2008 04:52 PM
Geoff N. Hiten

Hello all, I have a one-node failover cluster with Windows Server 2008 x64 and SQL Server 2005 x64. I'm using a HP MSA1000 connected by FC as shared...

Juan Miguel Cervantes

11-17-2008 04:50 PM
Geoff N. Hiten

I'm trying to install a clustered version of SQL Server 2005 on Windows Server 2003, and I've no got to the point where I'm not sure what's going...

rangerchris@gmail.com

11-17-2008 04:45 PM
Geoff N. Hiten

Hello all, I have a one-node Windows server 2008 x64 Cluster with Sql Server 2005 x64 installed on it. Shared storage is connected throught FC to a...

Juan Miguel Cervantes

11-17-2008 11:19 AM
Juan Miguel Cervantes

mY SQL SERVER 2005 is very slow especially for seelct queries and i checked the perfmon counters the values rea as follows %disk time =4000 buffer...

bijupg@hotmail.com

11-16-2008 11:39 PM
bijupg@hotmail.com

As SSRS 2005 is not cluster aware, how would you install SSRS in a 2 node cluster (active/passive) that has 2 SQL instances?

Robin9876

11-14-2008 09:48 AM
Geoff N. Hiten

Hi All, Our cluster server has three nodes (active/active/active), total Physical Memory on each node is 32 GB. In this cluster, I installed three...

Chen

11-12-2008 08:57 PM
Geoff N. Hiten

Hi all, I need to install 2 noe failover cluster with server 2008 and sql 2005 servers. I have already finished the following hardware and...

Ismail OZATAY

11-12-2008 02:37 AM
Ismail OZATAY

Hi, I am setting up a 2 nodes sql cluster and not sure what AntiVirus software I should use. Any information will be greatly appreciated.

Yuhong

11-10-2008 12:51 PM
pankaj shyani

Hey Guys!!!! You guys already known to server virtualization. I am doing research on it, meanwhile I have made a blog as...

Computer Guru

11-08-2008 06:56 PM
Computer Guru

Gurus, We have geographically dispersed 5 node MNS cluster (Windows 2003 / Sql Server 2000). Primary site has 2 nodes and secondary site has 3...

Arshad

11-06-2008 11:48 AM
Arshad

Somehow a drive signature on one of my cluster disks has changed. I'm investigating how to write the correct signature but can't find the...

Cqlboy

11-04-2008 02:04 PM
John Toner [MVP]

We are looking to implement an Active / Passive cluster in our environment and some of the instructions seem a little vague. We have a server with...

BillyTWorthington

11-04-2008 11:12 AM
Geoff N. Hiten

I have 4 nodes that have tons of memmory and I wanted to get opinions for SQL 2005 clustering. I visualize the following and wonder if its...

MeHer

11-03-2008 09:26 PM
Geoff N. Hiten

I have a requirement in a SQL2000 and a SQL 2005 cluster where I'd like to create a resource within the SQL resource group which would start a...

Tom Frost

11-03-2008 04:19 AM
Mark Han[MSFT]

I've assigned to suggest proposing a solution in which the stakeholders are interested in having their SQL upgrade from 2000 to 2008. They would...

TechNeedy

10-31-2008 09:22 AM
Geoff N. Hiten

Hi. We have set up failover clustering for our production servers. but we are facing a strange issue when the web application servers try to connect...

anith

10-30-2008 10:06 AM
Geoff N. Hiten

We are trying to enable kerberos authentication on our 2 node active/passive SQL 2005 Ent cluster. we have run the setspn -a MSSQLsvc/hostname:port...

jacksors

10-29-2008 06:51 AM
jacksors

You will have to manually create a MSDTC resource without the wizard. The wizard won't let you share an anchor disk with SQL. -- Geoff N....

OceanDeep

10-27-2008 03:15 PM
Geoff N. Hiten

i want to install an application using SQL 2005 server in two different location where delays (Latency) in communication could be great. how can...

GUSS

10-27-2008 03:13 PM
Geoff N. Hiten

In a SQL 2005 cluster it is only one drive which is on the EVA storage. There are three drives on the EVA and all the drives are visible in windows...

Robin9876

10-24-2008 10:14 AM
Robin9876

I have one of my cluster nodes going into a reboot loop and I have narrowed it down to the NIC on the public side. I troubleshot into safe mode and...

Rockn

10-24-2008 09:52 AM
Rockn

Hi Guys, I have an issue on an MS 2008 cluster build. It is FC connected to the SAN and can see all 3 LUNs presented x8 for the SAN controller...

Rob A

10-23-2008 01:56 PM
Rob A

I have exactly the same problem. Did you by any chance resolve this issue yet? Thanks, William "CK" wrote:

William

10-23-2008 01:42 PM
William

I have a 2 node cluster with 2 instances of SQL 2000 SP4, Node one failed on the cluster and I had to reinstalled the OS. I got the OS installed...

Alex H

10-22-2008 08:54 PM
Alex H

Hello SQL forum users, We are facing the subjected error (Event ID: 17052 "Insufficient Memory Available") on Ms SQL 2000 Cluster at production site,...

Nick Dakoronias

10-22-2008 11:11 AM
Geoff N. Hiten

Is there any special steps required when you are changing out nic cards in a SQL cluster on a W2K3 Enter box?? We are disabling our broadcom cards...

David Zasadny

10-22-2008 06:05 AM
David Zasadny

Guys, do you know if i could test 2 node cluster installation and configuration by using VM's?

Gene.

10-21-2008 11:46 AM
Geoff N. Hiten

i have installed two node cluster . and also configure MSDTC services on cluster . but when i try to move group to other instance(failover) , it...

Manpreet Singh

10-20-2008 07:09 PM
Ryan Sokolowski [MVP]

I don't know if it is correct if I post this question about database mirroring here. I am learning database mirroring using my own computer. So...

Iter

10-19-2008 12:22 PM
Iter

Our failover cluster setup is as follows: -2 nodes, each: 4 QuadCore CPUs (total of 16 shown in Task Mgr), 64 GB RAM -Windows Server 2003 Enterprise...

salsafreak

10-17-2008 11:02 AM
Reuben_Sultana

Hi All, Pls help! I have a 3-node clustered server running 2 instances of sql 2005, with SAN storage mount pointed to a few folder under G$. Now i...

George

10-16-2008 11:47 AM
George

i have installed a two node active/passive sql cluster . the cluster installed successfully. but when i try to move sql server resource group...

Manpreet Singh

10-14-2008 08:51 AM
Manpreet Singh

Hi, We are currently looking at setting up 3-Node Cluster with Active/Active/Passive configuration. I am sorry clustering is my weakness and I not...

Mohit K. Gupta

10-13-2008 03:57 PM
Mohit K. Gupta

This is the first time I will be installing 2005 Sql Server in an Active/Passive Cluster as a result I have a few questions. 1.The Server cluster I...

Javier

10-13-2008 11:00 AM
vskyban