Forum Discussion

Stephen_Keating's avatar
Stephen_Keating
Level 4
7 years ago
Solved

Unable to backup SQL 2014 database

Hello

I have added a database to an existing SQL 2014 server, running on Windows 2012R2. I already have an account setup on the domain to do the Backup Exec accounts, and it works for the current SQL database, but not the new one. I am getting the following issues:

 There was a problem running the DBCC.
The server principal "domain\user account" is not able to access the database "tew_app_data" under the current security context

The domain\user account is the one used for BackupExec backups, and passes the test for backing up the databases.

Where do I need to go in SQL and what box needs to be checked, so that I can run the DBCC?

2014
Windows Server 2012 R2
  • Marianne's avatar
    Marianne
    7 years ago

    Please work with your DBA to see what is different with the new database.
    Best to use SQL DBA credentials for the user account that you add in BE for SQL backups.

    DBA does not need to share password with you - ask him/her to type in the password during the config. 
    Else, if new user is created, work with SQL DBA to confirm the required permissions at OS and SQL level. 

2 Replies

Sort By
  • Marianne's avatar
    Marianne
    Level 6
    7 years ago

    Please work with your DBA to see what is different with the new database.
    Best to use SQL DBA credentials for the user account that you add in BE for SQL backups.

    DBA does not need to share password with you - ask him/her to type in the password during the config. 
    Else, if new user is created, work with SQL DBA to confirm the required permissions at OS and SQL level.