How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 3)

re: How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 3)

Hemanth — Mon, 12 May 2008 11:14:31 GMT

Hi,

Would it be possible for you to, please post part-4 of this series? I have stumbled on your blog and have been referencing it for the past few days. I plan on implementing this as a sandbox for the environment, we work on.

Thanks and Regards,

Hemanth C Damecharla.

re: How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 3)

blakhani — Thu, 12 Jun 2008 12:05:24 GMT

Thanks for the comments.

I have made some modificaitons to the blog because sequence was not proper. Please standby for Part 4. I have started working on it.

re: How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 3)

blakhani — Tue, 17 Jun 2008 18:27:32 GMT

I have finished complete series, hope you would find it useful.

re: How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 3)

al_corleone — Sat, 28 Mar 2009 01:55:06 GMT

can't add 2nd node. Add Nodes Wizard complains that SQLCLUSTER:Could not contact the cluster.

re: How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 3)

blakhani — Mon, 30 Mar 2009 06:44:53 GMT

Can you check if you are able to ping the name "SQLCluster"

re: How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 3)

al_corleone — Mon, 30 Mar 2009 21:00:44 GMT

From myNode2, I can ping SQLCluster, PDC and myNode1 just fine.

re: How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 3)

blakhani — Wed, 01 Apr 2009 10:34:45 GMT

Can you please send me the screenshot and setup logs to blakhani (at) koolmail (dot) in.

re: How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 3)

blakhani — Fri, 03 Apr 2009 07:37:21 GMT

----- update ----------

From: al_corleone

Sent: Thursday, April 02, 2009 9:08 PM

To: blakhani

Subject: RE: help with SQLCluster

Hi Balmukund,

I got some help with my AD setup. Apparently, myDC could resolve myNode2 but not myNode2.mycluster.com. I had to create a new forwarded site and run a ipconfig /registerDNS to forcibly accept entries. So onwards to step 5...

Thanks for your help,

Alvin

________________________________________

From: blakhani

To: al_corleone

Subject: RE: help with SQLCluster

Date: Thu, 2 Apr 2009 11:55:26 +0530

Error code stands for .. ERROR_NO_SUCH_DOMAIN

Did you change the password recently?

http://support.microsoft.com/kb/875429

Check in the event log if you see some interesting information there....

________________________________________

From: al_corleone

To: blakhani

Subject: help with SQLCluster

Date: Wed, 1 Apr 2009 09:02:49 -0700

Hi Balmukund,

Thanks for taking the time to help investigate my issue. Enclosed is the attached screenshot.

Thanks in advance,

Alvin

re: How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 3)

siva — Wed, 12 Aug 2009 04:52:36 GMT

Hi,

i could not able to turn on node2,when node1 is running

i guess it might be the cause for shared disk. i am sending both nodes configuration, please give me solution.

Thanks

re: How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 3)

JM — Wed, 19 Aug 2009 08:25:28 GMT

Hi Balmukund,

I am not able to see the heartbeat network in MyNode1. Though I am bale to see it in MyNode2.

Please help.

Thanks

re: How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 3)

JM — Wed, 19 Aug 2009 09:06:00 GMT

Hi siva,

Even I ran into the same problem as yours - node2 was not turning on if node 1 is on.

I checked my hard disk configuration for Q-drive. In that I had Attached Quorum VHD to primary channel (0). Instead, just goto edi configuration->Hard disks and select SCSI 0 ID 0 for the attachment. The node 2 will now start.

I hope this helps.

Thanks

re: How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 3)

blakhani — Wed, 19 Aug 2009 10:24:45 GMT

Hi JM,

Thanks for helping Siva.

To troubleshoot your problem

1. Can you please check if you have added heartbeat on both the nodes?

2. Open network connections (control panel) and check if you see NIC card on that node? If yes, then it would have been disabled. There is a setting which says "show icon in notification area when connected"

Let me know your finding.

Regards,

Balmukund