Make sure the “Distributed Transaction Coordinator” service is running in the Window Services.
Make sure the Security settings is configured correctly in Windows Component Services.
Make sure firewall is not being blocked in the “Allow apps to communicate through Windows Firewall” section of Windows Firewall Control Panel section.
If SQL Server Linked Server is setup, make sure the properties are set correctly in the “Server Options” section of Linked Server Properties.
Comments