Windows error 0x8004D01B, -2147168229

MSDTC fails for self-hosted NServiceBus ASP.NET endpoints but not other processes

I have a Windows 2008 R2 server that hosts many back end NServiceBus endpoints. All of the services that rely on the NServiceBus.Host.exe host (installed as Windows Services) are able to interact with MSDTC perfectly, averaging a small handful of concurrent distributed transactions throughout the day. There are 2 small [...] read more

Transaction Manager Is Not Available

i am using TransactionScope Class provided by .Net However when i try to open connection it throws below exception. {System.Runtime.InteropServices.COMException (0x8004D01B): The Transaction Manager is not available. (Exception from HRESULT: 0x8004D01B) Here is my code.. using (TransactionScope scope = new TransactionScope()) { using (OleDbConnection connection1 = new OleDbConnection("Provider=MSDAORA.1;User ID=oratest2;Password=oratest2;Data Source=dr;Persist [...] read more

NServiceBus unable to receive message

I'm following the NServiceBus getting started guide (version 5) and I get the below error. When the client sends a command to the server, the server has issues to receive the message. The code is okay, because the exact same code on another machine is working. So something is missing [...] read more

Why does my TransactionScope not work?

I have code that looks like this: using (TransactionScope tsTransScope = new TransactionScope()) { bcAdvertiser.SaveToTraffic(); bcAdvertiser.SaveToDb(); tsTransScope.Complete(); } The moment I do anything with the database, like open a connection, I get this error: {System.Runtime.InteropServices.COMException (0x8004D01B): The Transaction Manager is not available. (Exception from HRESULT: 0x8004D01B) at System.Transactions.Oletx.IDtcProxyShimFactory.ConnectToProxy(String nodeName, Guid [...] read more

Has anyone installed NServiceBus onto a Microsoft clustered server?

Update: Ok, after getting past the fact that I did not have MSDTC set up as a cluster resource (doh!), I was able to run my program and all appeared well, but I was not able to successfully send messages to it. After digging I found that while the private [...] read more

Oracle Transaction under MS SSIS

I'm trying to get transactions working under SSIS (SQL Server Integration Services 2005) and Oracle with no luck. I'm using Oracle 10g. I have created a Sequence Container, set its TransactionOption to "Required" and put inside it a DataFlow Task with TransactionOption = "Supported". The server running SSIS has the [...] read more

ERROR NServiceBus.Transports.Msmq.MsmqDequeueStrategy - Error in receiving messages

Event Viewer on my workstation have the following error log: > ERROR NServiceBus.Transports.Msmq.MsmqDequeueStrategy [(null)] - Error in > receiving messages. System.Transactions.TransactionAbortedException: The > transaction has aborted. ---> > System.Transactions.TransactionManagerCommunicationException: Communication > with the underlying transaction manager has failed. ---> > System.Runtime.InteropServices.COMException: The Transaction Manager is not > available. (Exception from [...] read more

Need Help. Why does the SSIS Runtime fail to start the distributed transaction?

Some days ago I decided to reinstall Windows 10 and all my development tool like latest version of SQL Server 2017 and Visual Studio 2017 Professional. I also installed SQL Server Data Tool to get Business intelligence project templates like Integration services and Analysis services. Everything seems alright until I [...] read more

SSIS: Making an Informix transaction local doesn't work

For a single SSIS task I'm trying to make its transaction local. To simplify things, I'm trying to do it like this: * create the new package * create just one Execute SQL Task * inside that task I delete some rows from destination table and issue a ROLLBACK: DELETE [...] read more

TSQL SQL 2000 stored proc cursor

I'm new to this board. I have been driving myself crazy trying to find the answer to my problem. I created some TSQL code that executes some dynamic SQL in a cursor within a stored proc. The cursor fetches some data from table x, builds a query based data retrieved [...] read more