无法使用SQL 2012服务器上创建新的XenDesktop站点

中国网络水泥

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>

• 　　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,>Applicable Products

• 　　XenDesktop 7.1
  
• 　　XenDesktop 7
  
• 　　XenDesktop 5.6
  
• 　　XenDesktop 5.5
  
• 　　XenDesktop 5
  
• 　　XenDesktop 7.5
  
• 　　XenDesktop 7.6
  
• 
  

　　转自：
　　http://support.citrix.com/article/CTX132438