Installing XenApp 5 DataStore on SQL Server : (XenApp)

1. Create a SQL Database called Citrix.
2. Please make sure that your SQL Server is configured for SQL Authentication AND NT-Authentication.
3. Create a SQL Login account and give the user DB Owner rights to the Citrix Database.  If you’re having issues when seeting the DSN using this account use a simple password for example ‘citrix’.
4. Now start the installation of Citrix Presentation Server
5. Type in the Citrix Farm and choose SQL Server for your datastore
6. It will then ask you to create a DSN, type in the description and select the SQL Server using the drop down list.
7. Now for the important bit – At the question how the SQL Server verify the authenticity of the Login ID: Select “With SQL Server Authentication using a login ID and Password entered by the User.” Use the login details that you created earlierin step 3.
8. Now select the Citrix database as the default database.
9. Click Next until you get to test connections.  Make sure the connection is successful and then click finish.