你的位置:首页 > 软件开发 > 数据库 > SQLBackupAndFTP The server principal NT AUTHORITY\SYSTEM is not able to access the database xxxx

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

发布时间:2015-12-07 18:00:07
Windows server 2012中使用SQLBackupAndFTP备份数据库时遇到一个错误: ERROR: The server principal "NT AUTHORITY\SYSTEM" is not able to access the dat ...

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的用户或者其他具有权限的账号。

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

官方资料介绍请参考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/


原标题:SQLBackupAndFTP The server principal NT AUTHORITY\SYSTEM is not able to access the database xxxx

关键词:sql

sql
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们: admin#shaoqun.com (#换成@)。