Hot answers tagged

10

Elijah. There's two separate questions here: 1. Is DTC supported with AlwaysOn Availability Groups? As Microsoft says in big letters, no. I totally understand that you want to try it anyway, but keep in mind that you're now putting something into production that Microsoft simply will not support, AND you're using two separate niche features together (AGs ...


5

I would imagine its either: EXEC sp_serveroption @server = 'ServerB',@optname = 'remote proc transaction promotion', @optvalue = 'false' ; Use this option to protect the actions of a server-to-server procedure through a Microsoft Distributed Transaction Coordinator (MS DTC) transaction. When this option is TRUE (or ON) calling a remote stored ...


3

Have you tried profiling a single session to see if/when its transaction is promoted to distributed? For example, using a server side trace using e.g. the DTCTransaction (and maybe TM: Promote Tran xxx) event classes. You can also monitor detailed DTC activity in Windows. I would profile all the likely looking connection, execution, and transaction-related ...


3

MSDTC is not required for a SQL Server 2012 fail over cluster. However, if you plan to use Linked Servers, then you will need to create a clustered MSDTC resource. The good news is that can be setup after the cluster is already built and after SQL Server has been installed.


2

MSDTC has to be installed on a separate drive while rest can be installed on another drive. EDIT MSDTC is needed on separate drive because once you start installing SQL Server, the drive where MSDTC is installed won't be selectable and you will see message on screen something like "Cluster Disk 2 is already in use by MSDTC". Secondly, according to ...


2

Microsoft Distributed Transaction Coordinator is a service that runs on the machine that cannot be configured per database. The service is either installed, or it isn't. Since a distributed transaction must use a linked server, you could theoretically use permissions on any linked servers you have configured to allow only your process access. You could ...


2

The article isn't well worded but here's what I think it's saying Beginning scenario - DatabaseA is in an AG and is currently primary on Server1 and can run on Server2. DatabaseB can only run on Server1 T1 - Transaction begins T2 - Row inserted into DatabaseA (log not yet sent to Server2 though) T3 - Row inserted into DatabaseB T4 - Transaction commit ...


1

The job has several steps. In the step that ran the package, I had to select "SQL Server" as the package source instead of "SQL Server Package Store". This stopped the use of MSDTC.


1

Have you configured MSDTC on both the source and target machine using dcomcnfg? The distributed transaction coordinator, by default, does not allow distributed transactions. You need to configure it by running dcomcnfg as an administrator, and configure the options applicable to your situation:


1

You can get the correlation you're looking for in the sys.dm_tran_active_transactions DMV. The column is transaction_uow. http://msdn.microsoft.com/en-us/library/ms174302.aspx


1

It was a while i posted this, i did solve the problem after i while. The problem was related to Symantec Storage Foundation. KB here: http://www.symantec.com/business/support/index?page=content&id=TECH125163 In the article it says you need to call them to get a hotfix, but SP2 that is avalible for download also solved the problem.


1

There are two Distributed Transaction Standards Supported by the DTC. XA Transactions and OLE Transactions and recovery is implemented differently. XA Transaction Recovery Process use xa_recover_entry of GetXaSwitch to get a list of xid from the transaction resource manager (SQL Server is a resource manager) that it then uses to rollback or commit the ...


1

We have run into issues when servers were re-named and we had to set the DTC security properties to "No Authentication Required" on all servers involved in the transaction. This is not a best practice but works for internal network only servers. Directions to the DTC security settings can be found here: ...


1

FIXED! Every site has the same step-by-step. Start DCOMCNFG Expand "Component Services" Expand "computers" > Expand "My computer" Expand "DTC" right click on "Local DTC" Properties Security check "Network DTC Access" and " allow remote clientes". It for sure will help a lot of people. The problem is that the server is in ...



Only top voted, non community-wiki answers of a minimum length are eligible