Registry tables cannot be accessed: permission denied

Products

• CA Application Test
• CA Continuous Application Insight (PathFinder)

Issue/Introduction

 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

All supported version and platforms of DevTest.

Cause

The Devtest user for the Registry database did not have permissions to create tables.    

Resolution

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

Additional Information

There were some space issues on the REGISTRY_DB, so the 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 log files wanted, then it can be changed back to the Full recovery model and will need to set up regular log backups.