error "OLE DB provider SQLOLEDB was unable to begin a distributed transaction"
This error may occur when use begin and commit transction when you are using linked server. In the case go to control panel --- administrator tools --- components --- click on Local DTC ---
properties and check Allow remote clients
check allow remote administration
check allow inbound
check allow outbound
Further to this you need to have a windows account which is authenticated on both the servers.
No comments:
Post a Comment