Datamaker: Internal error when trying to connect to repository

Products

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

Issue/Introduction

While creating the connection profile for the TDM Repository, we receive this error message: 

Internal Error 
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. 

Environment

CA Test Data Manager (TDM)- Datamaker

Resolution

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://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-10/installing/install-test-data-manager/connect-datamaker-to-the-repository.html. 

Additional Information

If you experience any further issues, please open a support case by going to https://support.broadcom.com