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 new entry in the table [DAS].[Administrators]
That’s it, you’re now a Full Administrator!