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

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

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.