TDM Portal: The TCP/IP connection to the host localhost, port 1433 has failed

Document ID : KB000116920
Last Modified Date : 23/10/2018
Show Technical Document Details
Issue:
The TCP/IP connection to the host localhost, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall" 

The error message above was shown on the Portal screen because of which you were not able to connect to source DB or Target DB. 
Environment:
TDM Portal version 
Target/Source connection: SQL Sever Database
Cause:
Troubleshooting Analysis: 
****************************** 
The SqL Server Database connection was successfully connection from GTDatamaker and GTSubset but not from the TDM Portal. It was throwing an error as mentioned above. 

Cause Determination: 
************************* 
GTDatamaker is a Windows tool and it uses shared piped method to make a connection to the SQL Server DB and hence establish connection to the port on which the SQL Server Service is running however, Portal needs the port to be static and open to establish a connection.
Resolution:
Resolution: 
*************** 
We have to make SQL Server Listen on TCP 1433 Port instead of Dynamic Port 

1) Go to SQL Sever Configuration manager and right click on TCP/IP of your SQL Server instance under Network Configuration 
2) Right click and select properties. 
3) Go to IP Addresses tab 
4) Remove 0 fromTCP Dynamic port from every IP entry. 
5) Enter port entry like 1433 against TCP Port of every IP entry. 
6) Go to "ALL IP" entry in the end and remove 5XXXX like dynamic port entry. Now put static port entry like 1433 etc in "ALL IP" entry 
7) Restart SQL Server Service and the SQL Sever Browser Service from services.msc screen. 
Additional Information:
If you face any issues or have any questions about the steps, please open a support case by going to https://support.ca.com/irj/portal/anonymous/newhome or by calling customer care at http://www3.ca.com/us/support/customer-assistance.aspx.