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

Session Settings Not Listed in Citrix Web Interface web site.

In previous post , I mentioned on what need to be done by users in case the publsihed applications did not successfully launched in seamless mode. However, in some cases, users might not be able to see the option. This post will help to solve it. Issues : Session Settings preference is not listed in Citrix Web Interface web site. This is due to the option is not enabled. It can be checked at Citrix Web Interface Management Console. Troubleshooting   Launch Citrix Web Interface Management Console . Browse to Citrix Web Interface > XenApp Web Sites . You will see lists of created Sites.  Right click at the required farm URL.  Choose S e ssion Preference  This window will appeared. Browse to Remote Connnection > Display . You will see the option " Allow users to customize window size " is unchecked . Resolution : Check the option " Allow users to customize window size ", and press OK  Get users to refresh the Web

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, select Customize assessment pr