MSDTC: Receive Returning Out Of Resources Error

HI,

I am getting an error on my sqlserver database server. My clients are
getting kicked out of transaction, giving an error
"New transaction cannot enlist in the specified transaction coordinator"

When i saw the event log on the DB server i found the following message

************************************
Event Type: Information

Event Source: MSDTC

Event Category: CM

Event ID: 4156

Date: 6/13/2005

Time: 9:30:48 AM

User: N/A

Computer: XXXXXXX

Description:

String message: ProcID= 0x780 QMGR::Receive Returning Out Of Resources
Error.

************************************************** ***************

I am using SQLServer 2000 Advanced server, on Windows 2000 Advanced server.

Thanks for help.

Indushekar.indushekara (indushekara@.gmail.com) writes:
> I am getting an error on my sqlserver database server. My clients are
> getting kicked out of transaction, giving an error
> "New transaction cannot enlist in the specified transaction coordinator"
> When i saw the event log on the DB server i found the following message
> ************************************
> Event Type: Information
> Event Source: MSDTC
> Event Category: CM
> Event ID: 4156
> Date: 6/13/2005
> Time: 9:30:48 AM
> User: N/A
> Computer: XXXXXXX
> Description:
> String message: ProcID= 0x780 QMGR::Receive Returning Out Of Resources
> Error.
> ************************************************** ***************

I have no idea what that means, but I would try stopping and restarting
MSDTC and hope for an easy way out.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||indushekara (indushekara@.gmail.com) writes:
> I am getting an error on my sqlserver database server. My clients are
> getting kicked out of transaction, giving an error
> "New transaction cannot enlist in the specified transaction coordinator"
> When i saw the event log on the DB server i found the following message
> ************************************
> Event Type: Information
> Event Source: MSDTC
> Event Category: CM
> Event ID: 4156
> Date: 6/13/2005
> Time: 9:30:48 AM
> User: N/A
> Computer: XXXXXXX
> Description:
> String message: ProcID= 0x780 QMGR::Receive Returning Out Of Resources
> Error.
> ************************************************** ***************

I have no idea what that means, but I would try stopping and restarting
MSDTC and hope for an easy way out.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||I don't know myself, but if you haven't installed Windows SP3, then
this KB article might be relevant:

http://support.microsoft.com/defaul...kb;en-us;312947

If all else fails, you could reinstall MSDTC, but that seems rather
drastic, so it might be worth opening a case with Microsoft first.

http://support.microsoft.com/kb/279786/EN-US/

Simon|||I don't know myself, but if you haven't installed Windows SP3, then
this KB article might be relevant:

http://support.microsoft.com/defaul...kb;en-us;312947

If all else fails, you could reinstall MSDTC, but that seems rather
drastic, so it might be worth opening a case with Microsoft first.

http://support.microsoft.com/kb/279786/EN-US/

Simon

MSDTC - The Microsoft Clustering Service failed restore a registry

Cluster active-active.
The node B was reinstalled after a hardware failure.
Now the node B is ok. The failover is ok, except because I receive the
message"The Microsoft Clustering Service failed restore a registry key for
resource SQL Server " when I move the Instance B from Node A to Node B.
How can I install MSDTC without affect the Node A (without unistall msdtc
from this node) ?
Node A - Instance A (msdtc resource is online)
thanks for your help.
You don't install DTC, it is already on the machine. It is part of the OS.
You just configure the resource into the cluster. All you should have to do
is edit the properties of the DTC resource and add NodeB as a possible
owner.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Shima" <Shima@.discussions.microsoft.com> wrote in message
news:F5B0FAB8-C20C-4009-96A9-98AB79D5D965@.microsoft.com...
> Cluster active-active.
> The node B was reinstalled after a hardware failure.
> Now the node B is ok. The failover is ok, except because I receive the
> message"The Microsoft Clustering Service failed restore a registry key for
> resource SQL Server " when I move the Instance B from Node A to Node B.
> How can I install MSDTC without affect the Node A (without unistall msdtc
> from this node) ?
> Node A - Instance A (msdtc resource is online)
> thanks for your help.