• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 174
  • Last Modified:

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?
1 Solution
Scott PletcherSenior DBACommented:
Probably the quickest/easiest way is to try to get in using DAC.

Featured Post

Hire Technology Freelancers with Gigs

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now