The TCP/IP connection to the host [server], 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.
TDM Portal version
Target/Source connection: SQL Server Database
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 from TCP 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 Server Browser Service from services.msc screen.