I have a .NET Windows app that is using MSTDC and it is throwing an exception:
System.Transactions.TransactionManagerCommunicationException: Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool ---> System.Runtime.InteropServices.COMException (0x8004D024): The transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D024) at System.Transactions.Oletx.IDtcProxyShimFactory.ReceiveTransaction(UInt32 propgationTokenSize, Byte[] propgationToken, IntPtr managedIdentifier, Guid& transactionIdentifier, OletxTransactionIsolationLevel& isolationLevel, ITransactionShim& transactionShim)....
Use this for windows Server 2008 r2 and Windows Server 2012 R2
- Click Start, click Run, type dcomcnfg and then click OK to open Component Services.
- In the console tree, click to expand Component Services, click to expand Computers, click to expand My Computer, click to expand Distributed Transaction Coordinator and then click Local DTC.
- Right click Local DTC and click Properties to display the Local DTC Properties dialog box.
- Click the Security tab.
- Check mark "Network DTC Access" checkbox.
- Finally check mark "Allow Inbound" and "Allow Outbound" checkboxes.
- Click Apply, OK.
- A message will pop up about restarting the service.
- Click OK and That's all.
C:\Windows\System32\msdtc.exe
Still Not working Then Use below Enlist=False in the connection string like below
Data Source=<<SQLSERVERNAME>>;Initial Catalog=<<DBNAME>>;Integrated Security=SSPI;Enlist=False;"
No comments:
Post a Comment