Retrieve admin rights on a XenDesktop site

Posted on Leave a commentPosted 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: 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 […]