Citrix Web)Studio error when trying to access App Packages after upgrade
Article ID: CTX565152
Updated On:
Description
- Cannot access app library packages in web studio due to being blocked by an error
- The details of the eror will be similat to this :The SELECT permission was denied on the object 'AppVPackage', database 'databasename', schema 'AppLibrarySchema'. SqlErrorNumber : 229
Resolution
Ensure the controller computer accounts have the permissions documented here:
https://docs.citrix.com/en-us/citrix-virtual-apps-desktops/technical-overview/databases.htm#permissions-required-to-set-up-databases
| Operation | Purpose | Server role | Database role |
|---|---|---|---|
| Create a database | Create a suitable empty database | dbcreator | |
| Create a schema | Create all service-specific schemas and add the first Controller to the site | securityadmin* | db_owner |
| Add a Controller | Add a Controller (other than the first) to the site | securityadmin* | db_owner |
| Add a Controller (mirror server) | Add a Controller login to the database server currently in the mirror role of a mirrored database | securityadmin* | |
| Remove Controller | Remove controller from site | ** | db_owner |
| Update a schema | Apply schema updates or hotfixes | db_owner |
Problem Cause
Database permissionsAdditional Information
Citrix Virtual aps and Desktops Database Technical overview: https://docs.citrix.com/en-us/citrix-virtual-apps-desktops/technical-overview/databases.htm
Was this article helpful?
Yes
No
Powered by
