Citrix XenApp/XenDesktop and MS SQL Compatibility recommendation

Looking at the XenDesktop 7.9 ISO they still haven’t included the Share Management Object library SharedManagementObjects installers from the SQL 2014 Feature Pack.
Given that the files are backwards compatible, I would recommend replacing them in your ISO/install folder for any future projects, as I’m seeing a lot more clients using SQL Server 2014 these days, or calling it out in upcoming designs.
Files can be found here: https://www.microsoft.com/en-us/download/details.aspx?id=42295 grab both x86 and x64 (save to different locations as they have the same name).
This will give you support for SQL 2008R2 up to 2014.
If you use an incompatible version when creating the Farm, you’ll get an error similar to “Cannot write Property Collation. This Property is not available on SQL Server 7.0”.
More info here (http://support.citrix.com/article/CTX132438)

Author: Mike

Mike Streetz is a Citrix Consultant who works with everyone from small businesses to large enterprises to help their users get work done via Citrix Virtual Apps and Desktops. He has been working in the Citrix space for over 10 years. Mike knows that your users don’t want long logon times, don’t want long waits for files and don’t enjoy when “Citrix is slow”. His job is to help you get the most out of your Citrix environment. Mike has worked with clients to optimize user experience by using tools such as FSLogix alongside Citrix ADC with Global Server Load Balancing to point users to the fastest site to serve their needs. Mike is a Citrix Technology Advocate, CUGC Leader of the Los Angeles chapter, Citrix Certified Professional in Citrix Cloud, Virtual Apps and Desktops and Citrix ADC and holds the Azure Administrator Associate certification. He has previously spoken at the Ruxcon security conference in Australia.

Leave a Reply

Your email address will not be published. Required fields are marked *