Unable to Create New XenDesktop Site Using SQL 2012 Server

Article | Interoperability, Third Party | 9 found this helpful 

 | Created: 26 Mar 2014 | Modified: 18 Mar 2015

Was this helpful? Yes  No

Symptoms or Error

Unable to create a new XenDesktop farm using SQL 2012 RTM server, it fails with the following error message:
“Cannot write Property Collation. This Property is not available on SQL Server 7.0”

Citrix is committed to ensure compatibility with the latest Microsoft SQL Server Releases. This article contains information about the issue and the resolution that the 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

  • XenDesktop 5.5

  • XenDesktop 5.6

  • XenDesktop 7.x

Solution

To resolve the issue, the Share Management Object library must be upgraded to Service Pack 1 on the Systems running Desktop Studio. This is included in Microsoft SQL Server 2008 R2 SP1 Feature Pack version of the Shared Management Objects Library resolves the issue and replaces the SharedManagementObjects.msi with the Service Pack 1 version within the XenDesktop ISO.

Problem Cause

Desktop Studio is not able to communicate with the SQL 2012 server because the Shared Management Object Library included in XenDeskop ISO (..\Support\SharedManagementObjects) is from RTM SQL 2008 R2, which is of lower version.

Additional Resources

Microsoft SQL Server 2008 R2 Service Pack 1 Feature Pack
Supported Databases for Citrix Products
Citrix Interoperability Validation
 

Disclaimer

These software applications are provided to you as is with no representations, warranties or conditions of any kind. You may use and distribute it at your own risk. CITRIX DISCLAIMS ALL WARRANTIES WHATSOEVER, EXPRESS, IMPLIED, WRITTEN, ORAL OR STATUTORY, INCLUDING WITHOUT LIMITATION WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE AND NONINFRINGEMENT. Without limiting the generality of the foregoing, you acknowledge and agree that (a) the software application may exhibit errors, design flaws or other problems, possibly resulting in loss of data or damage to property; (b) it may not be possible to make the software application fully functional; and (c) Citrix may, without notice or liability to you, cease to make available the current version and/or any future versions of the software application. In no event should the code be used to support of ultra-hazardous activities, including but not limited to life support or blasting activities. NEITHER CITRIX NOR ITS AFFILIATES OR AGENTS WILL BE LIABLE, UNDER BREACH OF CONTRACT OR ANY OTHER THEORY OF LIABILITY, FOR ANY DAMAGES WHATSOEVER ARISING FROM USE OF THE SOFTWARE APPLICATION, INCLUDING WITHOUT LIMITATION DIRECT, SPECIAL, INCIDENTAL, PUNITIVE, CONSEQUENTIAL OR OTHER DAMAGES, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. You agree to indemnify and defend Citrix against any and all claims arising from your use, modification or distribution of the code.

Applicable Products

转自：

http://support.citrix.com/article/CTX132438