While creating the connection profile for the TDM Repository, we receive this error message:
TCP Protocol must be enabled and detectable for your SQL Server instance!
The user "GTREP" does not have sufficient privileges to determine the IP address of the server.
Please grant VIEW SERVER STATE to the user and try again.
CA Test Data Manager (TDM)- Datamaker
TDM does require that TCP protocol be enabled for use of SQL Server with Datamaker. You can follow these directions to do this: https://technet.microsoft.com/en-us/library/hh231672(v=sql.110).aspx
You will also need to ask your DBA to make sure the GTREP user has a privilege level high enough to 'VIEW SERVER STATE'. After that has been granted, you can follow these directions to connect to the repository in Datamaker: https://docops.ca.com/ca-test-data-manager/4-4/en/installing/install-ca-test-data-manager/connect-to-the-repository.
If you experience any further issues, please open a support case by going to https://www.ca.com/us/services-support/ca-support/contact-support.html.