After following these steps to enable XA - transactions in sql server I was able to resolve the issue.
And one more thing to note, even after following the steps to enable XA - transactions if the MRA fails, try doing this - Login to Workbench. Open components view. Right cick Components and install and start the below mentioned DSC (in order):
Just right click the stopped components and start it.