search cancel

SV-Invalid Object LISA_PREF_VERSION in Registry logs

book

Article ID: 189241

calendar_today

Updated On:

Products

CA Application Test Service Virtualization

Issue/Introduction

Running Registry as a Windows Service which logs in as a user account.  The user account is then used with integrated security.

When logged in with one user, everything is fine.  When logged in as a different user, database connectivity fails with the error message "Invalid Object LISA_PREF_VERSION"

Asked the DBA to verify permissions on LISA_PREF_VERSION, but apparently no object exists by that name.

Hence, need help figuring out what DevTest is complaining about.

Database is SQL Server 2017.

Environment

All supported DevTest releases.

Cause

Not enough permission on the User trying to create the Database Tables. 

Resolution



While creation of the Registry database, the user must be a db_owner. (CREATE, SELECT, UPDATE, DELETE , INSERT , ALTER, ) in SQL SERVER

Once the Database is created , you can reduce the permissions to Read , write and execute on the Database.

SELECT UPDATE DELETE INSERT .