"The specified schema name \"dbo\" either does not exist" error when upgrading

"The specified schema name \"dbo\" either does not exist" error when upgrading

book

Article ID: CTX224355

calendar_today

Updated On:

Description

Unable to upgrade XenMobile Server from 10.3.5 to 10.5.

The specified schema name \"dbo\" either does not exist or you do not have permission to use it.\nSQL state:42000\nSQL error code:2760"}'

Resolution

Please ensure you perform the upgrade with the required permissions added.

System Requirements
https://docs.citrix.com/en-us/xenmobile/10/xmob-system-requirements.html

Citrix recommends using Microsoft SQL remotely. PostgreSQL is included with XenMobile and should be used locally or remotely only in test environments. Note: Make sure the service account of the SQL Server to be used on XenMobile has the DBcreator role permission.

Problem Cause

Database user configured with XMS, lacks the permissions to modify the database tables and schemas during an upgrade