代码改变世界

SQLBackupAndFTP The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "xxxx"

  潇湘隐者  阅读(2030)  评论(2编辑  收藏  举报

Windows server 2012中使用SQLBackupAndFTP备份数据库时遇到一个错误:

ERROR: The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "xxxx" under the current security context. BACKUP DATABASE is terminating abnormally.

解决这个错误的方法:

    在SQLBackupAndFTP工具里面选择“Advanced backup schedule”按钮,在“Advanced Backup Schedule” 窗口设置执行Schedule Job的用户,如下截图所示,你可以设置你的域账号(sysadmin角色)做为执行Schedule Job的用户或者其他具有权限的账号。

clipboard

官方资料介绍请参考Hot to around: The server principal “NT AUTHORITY\SYSTEM” is not able to access the database “database-name” under the current security context

Open the scheduled job with SQLBackupAndFTP software and click on “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. Please remember to save the job to apply new schedule options. SQLBackupAndFTP will ask you to enter your password when you save the job.

 

参考资料:

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

编辑推荐:
· 一个费力不讨好的项目,让我损失了近一半的绩效!
· .NET Core 托管堆内存泄露/CPU异常的常见思路
· PostgreSQL 和 SQL Server 在统计信息维护中的关键差异
· C++代码改造为UTF-8编码问题的总结
· DeepSeek 解答了困扰我五年的技术问题
阅读排行:
· 一个费力不讨好的项目,让我损失了近一半的绩效!
· 清华大学推出第四讲使用 DeepSeek + DeepResearch 让科研像聊天一样简单!
· 实操Deepseek接入个人知识库
· CSnakes vs Python.NET:高效嵌入与灵活互通的跨语言方案对比
· Plotly.NET 一个为 .NET 打造的强大开源交互式图表库
历史上的今天:
2013-12-07 SQL SERVER修改排序规则——脚本篇
点击右上角即可分享
微信分享提示