DEVTEST issues with external DB

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

 Starting VSE and getting permission issue that the Registry tables cannot be accessed.  Registry logs shows  the below message. 

CREATE TABLE permission denied in database 'REGISTRY_DB' 



Environment:
any supported versions of DEVTEST
Cause:

 Customer had some space issues on your REGISTRY_DB, so your DBA  changed the recovery model  from Full to Simple, this will mean that there won't be log backups at all so it will stop that logfile from filling up again. However, if they want log files then they can change it back to the Full recovery model and they will need to set up regular log backups.

And  Devtest user did not have permissions to create tables.    



Resolution:

 DBA gave CREATE privilege to the User ID starting the DevTest services.