MS SQL Server DTS - Re: Error : AcquireConnection call to the connection manager <dbserver>.<db> failed wit

Author

Re: Error : AcquireConnection call to the connection manager <dbserver>.<db> failed wit

Darren Green

2005-05-27, 8:23 pm

In message <uZq5ZZYYFHA.2588@TK2MSFTNGP14.phx.gbl>, Kay Lee
<kit_mx1@hotmail.com> writes
>Thanks.
>
>How do I check that MS DTC is working correctly between source and
>destination, and
>the machine running package?
>
>I am only checking that the service is running on all thes machines.
>
>Thanks.
>

There are a couple of tools available, DTSPing is one and there is at
least one more, but I forget the name. Search the MS KB, for DTC errors,
such as "cannot enlist in the distributed transaction". A post to the
beta group may also help as hopefully one of the team can expand on the
error code. They are not currently documented. Also ensure you fully
check the output window for the complete error message, They often come
in several parts.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Sponsored Links