Skip to main content

Unable to Create Site for Citrix XenDesktop 7 with "Cannot write property Collation. This property is not available on SQL Server 7.0" error

This issue occurred when i wanted to use SQL 2012 in my XenDesktop 7 environment (new setup). This error blocked Admins from creating new XenDesktop Site. Based on Citrix KB, it turned out that Share Management Object (SMO) library needs to be upgraded to SP1 on the server which hosting Citrix Studio.



Issues :


Unable to create Site on XenDesktop 7 with below error :
Cannot write property Collation. This property is not available on SQL Server 7.0





Resolution :
  1.  FIrstly, download Shared Management Objects from here :
  2. Double click at SMO

  3. This screen will launch.

  4. Installation will upgrade SMO. Press Yes to this message box.

  5.  Press Next 

  6. Accept the license, and press Next

  7.  This is optional step, press Next once you done


  8.  Press Install

  9.  Installation in progress...



  10. Done. Press Finish.


  11.   You can create the Site by now. 
Reference 

  • http://www.microsoft.com/en-us/download/confirmation.aspx?id=26728
  • http://support.citrix.com/article/CTX132438

Comments

Popular posts from this blog

How To Change NetBIOS Name of A Computer

So yes... After 4 months without new contents, so I started with this. It looks easier to do (well, it is), but before you do that, you may want to read this  to understand the difference between hostname and netBIOS, then starts to explore on when to use them, their limitations etc etc. I won't discuss here (or maybe not today). So let's back to the topic.   Description : Changing NetBIOS Name of A Computer. ComputerName : NetBIOS : How To Do :  Go to Start > Run , and type REGEDIT  Browse to Computer > HKEY_LOCAL_MACHINE > SYSTEM > CurrentControlSet > Control > ComputerName > ComputerName At the right side, double click at ComputerName string, and put correct Value data . Press OK .  Then you will get this Reboot your computer / VM. Once it is up, double check your netBIOS name. New name shall be reflected

Microsoft Assessment and Planning (MAP) Toolkit - Extract Report (3/4)

As mentioned in  the first post , this KB series is about Microsoft Assessment and Planning (MAP) Toolkit. There are 4 main steps : Install MAP Toolkit and its basic configuration Collect inventory Data  Extract Report Extract Advanced Report Once inventory data collected, we can generate reports. From the inventory data collected earlier, we can use options in the toolkit to generate the report. For this example, we re going to discover Windows 10 Readiness This KB is about  how to generate report from collected inventory data. At Overview page, select the targeted scenario category. In this example, it is Desktop . At this page, select specific scenario that we after. In this example, it is Windows 10 Readiness.     It is possible to customize assessment properties. The properties will set the threshold of the assessment, such as, threshold for minimum CPU speed, acceptable free disk, as well as minimum assigned RAM. To do so, s...

Microsoft Assessment and Planning (MAP) Toolkit - Install MAP Toolkit and its basic configuration (1/4)

As mentioned in previous post , this KB series is about Microsoft Assessment and Planning (MAP) Toolkit. There are 4 main steps : Install MAP Toolkit and its basic configuration Collect inventory Data  Extract Report Extract Advanced Report This KB is about how to install MAP Toolkit and its basic configuration Download the toolkit here : https://www.microsoft.com/en-nz/download/details.aspx?id=7826 Launch the installer with Administrator privilege Select Next on the welcome screen Accept the agreement and select Next Configure installation path, and select Next Ready to install. Select Install Installing… Select Finish Launch the app MAP launched. DB needs to be set up prior to use the toolkit Connection to inventory database needs to be created. Give it a name , and select OK . Note that by default, the data source name is  LocalDB (MAPToolkit) Overview page of MAP. Step completed.