Symptoms or Error
When attempting to create a new Database/update an existing database using the Database Creation Wizard, we receive the following error:
The following error is is written to the WEM Database Management Utility Log:
"CREATE DATABASE permission denied in database"
The following error is is written to the WEM Database Management Utility Log:
"CREATE DATABASE permission denied in database"
Solution
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.