Error on MSDTC after a SQL Server fail-over

Hello
I have a SQL Server 2000 64 bits running on an two node cluster (NODE1 and
NODE2) with two SQL Server instances (SQL1 and SQL1\2).
Instance SQL1 is running on NODE1 and instance SQL1\2 is running on NODE2.
MSDTC is configured on a exclusive group and it is running on NODE1.
The Cluster Group also is running on NODE1.
I use a lot of distributed transactions between SQL1\2 and SQL1 and it works
just fine.
I had a problem last night with NODE1, and all the resources (Cluster, SQL1
and MSDTC) failed to NODE2.
After the failover I started getting the error below when trying to execute
a distributed transaction from SQL1\2 to SQL1.
Error: 8510, Severity: 20, State: 2
Enlist of MSDTC transaction failed: XACT_E_CONNECTION_DOWN.
The error happened during the failover and also after the finish of the
failver.
On SQL1 error log I notice that there was no error messages when it
initialize the MSDTC. Below is the message from the ErrorLog.
"Attempting to initialize Distributed Transaction Coordinator."
To solve the Error I brought up NODE1 back on-line (it failed because of a
network problem). I move the MSDTC back to NODE1, move SQL1 back to NODE1 and
also re-started SQL1\2 on NODE2 (brought offline, bring on-line). After that
procedure I was able to use distributed transactions between SQL1 and SQL1\2.
I would like to know why that problem happened?
I suposed that MSDTC was able to work on cluster and that the MSDTC should
work after a failover.
I would like your help to understand the problem. If you need more
information just let me know.
Regards.
Carlos Eduardo Selonke de Souza
http://carlos.geekbunker.org
Hi Carlos
MSDTC has to be running when SQL is starting. So it's a timing problem. To
be certain, check the log in SQL, and look for messages about finding the
Transaction "Server". It probably states that is was down. SQL will not retry
it afterwards.
If the MSDTC resource was in the same group as the SQL Virtual Server, you
could make SQL dependant of MSDTC, but unfortunately this is not the case.
Chau chau,
Pascalos
"Carlos Selonke" wrote:

> Hello
> I have a SQL Server 2000 64 bits running on an two node cluster (NODE1 and
> NODE2) with two SQL Server instances (SQL1 and SQL1\2).
> Instance SQL1 is running on NODE1 and instance SQL1\2 is running on NODE2.
> MSDTC is configured on a exclusive group and it is running on NODE1.
> The Cluster Group also is running on NODE1.
> I use a lot of distributed transactions between SQL1\2 and SQL1 and it works
> just fine.
> I had a problem last night with NODE1, and all the resources (Cluster, SQL1
> and MSDTC) failed to NODE2.
> After the failover I started getting the error below when trying to execute
> a distributed transaction from SQL1\2 to SQL1.
> Error: 8510, Severity: 20, State: 2
> Enlist of MSDTC transaction failed: XACT_E_CONNECTION_DOWN.
> The error happened during the failover and also after the finish of the
> failver.
> On SQL1 error log I notice that there was no error messages when it
> initialize the MSDTC. Below is the message from the ErrorLog.
> "Attempting to initialize Distributed Transaction Coordinator."
> To solve the Error I brought up NODE1 back on-line (it failed because of a
> network problem). I move the MSDTC back to NODE1, move SQL1 back to NODE1 and
> also re-started SQL1\2 on NODE2 (brought offline, bring on-line). After that
> procedure I was able to use distributed transactions between SQL1 and SQL1\2.
> I would like to know why that problem happened?
> I suposed that MSDTC was able to work on cluster and that the MSDTC should
> work after a failover.
> I would like your help to understand the problem. If you need more
> information just let me know.
> Regards.
> --
> Carlos Eduardo Selonke de Souza
> http://carlos.geekbunker.org

Error Message 22029 on SQL Server 2005

Hello
I have a problem with the SQL Server 2005
This is the Version i am using:
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
On the Server in the SQL Management Studio in a Query Window i execute the
command:
exec master..xp_sqlmaint '-D
kunde -WriteHistory -CkDB -CkAl -CkCat -RebldIdx 10'
this is the output i get.
output
NULL
Microsoft (R) SQLMaint Utility (Unicode), Version 9.00.1399.06
Copyright (c) Microsoft Corporation.
NULL
NULL
Msg 22029, Level 16, State 1, Line 0
sqlmaint.exe failed.
The Registry Key HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL
Server\<Instance Name>\SETUP\SQLPATH is ok. There is the correct path for
the SQL Server Binary
There is no Path with "-S" involved in the operations.
Any suggestion is very appreciated.
Regards
Paolo Taverna
I'd add a report file:
exec master..xp_sqlmaint '-D pubs -WriteHistory -Rpt "C:\a.txt" -CkDB -CkAl -CkCat -RebldIdx 10'
(Change database name)
You can now check this report file for error messages. Note that xp_sqlmaint is deprecated in
2005...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paolo Taverna" <nospam@.nospam.spm> wrote in message news:%23OgxjZ9MGHA.2884@.TK2MSFTNGP12.phx.gbl...
> Hello
> I have a problem with the SQL Server 2005
> This is the Version i am using:
> Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37
> Copyright (c) 1988-2005 Microsoft Corporation
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
> On the Server in the SQL Management Studio in a Query Window i execute the command:
> exec master..xp_sqlmaint '-D kunde -WriteHistory -CkDB -CkAl -CkCat -RebldIdx 10'
> this is the output i get.
> output
> ----
> NULL
> Microsoft (R) SQLMaint Utility (Unicode), Version 9.00.1399.06
> Copyright (c) Microsoft Corporation.
> NULL
> NULL
> Msg 22029, Level 16, State 1, Line 0
> sqlmaint.exe failed.
>
> The Registry Key HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\<Instance
> Name>\SETUP\SQLPATH is ok. There is the correct path for the SQL Server Binary
> There is no Path with "-S" involved in the operations.
> Any suggestion is very appreciated.
> Regards
> Paolo Taverna
>
|||Hi Tibor
I executed xp_sqlmaint with the Parameter -Rpt like your sample. But the
Report File will not be generated. The remains the same Error.
Regards
Paolo Taverna
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schrieb
im Newsbeitrag news:uZdSmi9MGHA.2124@.TK2MSFTNGP14.phx.gbl...
> I'd add a report file:
> exec master..xp_sqlmaint '-D pubs -WriteHistory -Rpt
> "C:\a.txt" -CkDB -CkAl -CkCat -RebldIdx 10'
> (Change database name)
> You can now check this report file for error messages. Note that
> xp_sqlmaint is deprecated in 2005...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Paolo Taverna" <nospam@.nospam.spm> wrote in message
> news:%23OgxjZ9MGHA.2884@.TK2MSFTNGP12.phx.gbl...
>
|||Hello
Don't mind about this thread. I replaced SQLMaint with a SSIS Package for
the Database Consistency and Index Rebuild. This works fine
Regards
Paolo Taverna
"Paolo Taverna" <nospam@.nospam.spm> schrieb im Newsbeitrag
news:%23OgxjZ9MGHA.2884@.TK2MSFTNGP12.phx.gbl...
> Hello
> I have a problem with the SQL Server 2005
> This is the Version i am using:
> Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37
> Copyright (c) 1988-2005 Microsoft Corporation
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
> On the Server in the SQL Management Studio in a Query Window i execute the
> command:
> exec master..xp_sqlmaint '-D
> kunde -WriteHistory -CkDB -CkAl -CkCat -RebldIdx 10'
> this is the output i get.
> output
> ----
> NULL
> Microsoft (R) SQLMaint Utility (Unicode), Version 9.00.1399.06
> Copyright (c) Microsoft Corporation.
> NULL
> NULL
> Msg 22029, Level 16, State 1, Line 0
> sqlmaint.exe failed.
>
> The Registry Key HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL
> Server\<Instance Name>\SETUP\SQLPATH is ok. There is the correct path for
> the SQL Server Binary
> There is no Path with "-S" involved in the operations.
> Any suggestion is very appreciated.
> Regards
> Paolo Taverna
>

Error Message 22029 on SQL Server 2005

Hello
I have a problem with the SQL Server 2005
This is the Version i am using:
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
On the Server in the SQL Management Studio in a Query Window i execute the
command:
exec master..xp_sqlmaint '-D
kunde -WriteHistory -CkDB -CkAl -CkCat -RebldIdx 10'
this is the output i get.
output
----
NULL
Microsoft (R) SQLMaint Utility (Unicode), Version 9.00.1399.06
Copyright (c) Microsoft Corporation.
NULL
NULL
Msg 22029, Level 16, State 1, Line 0
sqlmaint.exe failed.
The Registry Key HKEY_LOCAL_MACHINE\Software\Microsoft\Mi
crosoft SQL
Server\<Instance Name>\SETUP\SQLPATH is ok. There is the correct path for
the SQL Server Binary
There is no Path with "-S" involved in the operations.
Any suggestion is very appreciated.
Regards
Paolo TavernaI'd add a report file:
exec master..xp_sqlmaint '-D pubs -WriteHistory -Rpt "C:\a.txt" -CkDB -CkAl
-CkCat -RebldIdx 10'
(Change database name)
You can now check this report file for error messages. Note that xp_sqlmaint
is deprecated in
2005...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paolo Taverna" <nospam@.nospam.spm> wrote in message news:%23OgxjZ9MGHA.2884@.TK2MSFTNGP12.ph
x.gbl...
> Hello
> I have a problem with the SQL Server 2005
> This is the Version i am using:
> Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37
> Copyright (c) 1988-2005 Microsoft Corporation
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
> On the Server in the SQL Management Studio in a Query Window i execute the
command:
> exec master..xp_sqlmaint '-D kunde -WriteHistory -CkDB -CkAl -CkCat -Rebld
Idx 10'
> this is the output i get.
> output
> ----
> NULL
> Microsoft (R) SQLMaint Utility (Unicode), Version 9.00.1399.06
> Copyright (c) Microsoft Corporation.
> NULL
> NULL
> Msg 22029, Level 16, State 1, Line 0
> sqlmaint.exe failed.
>
> The Registry Key HKEY_LOCAL_MACHINE\Software\Microsoft\Mi
crosoft SQL Serve
r\<Instance
> Name>\SETUP\SQLPATH is ok. There is the correct path for the SQL Server Bi
nary
> There is no Path with "-S" involved in the operations.
> Any suggestion is very appreciated.
> Regards
> Paolo Taverna
>|||Hi Tibor
I executed xp_sqlmaint with the Parameter -Rpt like your sample. But the
Report File will not be generated. The remains the same Error.
Regards
Paolo Taverna
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schrieb
im Newsbeitrag news:uZdSmi9MGHA.2124@.TK2MSFTNGP14.phx.gbl...
> I'd add a report file:
> exec master..xp_sqlmaint '-D pubs -WriteHistory -Rpt
> "C:\a.txt" -CkDB -CkAl -CkCat -RebldIdx 10'
> (Change database name)
> You can now check this report file for error messages. Note that
> xp_sqlmaint is deprecated in 2005...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Paolo Taverna" <nospam@.nospam.spm> wrote in message
> news:%23OgxjZ9MGHA.2884@.TK2MSFTNGP12.phx.gbl...
>|||Hello
Don't mind about this thread. I replaced SQLMaint with a SSIS Package for
the Database Consistency and Index Rebuild. This works fine
Regards
Paolo Taverna
"Paolo Taverna" <nospam@.nospam.spm> schrieb im Newsbeitrag
news:%23OgxjZ9MGHA.2884@.TK2MSFTNGP12.phx.gbl...
> Hello
> I have a problem with the SQL Server 2005
> This is the Version i am using:
> Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37
> Copyright (c) 1988-2005 Microsoft Corporation
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
> On the Server in the SQL Management Studio in a Query Window i execute the
> command:
> exec master..xp_sqlmaint '-D
> kunde -WriteHistory -CkDB -CkAl -CkCat -RebldIdx 10'
> this is the output i get.
> output
> ----
> NULL
> Microsoft (R) SQLMaint Utility (Unicode), Version 9.00.1399.06
> Copyright (c) Microsoft Corporation.
> NULL
> NULL
> Msg 22029, Level 16, State 1, Line 0
> sqlmaint.exe failed.
>
> The Registry Key HKEY_LOCAL_MACHINE\Software\Microsoft\Mi
crosoft SQL
> Server\<Instance Name>\SETUP\SQLPATH is ok. There is the correct path for
> the SQL Server Binary
> There is no Path with "-S" involved in the operations.
> Any suggestion is very appreciated.
> Regards
> Paolo Taverna
>