Sqlbackupandftp the server principal "NT Authority\System" is not able to access the database "XXXX"

Source: Internet
Author: User

An error was encountered while backing up the database using SQLBACKUPANDFTP in Windows Server 2012:

Error:the server principal "NT Authority\System" is not able to access the database "XXXX" under the current security con Text. BACKUP DATABASE is terminating abnormally.

Ways to resolve this error:

Select the "Advanced Backup Schedule" button in the Sqlbackupandftp tool and set the user to perform the schedule job in the "Advanced Backup Schedule" window, as shown below, You can set up your domain account (the sysadmin role) as the user performing the schedule job or any other account that has permissions.

For official information, please refer to around:the server principal "NT Authority\System" are not able to access the database "Database-name" Unde R the current security context

Open the scheduled job with SQLBACKUPANDFTP software and click to "Advanced Backup Schedule" button. At opened ' Advanced Backup Schedule ' window you can enter user name to execute the scheduled job in "Run scheduled job as" field or just click on ' Set as current User/your personal account ' to use Your current Windows account. Remember to save the job to apply new schedule options. Sqlbackupandftp'll ask you to enter your password when you save the job.

References:

http://sqlbackupandftp.com/blog/hot-around-server-principal-nt-authoritysystem/

Sqlbackupandftp the server principal "NT Authority\System" is not able to access the database "XXXX"

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.