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.
    
    
    
    

Read More