search cancel

Datamaker: Internal error when trying to connect to repository


Article ID: 6429


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


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. 


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:

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:

Additional Information

If you experience any further issues, please open a support case by going to