1
vote
0answers
39 views

MSDTC Errors: QueryInterface failed for “ITransactionDispenser”: 0x8004d01c(XACT_E_CONNECTION_DOWN)

I’m having some issues with a server where MSDTC is not working properly. This started happening about two days ago. I’ve tried a number of different things including restarting the VM and I’ve ...
0
votes
0answers
13 views

How does MS SQL Server authenticate MSDTC connections when using SSPI? [migrated]

I'm trying to get SSPI authentication to play well with two-phase transactions via MSDTC, using PostgreSQL with psqlODBC. I can't figure out how it can work securely - so I'm hoping someone can ...
0
votes
1answer
2k views

SQL Server linked server: “Cannot start more transactions on this session.”

i am trying to perform an INSERT operation against a linked server: DBCC TRACEON (3604, 7300) BEGIN TRANSACTION INSERT INTO LIVE.Contoso.dbo.Events (EventGUID, EventDate, LoginGUID, UserGUID, ...
1
vote
1answer
363 views

SQL 2005 Cluster - How to move MSDTC

We currently have a 2 node (Win2003) SQL 2005 Cluster running 2 instances. We need to move all drives to a new SAN but are pondering over how to move the DTC that is currently 'logging' te Quorum ...
-1
votes
1answer
617 views

MSDTC Port 135 open bi-directionally

I have two servers, a web application server and an SQL Server database running on its own server. I have a firewall between these two servers. Do I have to open port 135 on both the SQL Server and ...
2
votes
2answers
243 views

Do MSDTC and disaster recovery go together?

Our application writes to multiple Sql Server databases within a distributed transaction. The Ops guys are saying that this messes up their disaster recovery plan because while the transactions on the ...
2
votes
1answer
385 views

Problem with Distributed Transactions between machines in different domains

We are tring to use an application that uses transactions. The machine running the code is on a stand alone Windows 2003 Server machine. The database server is a Windows 2003 Server with SQL Server ...
4
votes
2answers
354 views

Why does SQL Server 2008 crashed on simple SQL queries?

I'm a developer and running a SQL Server 2008 SP1 instance (default instance) on my local machine (Windows 7 RC 32-Bit). Sometimes when the program I'm developing sends a query to the SQL Server, the ...
1
vote
1answer
3k views

Setting up network for MSDTC connections: How many open ports?

We have a web server (IIS) and a database server (MS SQL 2005) separated by an application proxy / firewall. We want to keep the number of open ports between the two machines at a minimum. Obviously ...
1
vote
3answers
2k views

How to install sqlserver2008 failover cluster on windows2003 server?

Can any one give me the procedure to create a failover cluster on windows2003??? Any links would also be helpful..... I got warning messages on MSDTC such that MSDTC is not running on local machine. ...
1
vote
1answer
758 views

Distributed transaction aborted by MSDTC

How to resolve the error 8522 in SQL Server 2005? I'm getting this error while I'm loading data from the remote server.