sp01事务码_修复了Server 2003 SP2上的“新事务无法在指定事务协调器中登记”

最新推荐文章于 2020-12-30 04:58:42 发布

culul01313

最新推荐文章于 2020-12-30 04:58:42 发布

阅读量163

点赞数

文章标签：数据库分布式 java mysql spring

原文链接：https://www.howtogeek.com/howto/windows/fix-new-transaction-cannot-enlist-in-the-specified-transaction-coordinator-on-server-2003-sp2/

版权

sp01事务码

If you are running a web application using the original ASP technology on Windows Server 2003, you might get this error message once you upgrade to Service Pack 2: “New transaction cannot enlist in the specified transaction coordinator. [-2147168246]”.

如果您在Windows Server 2003上使用原始ASP技术运行Web应用程序，则在升级到Service Pack 2后可能会收到此错误消息：“新事务无法加入指定的事务协调器。 [-2147168246]”。

The cause for this error is that MSDTC has a setting that requires authentication for distributed transactions, and the upgrade to SP2 might change the setting to required instead of none.

导致此错误的原因是MSDTC的设置要求对分布式事务进行身份验证，并且升级到SP2可能会将设置更改为required(而不是无)。

To fix this error, open Component Services and right-click on the My Computer icon and choose properties.

要解决此错误，请打开“组件服务”，然后右键单击“我的电脑”图标，然后选择属性。

Choose the MSDTC tab and then at the bottom of the window click the Security Configuration button.

选择“ MSDTC”选项卡，然后在窗口底部单击“安全配置”按钮。

In this window, change the setting under Transaction Manager Communication to “No Authentication Required”.

在此窗口中，将“事务管理器通信”下的设置更改为“不需要身份验证”。

This should resolve this error.

这样可以解决此错误。

Note that if you have a firewall between the web server and database server then you should ensure that high ports are open between the two machines, along with RPC, as that could also cause the same error.

请注意，如果在Web服务器和数据库服务器之间有防火墙，则应确保在两台计算机之间以及RPC之间打开高端口，因为这也可能导致相同的错误。