by Aage Andre

Citrix XenApp 6.5 and XenDesktop 5.5 SQL Database Configuration

Finding information on Citrix products where you’re not using the “default, quick setup, this is the way to do it in lab-environment” is always a pain. For some reason, people who are good at Citrix won’t share info, and e-docs are pretty much useless, telling everything you can see with your own eyes(“After you start setup.exe, click Next to go to the next step”. You don’t say??)

When setting up XenApp 6.5 for the first time, there was absolutely no information on the database requirements to be found. The config-tool won’t create the DB for you, so you’ll have to do it manually, but info is hard to find.

I ended up booting my EVA that i downloaded for trial from Citrix and checking the collation on that database. Turns it was set to Latin1_General_CP1_CI_AS. So create your DB with that collation, and you should be good.
(If I remember correctly, this is the same collation as XenDesktop uses, which has equal little info. I remember the only place I found it was in the comments of the generated scripts during setup)

Other than collation, default settings should be fine. I set Recovery model to Full, but either way, it shouldn’t have an impact.

If you don’t know how to set collation, create the DB like this:
CREATE DATABASE CitrixXenAppDB COLLATE SQL_Latin1_General_CP1_CI_AS