| Groups | Blog | Home |
sql server clustering : Setting up MSDTC Resource on Clustered Server
I have done the steps in Q301600 and KB 817064. However the MSDTC Resource will start on one of the cluster nodes but not on the other. (2 node cluster). I have checked that both nodes have access to the disk that is used for the MSDTC files etc... I get the following error message: Event Type: Error Event Source: MSDTC Event Category: Cluster Event ID: 4385 Date: 25/08/2005 Time: 14:06:33 User: N/A Computer: SAN-EIGHT Description: MS DTC cannot start on this cluster node because the MS DTC resource is currently owned by another node in the cluster. Error Specifics: d:\nt\com\complus\dtc\shared\mtxclu\mtxclusetuphelper.cpp:583, CmdLine: C:\WINDOWS\system32\msdtc.exe, Pid: 3472 Please can someone help ?? -- Ben. England. -- Ben.
Do not use the services applet to control clustered resources. Use the
cluster management tool (or the CLUSTER.EXE command-line tool) to manage clustered resources. Try and use the cluster tool to move the MSDTC resource group to the other node. -- Geoff N. Hiten Senior Database Administrator Microsoft SQL Server MVP [quoted text, click to view] "Benjamin" <Benjamin@discussions.microsoft.com> wrote in message news:8319F9B5-AE87-4F8D-856C-4A3124F2F898@microsoft.com... >I am trying to setup a MSDTC on Windows 2003 Cluster. > I have done the steps in Q301600 and KB 817064. > > However the MSDTC Resource will start on one of the cluster nodes but not > on > the other. (2 node cluster). I have checked that both nodes have access to > the disk that is used for the MSDTC files etc... > > I get the following error message: > > Event Type: Error > Event Source: MSDTC > Event Category: Cluster > Event ID: 4385 > Date: 25/08/2005 > Time: 14:06:33 > User: N/A > Computer: SAN-EIGHT > Description: > MS DTC cannot start on this cluster node because the MS DTC resource is > currently owned by another node in the cluster. Error Specifics: > d:\nt\com\complus\dtc\shared\mtxclu\mtxclusetuphelper.cpp:583, CmdLine: > C:\WINDOWS\system32\msdtc.exe, Pid: 3472 > > > Please can someone help ?? > > -- > Ben. > England. > -- > Ben. > England.
Yes I am using the Cluster Administrator to control this. WHen I fail the
resource over to the other node it simly fails back to the original node ----- help ? -- Ben. England. [quoted text, click to view] "Geoff N. Hiten" wrote:
> Do not use the services applet to control clustered resources. Use the > cluster management tool (or the CLUSTER.EXE command-line tool) to manage > clustered resources. Try and use the cluster tool to move the MSDTC > resource group to the other node. > > -- > Geoff N. Hiten > Senior Database Administrator > Microsoft SQL Server MVP > > "Benjamin" <Benjamin@discussions.microsoft.com> wrote in message > news:8319F9B5-AE87-4F8D-856C-4A3124F2F898@microsoft.com... > >I am trying to setup a MSDTC on Windows 2003 Cluster. > > I have done the steps in Q301600 and KB 817064. > > > > However the MSDTC Resource will start on one of the cluster nodes but not > > on > > the other. (2 node cluster). I have checked that both nodes have access to > > the disk that is used for the MSDTC files etc... > > > > I get the following error message: > > > > Event Type: Error > > Event Source: MSDTC > > Event Category: Cluster > > Event ID: 4385 > > Date: 25/08/2005 > > Time: 14:06:33 > > User: N/A > > Computer: SAN-EIGHT > > Description: > > MS DTC cannot start on this cluster node because the MS DTC resource is > > currently owned by another node in the cluster. Error Specifics: > > d:\nt\com\complus\dtc\shared\mtxclu\mtxclusetuphelper.cpp:583, CmdLine: > > C:\WINDOWS\system32\msdtc.exe, Pid: 3472 > > > > > > Please can someone help ?? > > > > -- > > Ben. > > England. > > -- > > Ben. > > England. > >
The Application event log should have an indication as to why the service
failed to start. Look on BOTH nodes. The SQL Server logs may also have information. -- Geoff N. Hiten Senior Database Administrator Microsoft SQL Server MVP [quoted text, click to view] "Benjamin" <Benjamin@discussions.microsoft.com> wrote in message news:29AA77CB-7800-4EA5-BCB5-B81D20BBCF89@microsoft.com... > Yes I am using the Cluster Administrator to control this. WHen I fail the > resource over to the other node it simly fails back to the original node > ----- help ? > -- > Ben. > England. > > > "Geoff N. Hiten" wrote: > >> Do not use the services applet to control clustered resources. Use the >> cluster management tool (or the CLUSTER.EXE command-line tool) to manage >> clustered resources. Try and use the cluster tool to move the MSDTC >> resource group to the other node. >> >> -- >> Geoff N. Hiten >> Senior Database Administrator >> Microsoft SQL Server MVP >> >> "Benjamin" <Benjamin@discussions.microsoft.com> wrote in message >> news:8319F9B5-AE87-4F8D-856C-4A3124F2F898@microsoft.com... >> >I am trying to setup a MSDTC on Windows 2003 Cluster. >> > I have done the steps in Q301600 and KB 817064. >> > >> > However the MSDTC Resource will start on one of the cluster nodes but >> > not >> > on >> > the other. (2 node cluster). I have checked that both nodes have access >> > to >> > the disk that is used for the MSDTC files etc... >> > >> > I get the following error message: >> > >> > Event Type: Error >> > Event Source: MSDTC >> > Event Category: Cluster >> > Event ID: 4385 >> > Date: 25/08/2005 >> > Time: 14:06:33 >> > User: N/A >> > Computer: SAN-EIGHT >> > Description: >> > MS DTC cannot start on this cluster node because the MS DTC resource is >> > currently owned by another node in the cluster. Error Specifics: >> > d:\nt\com\complus\dtc\shared\mtxclu\mtxclusetuphelper.cpp:583, CmdLine: >> > C:\WINDOWS\system32\msdtc.exe, Pid: 3472 >> > >> > >> > Please can someone help ?? >> > >> > -- >> > Ben. >> > England. >> > -- >> > Ben. >> > England. >> >> >>
I had the sam exact symptoms on my (2 node cluster). I am also using Vertias
Storage Foundation Works 4.1 RP1 for disk and path management. When creating the MSDTC resource on the node that orignally owned all the resources the MSDTC came online. But when I tried to fail-over the MSDTC resource to the secondary node, the MSDTC resource timed out and failed back over to the primary node. After noticing that Cluster Admin had showed the Q: Quorum resource online, but the logical Q: drive wasn't showing up in My Computer, I realized I had a problem. Solution: I launched Veritas Enterpise Administrator (VEA) in your case this would be MS Disk Manager and selected Q: as the disk letter. Once I did this, logical Q: drive (Which is the Quorum drive) was populated in My Computer. I accessed the Q: drive letter and noticed that the MSCS directory wasn't present. I have to launch cluster admin, right click the cluster name, select properties, click on the "Quorum" tab, and select any drive other then Q:, then reselect Q:, select Apply and OK. Then Walla! the MSCS directory for the Quorum database appeared on the Q: Drive. At this point I recreated the MSDTC resource on my primary cluster, brought online and noticed that the MSDTC directory was created on the Quorum drive. Test fail-over and it worked!!!! Hope this helps someone. [quoted text, click to view] "Benjamin" wrote:
> I am trying to setup a MSDTC on Windows 2003 Cluster. > I have done the steps in Q301600 and KB 817064. > > However the MSDTC Resource will start on one of the cluster nodes but not on > the other. (2 node cluster). I have checked that both nodes have access to > the disk that is used for the MSDTC files etc... > > I get the following error message: > > Event Type: Error > Event Source: MSDTC > Event Category: Cluster > Event ID: 4385 > Date: 25/08/2005 > Time: 14:06:33 > User: N/A > Computer: SAN-EIGHT > Description: > MS DTC cannot start on this cluster node because the MS DTC resource is > currently owned by another node in the cluster. Error Specifics: > d:\nt\com\complus\dtc\shared\mtxclu\mtxclusetuphelper.cpp:583, CmdLine: > C:\WINDOWS\system32\msdtc.exe, Pid: 3472 > > > Please can someone help ?? > > -- > Ben. > England. > -- > Ben.
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |