03-18-2019 05:32 AM
Hello
I am trying to do a backup of SQL 2014 running on a Windows 2012R2 server, using Backup Exec 2014. I have created a domain level account to do the backups, and added it to the databases with the permission to Connect. I am getting the following error: "V-79-57344-65085 There is a problem running the DBCC The server principal "domainname\accountname" is not able to access the database "tew_app_macro" under the current security context". This error repeates for all the databases. what do I need to do inorder to do the backups using the account I have created? Is there another permission I need to grant the account name in SQL? If I run a test in Backup Exec, with the account name, everything passes.
Thank you for your time
Stephen Keating
Solved! Go to Solution.
03-19-2019 12:58 AM
See if this link helps:
https://www.veritas.com/support/en_US/article.100001916.html#SQL_Agent
03-25-2019 05:23 AM
One additional problem. I am getting an error that the account I created to do the backups cannot perform the database consistency check. What are the steps in giving the account theis permission?
03-19-2019 12:58 AM
See if this link helps:
https://www.veritas.com/support/en_US/article.100001916.html#SQL_Agent
03-20-2019 08:57 AM
Thanks for the info. Now just to be sure I understand, what i need to do is create and account, say "Dave" which will have administrator rights on the server the SQL databases are on, and it must also have admin rights to the databases themselves, in order to do the backups?
03-25-2019 05:23 AM
One additional problem. I am getting an error that the account I created to do the backups cannot perform the database consistency check. What are the steps in giving the account theis permission?