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

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

Sameer Dhoot — Mon, 13 Oct 2008 21:09:42 GMT

After step 11 you need to start up Node 1. I am not sure if this is coorect but worked for me. When i first did it node 1 was shut down. after creating groups and resources, i bought up node 1 and then to simulate failover i disconnect both the networks from node 2. I cluadmin on node 1 there was an error to bring M Drive online, but S drive though was online. So i again connected the newtowrk on node 2 and then restarted the cluster service on node 2. Delete the resource M Drive and then recreated when both node were online. Now i again disconnected network on node 1 and then M drive was up on node but now the S Drive failed (i used S instead of X), i again repetead the step to delelte the resource and then recreate it. After doing so i could simulate failover and all the resources were online.

Please let me know if you think the process is not correct.

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

blakhani — Thu, 16 Oct 2008 21:03:10 GMT

Sorry, but I could not understand your explaination...

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

Thanga — Fri, 26 Dec 2008 15:47:12 GMT

As u said in the first part about to download virtual hard disk, the link having the following three downloads which one is need to be downloaded.

WIN2K3R2EESP2.part1.exe

700.0 MB

Download

WIN2K3R2EESP2.part2.rar

700.0 MB

Download

WIN2K3R2EESP2.part3.rar

495.1 MB

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

blakhani — Fri, 26 Dec 2008 20:19:23 GMT

Hi Thanga,

Thanks for the comments.

You have to download all the files in same folder. Once you run part1.exe, it automatically use rest two and extract vhd. hope this answers your question. Feel free to add commments.

I have modified Part 1 to make it clear.

- Balmukund

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

Eric Twilegar — Thu, 22 Jan 2009 19:37:37 GMT

I see a lot of mention in this part and part 5 of virutal names. MSDTC requires it's own name and IP. So does SQL server.

The cluster has a name and for that to work you need a computer account in Active directory. usually the wizard creates this.

My question is what does adding a virtual name create? Do you need rights in active directory for that name to register. What if you don't have those rights? Does your admin need to create aliases? Does the cluster service account need any rights to them.

I've been searching high and dry for any information on not being an admin and virutal server names with no luck.

Thanks

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

blakhani — Tue, 27 Jan 2009 13:37:37 GMT

Hi Eric,

When you create any Virtual Network Name in Cluster, it does not create the object in AD. There is a check box "Enable Kerberos Authentication" at Right Click > Properies > Parameters. If that box is checked, it would registry Virtual Network Name in Active Directory.

By default an account can create 10 objects in AD.

Refer - http://support.microsoft.com/kb/307532/en-us

Please let me know if your question is unanswered.

- Balmukund

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

Paul — Mon, 23 Mar 2009 01:24:10 GMT

Greate article,

After step 11, I cannot open SQLCluster from Node1 or Node2. If i try to ping sqlcluster.mydomain.com the ping fails. I noticed Cluster service is started and running on both nodes. If i try to create a new cluster and provide the name of sqlcluster, I cannot proceed as sqlcluster can be seen. Any help would be appreciated.

Regards,

Paul

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

Paul — Mon, 23 Mar 2009 01:27:39 GMT

More information included...

The error message that i receive is "The Cluster Service on node 'sqlcluster' cannot be started. The network path was not found. Error ID: -2147024843 (80070035).

Thanks again,

Paul

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

blakhani — Mon, 23 Mar 2009 06:26:02 GMT

Paul,

Sorry to hear that you could not proceed smoothly. Can you please let me know where exactly you faced failure? You mentioned step 11, it would help if you can tell which part of series (Part 3)?

I would go by looking at event log to check the failure. Is your cluster service running? (your two post contradict each other) If service is not running then check event log to see the reason of failure.

Please do post back and let us know the problem. I would be happy to help.

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

Paul — Tue, 24 Mar 2009 02:33:40 GMT

It was network related issue. I am past that stage now. Thanks for the quick reply.

Regards,

Paul

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

Linda — Sat, 09 May 2009 10:18:27 GMT

Hi,

After step 21, I tried to test failover for MSDTC group. The other three resources are online but MSDTC resource is offline. How can I correct for this?

If this MSDTC group not online, will SQL 2005 installation fail?

Thanks

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

blakhani — Sun, 10 May 2009 07:33:48 GMT

Hi Linda,

I feel that MSDTC is not configured properly on both the nodes causing it to fail.

(Configure MSDTC as Resource - Step 1 to be done on both the nodes.)

Can you please have a look at eventlog on node2 and check the error?

Run below command on node2

msdtc -uninstall

msdtc -install

and try..

Hope this helps!

Balmukund

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

Tue, 15 Sep 2009 12:27:46 GMT

Hi Balmukund,

I am stuck on step 12 in part 4 series of configuring shared disks -

12. Open Cluster Administrator (Start > Run > CluAdmin)

13. Create New Group called MSDTC (File > New > Group) and provide details

I am not able to open a connection to SQLCluster. I says network path not found.

Please help.

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

Tue, 15 Sep 2009 13:24:03 GMT

Hi Balmukund,

I am past that problem. I discovered that cluster services were not turned on. After I turned on the cluster service it started working fine.

I have another problem ...

While configuring MSDTC resource -> adding a distributed transaction coordinator it says that it cannot create a duplicate resource of this type.

Please help.