Hi everybody, we had a strange problem at a customer site, which raises some questions here. The system runs on a Win2003 SP1 2 node cluster with 2...

Benedikt

03-06-2008 08:51 AM
Benedikt

Hi guys, I just created a cluster with two nodes installed. Now I wonder how can I test failover for cluster, such as unplug the network cable for...

Iter

03-06-2008 07:29 AM
Tim Walsh

I'm getting ready to set up my first SQL Server 2005 Cluster so if I sound like I don't really know what I'm doing...it's because I don't. I'm...

davisutt

03-05-2008 04:58 PM
Geoff N. Hiten

Hi, We have just setup two servers (SQL2K) in Active/Passive clustered environment on Windows Server 2003. Now I need to restore my database from the...

Leila

03-03-2008 08:47 AM
Tom Moreau

Hello, After having quite some research, I found out that Active/Active servers are not recommended by most of people as clustering is mainly is a...

Christos

02-29-2008 12:39 PM
Tom Moreau

I have a n+1 cluster running Windows 2003 sp2 64-bit and Sql 2005 64bit. When I use perfmon all the counters for the instances that are not running...

Randy

02-29-2008 09:30 AM
Geoff N. Hiten

I have a SQL 2005 cluster as the backend of my OCS 2007 environment. It is a shared server. I recently found information that the OCS DB should be on...

Tom_Slycke

02-27-2008 03:10 PM
Tom_Slycke

I have 2 nodes Windows Server 2003 R2 Enterprise x64 Edition with Service Pack 2. I need to install SQL2005 Standard Edition with multiples...

GDP

02-27-2008 02:10 PM
GDP

so although I have read a few things in both directions, it seems I need the MSDTC for a SQL cluster. When I create it I have to assign dependencies...

Justin Rich

02-26-2008 10:23 AM
Justin Rich

Did I need to apply SOL1 2005 SP1 on all notes or just Note1?

Ian

02-25-2008 02:52 PM
Tom Moreau

Dear All, On a failover cluster, how does does windows redirect the traffic to correct physical machine when the clients connect to the...

Balaji

02-25-2008 04:50 AM
Edwin vMierlo [MVP]

I am running sql 2005 sp2 64 bit on a windows server 2003 64 bit cluster. This has been working in an active/active configuration. I had a...

mungoblack

02-22-2008 03:23 PM
RedSevina

Before installing SQL2005 EE, does IIS need to be installed on all nodes, or just on the first node? Thanks.

Ian

02-22-2008 09:11 AM
Geoff N. Hiten

I've got a 2-node SQL Server 2005 running. There is no sql service packs installed and Windows 2003 service packs. the sql-cluster was built while...

Sean

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

SQL 2k5 on Win 2k3, all fully patched. CLustering is enabled and working, but when I attempt to log on to the CSA app, I cannot change to the...

Bill P

02-15-2008 02:22 PM
Linchi Shea

We have mix of both SQL 2000 and 2005 enviroments. The push is to consolidate. On 4 node windows 2003 64 bit cluster: Is it possible to host on 2...

MK

02-15-2008 02:15 PM
Linchi Shea

Greetings, I have a SQL2005 32-bit Std A/P cluster that will not use AWE memory beyond 3GB. The server is running on Server 2003 r2 Enterprise...

Bonzer

02-15-2008 10:42 AM
Bonzer

so i've built up my w2k3 ent 64bit cluster with no problems... its all happy and working well... created the DTC resource and went to install SQL.....

Justin Rich

02-15-2008 09:59 AM
Justin Rich

Hi, Maybe a really easy question this one, but is there an easy way to find out which domain groups the services have been setup under in...

ianwr

02-14-2008 02:49 PM
ManishK

Hello, Today, during work, suddenly my sql server was stopped, cluster started failover. Did not switch node but started sql on the same active...

Bartolo

02-14-2008 10:53 AM
Bartolo

I am new both for cluster and SQL, and I have built a new two nodes SQL cluster. For testing failover, I am planing to write a long sql script...

jinshuang

02-14-2008 10:25 AM
Matthew White

Hi Guys, I don't know it is right place that I can post this topic about how to install MS virtual server 2005. But it is related to cluster. I want...

Iter

02-13-2008 12:20 PM
Tim Walsh

How do you migrate a cluster from active\passive to active\active in sql server 2000 running Windows Server 2003 R2? Thank you. -- Mike

Mike

02-13-2008 11:22 AM
Russ Kaufmann [MVP]

Hello I must migrate from a single server standalone installation to a sql2005 cluster istance with one node cluster.I must perforn this upgrade...

Pazzoide

02-13-2008 07:53 AM
Pazzoide

Hi Guys, Can any one plese help me out to setup SMTP mail setup for SQL server 2000. Its damn urgent. If possible plz send me some links related...

Atulx86

02-12-2008 11:34 PM
Linchi Shea

Ok, I've tried everything I can think of. The logs are of little help. I've walked through the KB article, setting up the Named Pipes connection...

Mark

02-08-2008 10:18 AM
Geoff N. Hiten

I am currently working to get a test cluster online using Windows 2008 Datacenter x64 with SQL2005 Enterprise x64. Although the 2008 cluster is up...

Joshua Jackson

02-07-2008 06:14 PM
Ross Mistry

We are going for SQL 2K Upgrade to SQL 2k5 Upgrade for Active-Passive Clusters (windows 2K3)and thinking for below plan , can anybody confirm if...

sacgar

02-07-2008 04:15 PM
Geoff N. Hiten

Hi, I'd like to know how I can setup a Windows cluster with one node for SQL Server and one node for Analysis Services ? Please advise ? many...

9_points

02-06-2008 06:28 PM
Ross Mistry

Hello, I'm installing 2 node failover SQL 2005 cluster. For some reason I'm getting the following error after I provided domain groups for cluster...

Sigitas Skublickas

02-06-2008 01:36 PM
Sigitas Skublickas

We recently upgraded our failover cluster to 2005. Currently when someone connects with SSMS and opens object explorer, the error Event filter with...

Offeral

02-06-2008 09:41 AM
Geoff N. Hiten

A SQL 2000 db on W2K3 cluster with 2 nodes lost it's public connection over the weekend. Both VIPs were unpingable. I was able to rdc directly to...

Hurme

02-05-2008 03:24 PM
Geoff N. Hiten

Hey guys, I have a client who would like to install a one node SQL 2005 cluster now and add a node later when financially feasible. I haven't tried...

gj111

02-04-2008 03:24 PM
Geoff N. Hiten

Hi Everyone, Short Problem. Here is my config: - SQL Cluster Active/Passive - MSSQL 2005 SP2 - On the nodes: SQL engine, Worstation components -...

Julien

02-04-2008 12:31 PM
Julien

We have a cluster running SQL Server 2005 with one instance. We want to install another instance, will it require another IP address or can we...

SQLGuru_not

02-01-2008 02:02 PM
SQLGuru_not

I have to bring up a second set of clustered SQL servers at a DR Hotsite. To avoid having to change any ODBC connections or application...

md

02-01-2008 01:35 PM
Tom Moreau

Hello, I have a Wndows 2003 Sql 2005 Cluster consisting of two servers, on Failover from node2 to node1 the application user is unable to login...

Bob Smith

01-28-2008 03:59 PM
Francisco Parrilla

I have 2-note cluster SQL 2005 sp1 on Windows Server 2003 R2. What is the better the sequence of Shutdown or reboot them when needed? Thanks

Ian

01-27-2008 12:37 PM
Tom Moreau

Hi Guys, I want to learn cluster and want to make a practice of it. Now I only have one computer, is that ok to make a test? i will install windows...

Iter

01-27-2008 10:26 AM
Don Wilwol

Hi Guys, I have a active/passive cluster and there are 3 drives setup that is in SAN(X, Y, and Z). In cluster administrator, I can see all of them....

Iter

01-25-2008 02:37 PM
Geoff N. Hiten

Hi. Was hoping to get some advice on applying a hotfix to a SQL Server 2005 failover Cluster. The hotfix I am applying (KB933508) relates to a...

YaHozna

01-25-2008 09:51 AM
YaHozna

I have a question regarding configuration of active/active and active/passive, is there any difference between them when install sql server software...

Iter

01-24-2008 11:12 AM
Geoff N. Hiten

Dear All, Microsoft recommends the following resolution to fix the TCP/IP binding failures. http://support.microsoft.com/kb/307197/en-us The...

Balaji

01-24-2008 05:32 AM
Balaji

I have two 64-bit AMD64 based machines. I installed MSCS on these which is working perfectly. Now, the questions I have: 1. Which DVD I need to...

w2k3e_install

01-23-2008 01:42 PM
w2k3e_install

Hi, I am learning sql server failed over cluster and I got confused that what is difference between active/passive and active/active when you install...

Iter

01-23-2008 12:29 PM
Tom Moreau

I've researched a lot about the namespace error that some people get when connecting to a cluster with Object Explorer from SSMS, however, no answer...

Offeral

01-23-2008 11:34 AM
Edwin vMierlo [MVP]

Hello! We will be moving our two cluster running SQL Server 2005 64-bit SP2 on Windows 2003 to the different datacenter. IP addressed of both nodes...

Igor Marchenko

01-21-2008 10:52 AM
Geoff N. Hiten

Hello! I've set up an HA environment for a customer. That includes two IIS-servers, with Network Load Balancing between them, and two SQL 2005...

Bengt-Erik Eliasson

01-18-2008 02:14 PM
Ayad Shammout

I have a 2 node Windows 2003 SQL 2005 Cluster, node 2 was failing so I evicted it and attempted to rejoin it, when I evicted it the cluster failed, I...

Bob Smith

01-18-2008 10:01 AM
Geoff N. Hiten

Dear ALL, I have a two-node win2003 cluster where I'm going to install SQL server 2005. Please, anyone of you could give me a link where I can find...

Alberto Brivio

01-16-2008 12:21 AM
Uri Dimant