Solution for msdtc not available in MS-SQLSERVER

If you encounter the issue of msdtc being unavailable in MS-SQLSERVER, you can try the following solutions:

1. Check if the MSDTC service is running properly. In the Windows services, locate the “Distributed Transaction Coordinator” service and make sure its status is “Running”.
2. Check the firewall settings to make sure that the MSDTC port (usually port 135) is not being blocked by the firewall. You can add an inbound rule in the firewall settings to allow MSDTC to use that port.
3. Ensure that RPC (Remote Procedure Call) configuration is checked. MSDTC relies on RPC for communication, so make sure that RPC is enabled and configured correctly on the server.
4. Re-register MSDTC by running the following commands in Command Prompt as an administrator: “msdtc -uninstall” followed by “msdtc -install”. This will re-register MSDTC and rebuild its configuration.
5. Restart the server. Sometimes, rebooting the server can resolve issues with MSDTC being unavailable.
6. Check the permission settings to ensure that the account where the MSDTC service is located has enough permissions to run.

If the above methods still cannot solve the problem, it is recommended to check the MSDTC log file for more detailed error information, and troubleshoot and resolve the issue further based on the error information.