There are some issues reported that might arise while creating XenDesktop sites due to the following reasons:
As highlighted in the Overcoming database service account issues section, it is very important to make sure that the service account you are using for the DB connection to create the XenDesktop site has sufficient permissions. Otherwise, the site creation may fail due to insufficient permission errors. You can refer to the DB permissions table given in the Overcoming database service account issues section.