If you are
not using an rep.xml file, you will need to edit the connection profile from the DataMaker main page. You edit the configuration, right click on the connection profile, and select edit.
<Please see attached file for image>

If you are using an ODBC connection to connect to the SQL Server, then you need t verify the SQL Server is configured to listen on the correct port. For more information on this see
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-on-a-specific-tcp-port?view=sql-server-2017 for steps to specify the port used by the SQL Server.
Then launch the ODBC Data Source Administration utility and modify the ODBC connection so that it is communicating on the new port. You can specify the port the connection needs to use in the "Server" field, where you specify the hostname of the server. The syntax is [hostname],[port].
<Please see attached file for image>

For more information on connecting the Repository to the SQL SERVER see (
https://docops.ca.com/ca-test-data-manager/4-5/en/installing/install-ca-test-data-manager/connect-to-the-repository).
If you are using a rep.xml file, you may still need to modify the connection profile. In some cases, you may need to delete and recreate the rep.xml file. If you need more information regarding creating the rep.xml file see
https://docops.ca.com/ca-test-data-manager/4-5/en/installing/create-rep-xml-file-to-store-repository-credentials.