Datamaker: Internal error when trying to connect to repository

Document ID : KB000006429
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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://docops.ca.com/ca-test-data-manager/4-4/en/installing/install-ca-test-data-manager/connect-to-the-repository

Additional Information:

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.