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.

Posted on 2014-07-16
Last Modified: 2014-07-24
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?
Question by:sbumpas
    1 Comment
    LVL 68

    Accepted Solution

    Probably the quickest/easiest way is to try to get in using DAC.

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now