我正在尝试在RDS上使用MSSQL Server作为我的ASP.NET MVC站点。 不幸的是由于成员资格提供者的工作方式（不能让我访问其使用的事务）我在创建帐户时必须使用TransactionScope以避免竞争条件和潜在的失败导致状态不一致（当我创建一个网站的新帐户我也想对数据库进行其他更改）。
但是因为事务跨越两个不同的连接，我需要配置分布式事务。 如果我只是使用虚拟机但是如果我尝试使用RDS，那么我似乎无法找到配置它的机制。
我已经将端口135添加到安全组以通过它，我很确定我已经在webserver / dev框中正确配置了它（ish）。 所以我现在留下了以下错误。
合作伙伴事务管理器已禁用其对远程/网络事务的支持。
我假设这意味着RDS服务器没有配置此选项，但我不知道如何配置它。 我的谷歌在这些搜索条件（rds，aws，distrubuted Transactions，MSSQL Server）上似乎特别弱。 我没有得到任何好听的点击D：。
更新：我已经碰到了这篇文章，声称它在7月份没有得到支持....所以也许它还没有得到支持。 如果有人知道是否有关于此状态的更新，请告诉我！
I'm trying to use MSSQL Server on RDS for my ASP.NET MVC site. Unfortunately due to the way the Membership provider works (doesn't provide me with access to the transaction its using) I have to use a TransactionScope when creating an account to avoid the race conditions and potential failures resulting in inconsistent state (when I create a new account for the website I also want to make other changes to the database).
However because the transaction is across two different connections I need distributed transactions to be configured. This is fine if I'm just using a VM but if I try using RDS then I can't seem to find a mechanism to configure it.
I've added port 135 to the security group to let it through and I'm pretty sure I've configured it correctly (ish) on the webserver/dev box. So I'm now left with the following error.
The partner transaction manager has disabled its support for remote/network transactions.
Which I'm assuming means that the RDS server has not got this option configured but I am at a loss as to how to configure this. My Google fu appears to be especially weak on these search terms (rds, aws, distrubuted transactions, MSSQL Server). I'm not getting any nice hits D:.
UPDATE: I've bumped into this article which states it wasn't supported back in July.... so perhaps its not supported yet. If anyone knows if there has been an update on the status of this then let me know!
最满意答案
目前看来，RDS不支持分布式事务。
It seems that at present distributed transactions are not supported on RDS.
更多推荐
发布评论