If you have an user account that you would simply like to promote to a host account it is a very simple single SQL Script. This process can be very helpful if you are looking to take for example your personal account and promote it to a host to fix errors. However, you want to be sure that you are careful which account you promote as anyone that would log in with this account after the change will have host permissions!
To update the user account simply run the below script, be sure to put your username in for the username.
SET IsSuperUser = 1
WHERE username = ‘TestUser’