I've a .net 3.5 windows service which uses msmq running on 2008 application server.This service communicates with the sql 2005 database on the database server. Am getting an error mentioned below on calling this service from my aspx page on 2008 web server: "Network access for Distributed Transaction Manager (MSDTC) has been disabled. ...
I am trying make a database transaction(inserting records) across multiple system. So, I decided to use System.Transaction Namespace in .net. I configured MSDTC on both system(But i dont know whether i configured correctly). My transaction has two insert query one will execute at local system. another, will execute at some other system i...
We have a particularly bizarre problem; let me set the scene. Solution found see below We have three SQL Server 2005 databases, for the sake of argument called: Alpha, Beta and Gamma. There is a replication relationship defined between these databases as follows: All three databases have a table named "AnExample" with the same schema....
We have some unit tests running against a SQL server 2000 database using the DatabaseTestFixture (http://softwaredevscott.spaces.live.com/blog/cns!1A9E939F7373F3B7!155.entry ) class which uses a TransactionScope that is not commited and therefore all changes are rolled back. The tests ran against a local database with no problem. ...
I'm using two server. one as Application Server(win server 2003 sp2) and another one is DataBase Server(win server 2003 sp2). when i run the app server it produce "Invalid operation. connection closed" or " communication underlying transaction failed".. after i surfed on net i know it's DTC problem. i opened port 135,1443,1434 and port...
I've noticed that very simple distributed transactions take a good amount of time (3-4s) to complete on a first run. But if the same transaction scope is called again, it's much faster (30ms). It seems like MSDTC sort of goes to sleep after an hour. After the hour has passed, the next transaction to run will take 3-4s. I don't expect...
I am using the .NET 2.0/3.5 framework for my application. I need to run several SQL commands across multiple connections and each connection is on a different server (Oracle, SQL Server). I need to make sure these commands are transactional. For example: I need to perform an INSERT in a table on both Oracle and SQL Server databases, t...
Are there any general security risks associated with having MSDTC enabled? I was told, by one of my team members, that there are security risks involved with enabling it, but I would like to know what they are, if any. ...
What is the best way to attempt to debug and pinpoint the code causing a SQL transaction to be elevated to a DTC? I'm working with an existing API that is failing for me alone, so i believe it to be some kind of config error or something wacky. I'm not having much luck finding the culprit via debugger. Are there better ways to find the o...
I get the following error each time I open DTCPing. What's the cause of this error? Thanks. Error(0x57) at rpcUtil.cpp @133 -->I_RpcServerAllocateIpPort -->87(The parameter is incorrect.) Error(0x57) at rpcUtil.cpp @54 -->87(The parameter is incorrect.) ...
Just curious if anyone else has got this particular error and know how to solve it? The scenario is as follow... We have an ASP.NET web application using Enterprise Library running on Windows Server 2008 IIS farm connecting to a SQL Server 2008 cluster back end. MSDTC is turned on. DB connections are pooled. My suspicion is that some...
First off, I don't know if this is possible, but let me describe my scenario. I have a set of WCF services, a SQL Server 2008 Database all running on Windows Server 2008. All of this works fine when I am connected to my LAN, however I am going to be using this box for a demo, and I would like to make it work in standalone mode (ie, not ...
Hi, I have an application that retrieves data and stores into a database once per day. Until recently this application has resided on the same machine as the SQL server but due to some hardware issues with some of the required peripherals, it has been moved to a seperate machine running windows XP. The problem we are having here, is th...
Hi, Simple question but I can't find the answer anywhere: is Active Directory transaction-aware? In other words, will the following change be rolled back (since I didn't call scope.Complete()): using (var scope = new TransactionScope()) { DirectoryEntry entry = ...; entry.Properties["givenName"].Value = "New Given Name"; e...
Hi! We're in the process of moving our SQL Server to it's own machine, but I'm having issues getting transactions through MSDTC to work. Here is the error message ASP.Net is generating for me: The transaction manager has disabled its support for remote/network transactions I have tried googling around for this, but haven't m...
Hi, I'm currently in the process of detaching a development database on the production server. Since this is a production server I don't want to restart the sql service. That is the worst case scenario. Obviously I tried detaching it through SSMS. Told me there was an active connection and I disconnected it. When detaching the second t...
I'm using C# on Windows Server 2008, and I want to receive a message from a public transactional queue on another machine in the same domain. The error looks like this: System.Messaging.MessageQueueException: Cannot import the transaction. at System.Messaging.MessageQueue.ReceiveCurrent(TimeSpan timeout, Int32 action, CursorHandle c...
I followed this spectacularly worthless piece of drivel from MS http://support.microsoft.com/kb/899115 in order to turn on MSDTC trace. As it fails to follow through on a very reasonable and obvious expectation of the reader, specifically "how do I read this binary log file?" I read this equally worthless KB document http://msdn.microso...
Question is in the title. I'd just love to understand why this isn't supported? Just to clarify this is MS Sql Server 2005 / 2008. ...
I have a WCF based web service hosted in windows sever 2003 machine. The database is Oracle 10G on solaris. The web service uses transactionscope extensively and ado.net transactions in some places. Most of the transactions involve only one resource (multiple oracle stored proc calls). Some of them are two resources (MSMQ and oracle stor...