This error message ca be seen with various Test Data Manager (TDM) components and either MySQL, SQL Server, or SQL Server Express as the database. Here are a few example scenarios:
Scenario 1:
When setting up a connection profile for MS SQL Server Database in Datamaker and testing the connection, we received the following error message:
The server replied:
Could not get JDBC Connection; 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."
Scenario 2:
When trying to use a local SQL Server for setting up the required connection profile in TDM Portal. We are able to connect to this SQL Server using SQL Management Studio, as well as through Datamaker. When trying to set up the connection profile in TDM Portal, we get the below error.
Failed to connect.
The server replied: Could not get JDBC Connection; The TCP/IP connection to the host, 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".
Scenario 3:
When trying to use the Repository with Subset, we get the following error message when launching the Subset from Datamaker, or launching Subset individually:
The TCP/IP connection to the host local, port 1433 has failed. Error: "null. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.
CA Test Data Manager (TDM)
UIM ( Unified Infrastructure Management) with SQL Server DB
There are several potential causes of this error message:
Here are some various troubleshooting steps you can take to find the root cause of the error and their subsequent resolutions:
Enable TCP/IP:
Enable TCP/IP (Listen All):
Host reachable and running:
SQL Server:
SQL Server Express:
Profiles.xml for Subset:
Localhost or IP Address:
If you are still experiencing any issues, please open a support case by going to https://support.broadcom.com