I was faced with this error when I was trying to configure a web application and trying enter a transaction through the virtual website. Thanks to the internet, I found a lot of information on the internet.
Here are the steps I followed to correct this:
Start the Component Services administrative tool. To do this, click Start, click Run, type dcomcnfg.exe, and then click OK.
In the console tree of the Component Services administrative tool, expand Component Services, expand Computers, right-click My Computer, and then click Properties.
Click the MSDTC tab, and then click Security Configuration.
Turn on the Network DTC Access
Allow Inbound
Allow Outbound
Enable XA Transactions
Choose No Authentication required
Save these settings and reboot your system.
The error is fixed.
In Windows Server 2003 SP1 and in Windows XP SP2, the Distributed Transaction Coordinator service gives you more control over the network communication between computers. By default, all network communication is disabled. The Distributed Transaction Coordinator Security Configuration dialog box has been enhanced so that you can manage these communication settings.
Subscribe to:
Post Comments (Atom)
Navigating the Data Science Seas: A Journey with Microsoft Fabric
Data science is a vast and exciting field, brimming with the potential to unlock valuable insights. But like any seafaring voyage, navigatin...
-
From the past 3 days I have been working on resolving merged and hidden cells issues when an SSRS reports is exported to excel. ...
-
I was trying to build an SSIS package that one of my colleagues has created. The first error that was thrown was as below: Exception des...
-
Today I was trying Node.js to connect to SQL Server, the connection to the sql server failed with the below error. name: 'ConnectionE...
2 comments:
I have the same problem, but I am not able to see the security settings mentioned by you on my Win 2K Server.
I am experiencing the issue of DTS pump not allowing enlist into transaction. Followed your instructions and the settings needed adjusting as you described. Thanks a bunch.
Post a Comment