You would need to enable MS DTC on the server and ensure that it is enabled for remote access if the sql server and website are on different machines.
You can turn on the service from the 'Administrative Tools' -> 'Services' option, you can enable remote access by going into 'Component Services' -> 'Computer' -> 'My Computer' -> 'Properties' -> 'MSDTC' tab -> 'Security Configuration'.
Also you would need to update the connection string and add 'enlist=false' attribute.
Hope that helps,
No comments:
Post a Comment