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)

Balmukund — Wed, 23 Dec 2009 15:25:34 GMT

Hi Kishore,

Are you able to ping the DC from Node2? If not, try disabling firewall and check.

Regards,

Balmukund

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

kishore76 — Tue, 22 Dec 2009 20:14:31 GMT

Yes I checked that one..Looks like Node2 is unable to see DC's GPO.I tried to just type this command in Node2 --> RUN ..i get the same error.But gpt.inifile is located in DC.Any idea how to resolve this issue..In my case i used DC's administrator account to login to both Node1 & Node2..Pl's let me know if you have any idea..

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

Balmukund — Tue, 22 Dec 2009 18:33:58 GMT

Looks like machine is not able to access domain controller when it was trying to start cluster service

Below error says - network path not found.

\\KKE.local\sysvol\KKE.local\Policies\{31B2F340-016D-11D2-945F-00C04FB984F9}\gpt.ini>. (The network path was not found. ).

Hope this helps!

Balmukund

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

kishore — Tue, 22 Dec 2009 17:24:18 GMT

Thanks Balmukund..Your Failback really answers my questions..regarding Cluster service.Here is what i did with Cluster Installation process..I followed the steps and installed new cluster service on Node1(192.168.1.118) first and added Node2 to the existing cluster.When i turned off Node1 this what it's happening when i simulated the same..

1.) As you mentioned now i can see red sign on Node1 & i can browse Node2 info..

2.) I see all the resources & shared drives are available on Node2 with status "Online", but i see "Cluster IP Address" -- Failed

"Cluster Name" -- Offline status and i see cluster service is started in Node2 -Automatically.In Node i see the following Error Messages in Event Log/Also i have some screen shots i can share with you.If you don't mind can you send me an email to kishore76athotmail.com:

-----Error Messages Node2---------

Event Type: Error

Event Source: Userenv

Event Category: None

Event ID: 1058

Date: 12/22/2009

Time: 8:47:12 AM

User: KKE\Administrator

Computer: MYNODE2

Description:

Windows cannot access the file gpt.ini for GPO CN={31B2F340-016D-11D2-945F-00C04FB984F9},CN=Policies,CN=System,DC=KKE,DC=local. The file must be present at the location <\\KKE.local\sysvol\KKE.local\Policies\{31B2F340-016D-11D2-945F-00C04FB984F9}\gpt.ini>. (The network path was not found. ). Group Policy processing aborted.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

---------------------

Event Type: Error

Event Source: Userenv

Event Category: None

Event ID: 1030

Date: 12/22/2009

Time: 8:47:12 AM

User: KKE\Administrator

Computer: MYNODE2

Description:

Windows cannot query for the list of Group Policy objects. Check the event log for possible messages previously logged by the policy engine that describes the reason for this.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

----------------------------------

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

Balmukund — Tue, 22 Dec 2009 15:42:03 GMT

Hi Kishore,

If you turn off Node1, you should be able to access cluster administrator which would show Node1 as red cross (means cluster is not able to access that node) Could you please check if cluster service is started on Node2 or not.

Coming to failover question, if you turn on Node1 back (assuming resources are one Node2) cluster would NOT attempt to bring it back to Node1 unless you have configured failback in group properties.

Reason: Moving resource back would be another downtime and you may not want to do that in business hours. Failback can be set to "immedietly" or "between x to y" time.

Hope this answers your question.

Balmukund

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

kishore — Mon, 21 Dec 2009 20:37:13 GMT

Hi Balmukund,

I was able to successfully implement everything till step: 20 of part 4.Before going to configure MSDTC i.e step 21.I was testing some of the fail over scenario's between the groups and nodes will work..It looks like moving the Groups/Resources works between the nodes.But when i manually turn off Node1, Now i am unable to access cluster Administrator and i see Drives Q ,M & X are available on Node 2. Then later i bring back the Node1 and hoping for the ClusterService to be up and running and expecting the failback from Node2 to Node1..Which is not happening..What i am missing? Any body pl's help me....Here is the error from Node1 event log:

---------------

Event Type: Warning

Event Source: MSDTC Client

Event Category: Cluster

Event ID: 4148

Date: 12/21/2009

Time: 12:16:04 PM

User: N/A

Computer: MYNODE1

Description:

The MS DTC service was started before the cluster service on this

cluster node. This service will now be stopped. If MSDTC has been

configured to run on a cluster, the MS DTC resource will be brought

online by the cluster service when it starts. Error Specifics:

d:\nt\com\complus\dtc\shared\mtxclu\mtxclusetuphelper.cpp:932, Pid:

912, CmdLine: "C:\WINDOWS\cluster\resrcmon.exe" -e 1184 -m 900 -p 224

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.

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)

Balmukund — 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)

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