WEM Database Upgrade Failure "CREATE DATABASE permission denied in database"

WEM Database Upgrade Failure "CREATE DATABASE permission denied in database"

book

Article ID: CTX228740

calendar_today

Updated On:

Description

When attempting to create a new Database/update an existing database using the Database Creation Wizard, we receive the following error:

User-added image

The following error is is written to the WEM Database Management Utility Log:
"CREATE DATABASE permission denied in database"

User-added image


 

Resolution

Added SysAdmin permissions to the Service account being used to authenticate to SQL during the Database creation process.
 

This level of permissions is required per the following Citrix Docs:
https://docs.citrix.com/en-us/workspace-environment-management/current-release/system-requirements.html

Microsoft SQL Server 2008 R2 or later: Workspace Environment Management requires sysadmin access to a SQL Server instance to create its database, and read/write access to this database to use it.


Problem Cause

Service account did not have required permission to write to the Database or create new Database.  SysAdmin Permissions are required.