The error message is:
System.Data.SqlClient.SqlError: The server principal "mydomain\myusername" is not able to access the database "ProvisioningServices" under the current security context. (Microsoft.SqlServer.Smo)
It appears I need to add the sysadmin role to my login in Sql Server Management Studio to perform a backup. To add the role to my login, I think I need to login to SQL Server Management Studio as 'sa'. Unfortunately, the password for 'sa' has been lost.
What are the best options for adding the sysadmin role to my SQL Server login and for recovering or changing the lost 'sa' password?