Unable to connect to Datamaker

Products

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

Issue/Introduction

When I connect to the repository (gtrep on MSSQL server 2016 ) it takes me to the DM login as expected but when I enter Administrator and the password it gives me an error saying the

Administrator user does not exist in the repository.

I can connect to the same repository using Administrator/password via the portal and it connects correctly. And I can see the user is set up form the portal screen and also in the backend db

 

Environment

Release : 4.9

Component : CA Test Data Manager

Resolution

The user used to the gtrep database is not having the right database acces rights as db owner it works but as a user with read /write acces it fails.

Adding the execute permission to the database user would  resolved issue  .

Datamaker is running several stored procedures and need execute permission .

The issue is now resolved. We worked with our DB security team and enabled explicit execute access on stored procedure “p_config_accessfn”.