Overcoming database service account issues

While installing XenDesktop, you need to make sure that the service account or admin account that you will use to configure and build the XenDesktop site has the appropriate rights to the database server.

We have seen issues where site creation has failed if the appropriate DB rights are not given to the account being used to configure the site. Let's take a look at the following DB rights required to configure the XenDesktop site:

DB operation	Function	Server roles	Database permission
Database creation	Creates an empty database for use by the XenDesktop site.	dbcreator
Schema creation	Creates all service-specific database schemas and adds the first controller to the site.	securityadmin	db_owner
Add controller	Adds the controller (other than the first) to the site.	securityadmin	db_owner
Add controller (mirror server)	Adds the controller login to the database server currently in the mirror role of a mirrored...