I am logged into SQL server 2008 R2 as a domain admin. When I try to perform a full backup on the database I get an error.
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?
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.