In my case, the service was stopped. solution: need to turn the MSDTC service on
- go to Services. (START > SETTINGS > CONTROL PANEL > ADMINISTRATIVE TOOLS > SERVICES)
- Find the service called ‘Distributed Transaction Coordinator‘ and
RIGHT CLICK (on it and select) > Start. - make this service to run Automatically for solving this issue permanently