[Studio columns]

It's now August of 2018, and this problem persists.   Having to select the columns one wants every time Citrix Studio is launched is frustrating and primitive.   It's also difficult to explain to customers that have switched from the old XenApp 6.5 and earlier versions why the Citrix Studio console is so bad compared to previous versions of XenApp.   Saving the columns is just one thing, but I have an entire laundry list of items - things like being unable to show the session idle time in Citrix Studio (you have to use Citrix Director to see this), and where is the auto-refresh of user data?    XenApp/XenDesktop 7 has been out for YEARS, and the yet the Citrix Studio console is still playing catch-up.   I know it's a different architecture.   I know it's doing both XenApp AND XenDesktop, and I appreciate the difficulties, but from the customer's point of view, if all you've ever known is XenApp, Citrix Studio is just plain awful to work in for basic XenApp management, day in and day out, and Citrix Director is not much better, when compared to the management consoles for previous versions of XenApp.    Sorry to go on and on with a diatribe - but this one's been cooking for a couple of years now.

[XenApp 7.6 - Can't login into Studio anymore]

In my situation, I had just finished building a brand new XenApp/XenDesktop 7.6 installation, but had not yet added any additional administrators to the site.    Then someone deleted my active directory user account.   My account was then recreated, but of course, it then had a different SID.   Launching Studio with the new account/SID would produce this error in Studio:

 

Error Id: XDDS:F393C75A

 

Studio then fails to work properly.

 

The fix (with thanks to those who have posted on this above), is to change the admin account SID information in your site/farm database.    

 

Start by finding the SID of the account you need to give access to.   You can run this command on any domain-joined server.  Replace "USER" with the account name you need to give access to.

 

wmic useraccount where name="USER" get sid

 

Sample output from above command:

 

S-1-5-21-378302919-25780524-620655208-9821

 

Next steps:

 

1)  Log into the SQL server where your database is stored with an account that has rights to your XenDesktop farm database.

2)  Open SQL Server Management Studio

3)  Click on Databases -> click on your database name -> click Tables

4)  Scroll down to the DAS.Administrators table, right click, -> Edit Top 200 Rows

5)  In the row edit window,  replace the old SID with the new SID of the account you want to give admin rights to.

6)  Close the edit window, and then reboot your XenApp/XenDesktop delivery controllers.

7)  Sign into your delivery controller with the new account, fire up Studio, and you should be good to go.