Database Permissions in XenDesktop 5–Use SQLCMD mode!
The database requirements for Citrix XenDesktop 5.5 changed a bit from XenDesktop 4 and trying to explain all of these details to your security conscious DBA can be
exhausting fruitless aggravating time consuming challenging occasionally. If you are using the Desktop Studio to initially configure your database, you will need to have the user running the install given Security Admin rights on the database. Apparently, this is not always as easy as it seems.
After some back and forth conversations with the DBA group, out of desperation, I decided to click the Generate… button. Problem solved.
Clicking Generate outputs a nice and easy SQLCMD script that you can give to your DBA that basically answers all of their questions (thanks to the great commenting in the script) and allows them to set up the database environment for XenDesktop using their God Mode privileges. Couldn’t be easier.
If you’ve been struggling coming up with the correct permission requirements for your DBA, give the Generate button a try.