Citrix is committed to ensuring compatibility with the latest Microsoft SQL Server Releases
This document outlines issues and their known workarounds that users of Microsoft SQL 2012 RTM (Release to Manufacturing) must be aware of in conjunction with the following Citrix products:
XenDesktop 5.0 Service Pack 1
"Installation Failed" Error dialog box appears while installing Citrix SmartAuditor Administrative Package.
Currently there are no resolution available for this issue, ignoring the error message will allow the installation to complete successfully.
Unable to install the Citrix SmartAuditor using SQL Express 2012, it fails with an error message “Microsoft SQL Server or Express Edition (2005 and later) must be installed on the local machine."
Currently there are no workarounds available for this issue.
Unable to Create New XenDesktop Farm using SQL 2012 RTM server, it fails with the error message: “Cannot write Property Collation. This Property is not available on SQL Server 7.0”.
This issue is caused by Desktop Studio is not being able to communicate with the SQL 2012 server because of the Shared Management Object Library that is included in RTM version of SQL 2008 R2.
To resolve the problem the Share Management Object library will need to be upgraded to Service Pack 1. This is included in Microsoft® SQL Server® 2008 R2 SP1 Feature Pack. Installing the Service Pack 1 version of the Shared Management Objects Library resolves the problem as well as also replacing the SharedManagementObjects.msi with the Service Pack 1 version within the XenDesktop ISO.
Microsoft® SQL Server® 2008 R2 SP1 Feature Pack
You can find the original knowledgebase article here.