A client reported that the installer was reporting an issue contacting the MSDTC service of the SQL Server. After an investigation we narrowed down the possible causes of this issue:
- The machines were created from the same image so they possibly had the same ID. We ran the following commands to reinstall MSDTC
- Msdtc –uninstall
- Msdtc –install
- Check the configuration of the MSDTC Service on the SQL Server and configured it according to the Pre-Installation Checklist
- The MSDTC service is off. Go to the services panel and make sure the service is on.
- Restart the servers
- Use DTCPing (download from the internet) to point out any issues.
Comments