Skip to main content

Error - 'TCP provider: A connection attempt failed because the connected party did not properly respond...'

Intermittent error whilst I am using the system:- TCP provider: A connection attempt failed because the connected party did not properly respond after a period of time or established connection failed connected host has failed.

J
Written by Jes Foxall-Beckley
Updated over a month ago

This is a local environment issue. The SFDC client PC's are likely trying to connect to a SQL Server Instance on a virtual machine using an alias.
​
The server and SQL Server Instance names are probably correct, but the port number may be incorrect on the alias.
​
Make sure that the port number of the SQL Server Instance that you are trying to connect to is correct. For port number settings, you can use SQL Server Configuration Manager.
​
Fixing the port number on the alias should resolve the issue.
​
Also, launch the firewall exceptions list and whitelist the following file paths and release the port number:-

  • C:\ProgramData\FMClient.FMAST13\Live\XPA\MgxpaRuntime.exe

  • C:\ProgramData\FMClient.FMAST13\Play\XPA\MgxpaRuntime.exe

  • C:\Program Files\Microsoft SQL Server\MSSQL13.FMAST\MSSQL\Binn\sqlservr.exe

  • C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe

  • TCP Port 54321

Did this answer your question?