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
Release : 4.9
Component : CA Test Data Manager
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”.