I have a 2 node active/passive cluster running SQL2008 with SP1. Installation was performed by command line script using a config file. Started with...

tom

04-19-2010 08:29 AM
Charles Wang [MSFT]

When applying SQL Server 2005 service pack 3 to Windows 2003 server, I received the following error listed below. Please help me resolve this...

Joe K.

04-11-2010 10:05 PM
Joe K.

does anyone have an opinion on doubletake as a 3rd party tool to do clustering of sql servers? tia Cb

Chris

04-09-2010 06:13 PM
RCan

You first have to replace the cluster node. Then you may need to update SQL and remove the settings for the old node. If you reused the node name,...

Geoff N. Hiten

04-06-2010 11:37 AM
Geoff N. Hiten

Hi I have trouble with kerberos authetication from IIS server that connect to the SQL Server . How I enable kerberos authetication in the SQL cluster...

Marek

04-01-2010 04:35 PM
RCan

I have a sucessfully running cluster with instance IDs available on both, and with failovers sucessful. I added a third server, Windows 2008 SP2,...

Robert

03-26-2010 09:29 AM
Geoff N. Hiten

Hi, We already create an Active/Passive 2 node Hyper-V Cluster, but now, we need 2 node Active/Active cluster. Is it possible? How can we do...

Daniel Costa

03-24-2010 11:05 AM
Daniel Costa

Hello, I'm hoping someone can help me. I'm currently in the process of installing a SQL Cluster on Windows 2008 Ent Edition using Windows...

tonyw88

03-22-2010 09:47 AM
Geoff N. Hiten

I ran into a problem running a 64 bit clustered install of SQL Server 2008 Standard Edition. This install was done on Windows Server 2008...

Cgallelli

03-19-2010 10:23 AM
Cgallelli

The SQL cluster is not failover over to another node. Can anyone shed some light in to this. I have checked the config on the cluster administrator...

Praful Varsani

03-16-2010 07:59 AM
Geoff N. Hiten

Hi all, Is it possible to place the tempDB on internal disk and the data on SAN? Please help.... Many thanks

Tedi

03-10-2010 03:17 PM
Geoff N. Hiten

I cannot diasbale the VIA protocol and get the primary SQL instance to start in my Virtual Cluster the Attributes of the Server configuration is as...

Dennis

03-10-2010 02:07 PM
Dennis

I am running SQL Server 2005 x64 on Windows 2003 active/passive cluster. We are currently having latency issues with our SAN, this is causing the...

Jim Clark

03-02-2010 10:13 AM
Pat Klein

Can anyone suggest a best practice for maintaining cluster.log history? I know there are environment variables that control the log size and a...

Will Banta

02-25-2010 10:06 PM
Will Banta

Hi We have a 2-node cluster running Enterprise x64 SQL 2005 on W2K3. We wish to install additional instances to assist management. We intend to...

Steve

02-25-2010 10:21 AM
Geoff N. Hiten

Everyone, I have configured a SQL 2005 cluster with two nodes. My SQL data is on a SAN attached drive managed by NetApp which is drive x:. When I...

Amador

02-23-2010 11:16 AM
Geoff N. Hiten

Good morning, all - Two node SQL 2008 cluster attaching to SAN storage. Dual path software in place on both nodes. On a failover attempt (planned or...

GaTech_Geek

02-22-2010 02:39 PM
RCan

Is anyone aware of a utility or a script that is available that would allow an automated failover of a SQL Server Virtual Cluster Resource Group...

tom

02-22-2010 03:41 AM
Charles Wang [MSFT]

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on the...

Mia

02-17-2010 08:11 PM
Mia

I've set up our first sql2k8 cluster on w2k8 r2 and it works as expected. Now I got a funny experience with the firewall. As I want it the firewall...

Peter Lindberg

02-16-2010 02:00 AM
Peter Lindberg

Hi i upgraded sql server 2000 sp4 active/passive cluster (windows 2003 sp2) and got into issue. Ran the upgrade on active node and the node...

krishna

02-12-2010 05:51 PM
krishna

Many problems with performance and safety of your computer can be solved easily with an updated antivirus and recognized. Antivirus Free...

antivirus gratis

02-07-2010 06:00 PM
antivirus gratis

We have an active-passive cluster environment with Windows Server 2003 and SQL Server 2005, where the MSDTC is working correctly, in the...

Elmo

02-06-2010 07:04 PM
Geoff N. Hiten

I think I discovered a BIG problem with Windows 2003 x64 R2 SP2. Suppose I set a setup a server and connecting it to a SAN disk and then format this...

Gaspar

02-05-2010 01:32 PM
Geoff N. Hiten

We have 2- node Windows Enterprise 2003 x64 servers clustered in active/active configuration with SQL 2005 x64 installed on it. Both servers are...

Dovla

02-05-2010 09:06 AM
Dovla

Hi All Application uses ASP.Net 2005 and SQL server 2005 We are connecting to the web application from a local machine. When we click a button on...

hems

02-03-2010 02:44 AM
Uri Dimant

Hi, I'm running 4 instane SQL Server 2005 in an active/passive clustered enviroment utilizing a SAN. I'm running out of space on one of my LUN's for...

d7

02-02-2010 05:14 AM
d7

I am looking to implement SQL Clustering on a SAN with SATA drives. While I know that clustering is not a "performance" solution, however...

John

02-01-2010 06:57 PM
Andrew J. Kelly

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on the...

Mia

02-01-2010 02:55 PM
Mia

we would like to setup the SQL DB using windows cluster, is it a must to have external storage ? the 2 server have Raid 5 configure, can we...

DD

01-30-2010 11:13 PM
daveberm

All, SQL Server 2005 EE SP3 CU1 in an active-passive failover cluster configuration. Whenever I fail over the cluster or restart SQL Server, the...

Ant-nee

01-29-2010 11:45 AM
Ant-nee

Muchos problemas de rendimiento y seguridad de tu computador son causados por virus maliciosos, la mejor forma de combatir esto es tener instalado...

antivirus gratis

01-29-2010 08:36 AM
antivirus gratis

hi i have an active/passive sql sever 200+sp4 cluster and i need to upgrade it to sql2008 cluster. the BOL is saying " to run the setup on...

krishna

01-28-2010 02:38 AM
kpxus via SQLMonster.com

Hello, I am trying to install a MS SQL SERVER 2005 64 Bits in cluster, but when the process is finish I get this error (Microsoft SQL Server 2005...

mike

01-27-2010 08:10 PM
Geoff N. Hiten

having an issue installing a 2nd instance on a 2005 sql cluster running on win2008 R2. It may be simple since i've never done this on 2008...

ccinatl

01-27-2010 08:08 PM
Geoff N. Hiten

Hi all, I am new to Windows and SQL Server clustering. I want to install Windows 2008 on two servers and have two SQL Server 2008 sp1 clusters. Each...

Preethiviraj Kulasingham

01-26-2010 10:28 AM
daveberm

i need a quick way to provide failover for my sql server. i just want to have a backup ready to go if server A fails. i will have only two servers....

mcnewsxp

01-25-2010 08:49 PM
Geoff N. Hiten

I have a 2-node SQL Server 2008 cluster. S:\ is the shared drive for the SQL Server cluster group. Can I create an INETPUT folder in S:\ for IIS? Is...

Gaspar

01-21-2010 02:09 PM
Geoff N. Hiten

I'm seeing some issues on a Two Node cluster (majority + disk). Failover works GORGEOUSLY. No problems. They go like a volleyball game. But when...

Robert Hindla

01-21-2010 02:09 PM
Geoff N. Hiten

I am working on design/testing of a large sharepoint site, on the DB side is there any downside to using a mix of shared storage rather than one big...

John

01-19-2010 05:29 AM
Edwin vMierlo [MVP]

Many computer problems are caused by viruses and malware on your computer. The best and easiest way to correct this is to use a recognized antivirus...

antivirus gratis

01-15-2010 06:46 PM
antivirus gratis

I have a SQL 2005 cluster, 2 node, running on 2003 Server, all patches/ sp's up to date. It was working fine until yesterday. We installed Reporting...

John

01-13-2010 08:42 PM
Geoff N. Hiten

Hi All, My company is looking to build a scalable, high availability SQL Server 2008 instance. I've been searching online to find definitive...

jimjawn

01-13-2010 02:14 PM
Tom Moreau

Trying to install SQL2K8 Failover Cluster on 2 Node Server 2K8R2 Cluster fails in section "Instance Configuration" with the following...

Andreas Scharin

01-13-2010 09:06 AM
Geoff N. Hiten

How do we add a new Named Instance under Services and Applications for the existing SQL 2008 Cluster? We have the default MSSQLServer installed...

John Myren

01-06-2010 10:54 AM
Geoff N. Hiten

I need to know the active node in case of clustered SQL 2000 from any of the participating nodes for a particular SQL Server instance. A shared...

v_2ankp

01-06-2010 10:51 AM
Geoff N. Hiten

Does anyone know how to prevent a cluster group from starting. I have a situation whereby I have several standby groups that have resources that...

Mark Broadbent

01-06-2010 10:18 AM
John Toner [MVP]

I have an application that would like to know which is the current active node name in SQL 2000. If I use 'cluster clusterName res resourceName ' to...

Joe K.

12-24-2009 01:12 AM
v_2ankp

I have an application that connects to SQL Server clustered instance and works based on the fact whether it is installed on active SQL node or...

v_2ankp

12-24-2009 12:57 AM
v_2ankp

Dear All, While adding second Node into Named instance in SQL 2008 x86 Ent. Clustering we are getting error "FailOver Instance "ABCD" cluster group...

Dinesh Bhandare

12-22-2009 08:44 AM
Geoff N. Hiten