Retrieve admin rights on a XenDesktop site

Posted on Posted in Citrix, Troubleshooting

During a site upgrade I forgot to add my admin account in the “Full Administrator” role… Before rolling back to the previous version, I’ve performed some tests and here is the result:

Capture

  • Connect to SQL Server

Retrieve an account with the correct role through the SQL query:

SELECT Administrators.Sid FROM [DAS].[Rights] as Rights,

[DAS].[Administrators] as Administrators,

[DAS].[Roles] as Roles

Where Rights.AdminId = Administrators.Id and Rights.RoleId = Roles.Id

and Roles.Name = ‘Full Administrator’

  • Modify the SID find with the previous query or create a new entry in the table [DAS].[Administrators]

That’s it, you’re now a Full Administrator!

Leave a Reply