I have gone through the answers for similar questions: The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "DB_PROD_04" was unable to begin a distributed transaction
Distributed Transaction on Linked Server between sql server and mysql
But, they just don't seem to be working for me and hence I am requesting for a solution with a fresh post.
Background: I have MySQL Server that is completely managed by a vendor and I only have READ access to it. On the other hand, I have SQL Server 2014 instance (Caller) running on Windows Server 2012 R2 in our domain. Previous DBA had set up Linked Server named 'BEQUICK' to call a Stored Procedure: Exec usp_ExtractBqDataAndPreprocess 13
This Stored Procedure fetches aggregated data from MySQL instance and saves it to our Disk. Within this Stored Procedure runs 3 Stored procedures. Exec BEQUICK_CUBE_Customers_post_pull Exec BEQUICK_CUBE_Customers_Update Exec BEQUICK_CUBE_Inventory_Update
Issue: Today when I tried to run it, it fetched me an error stating that the Operation could not be performed because OLE DB provider "MSDASQL" for Linked Server "bequick" was unable to begin a distributed transaction.
Actions Taken: Step1: Accessed Linked Server Properties > Server Options, altered it to: 
Step2: Accessed Local DTC Properties, and kept trying all combinations to somehow make it work. Finally, leaving it as:
Step3: I got into Windows Firewall and ensured:
None of this could resolve my issue and now I don't know what is next so any help will be highly appreciated. Please do let me know if I haven't furnished any intrinsic information that I should have.
