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

简介:

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.

  

相关文章
|
SQL 关系型数据库 MySQL
云服务器 ECS产品使用问题之出现“1044 - Access denied for user ‘root‘@‘%‘ to database ‘数据库名称‘”这样的错误,该怎么办
云服务器ECS(Elastic Compute Service)是各大云服务商阿里云提供的一种基础云计算服务,它允许用户租用云端计算资源来部署和运行各种应用程序。以下是一个关于如何使用ECS产品的综合指南。
|
安全 关系型数据库 MySQL
openvas报错Warning: Secinfo Database Missing SCAP and/or CERT database missing on OMP server.
openvas报错Warning: Secinfo Database Missing SCAP and/or CERT database missing on OMP server.
数据库bug-[08001] Could not create connection to database server. Attempted reconnect 3,主机名ip必须写对
数据库bug-[08001] Could not create connection to database server. Attempted reconnect 3,主机名ip必须写对
|
SQL Oracle 安全
Oracle Database Vault Access Control Components
Oracle Database Vault Access Control Components
322 0
|
SQL 机器学习/深度学习 人工智能
全球名校AI课程库(11)| CMU卡内基梅隆 · 数据库系统导论课程『Database System』
数据库方向的专业课程,详尽介绍了数据库的基本知识、底层原理、效率优化、查询优化、新数据库等,是数据库管理系统设计与实施方向的权威好课。
2619 1
全球名校AI课程库(11)| CMU卡内基梅隆 · 数据库系统导论课程『Database System』
|
关系型数据库 MySQL PHP
解决typecho出现“Database Server Error”错误
解决typecho出现“Database Server Error”错误
333 1
解决typecho出现“Database Server Error”错误
|
数据库
Could not create connection to database server. Attempted reconnect 3 times. Giving up.
Could not create connection to database server. Attempted reconnect 3 times. Giving up.
572 0
|
Java 关系型数据库 MySQL
报错:java.sql.SQLNonTransientConnectionException: Could not create connection to database server
报错:java.sql.SQLNonTransientConnectionException: Could not create connection to database server
4173 0
报错:java.sql.SQLNonTransientConnectionException: Could not create connection to database server
|
关系型数据库 MySQL PHP
解决typecho出现“Database Server Error”错误
解决typecho出现“Database Server Error”错误
739 0
解决typecho出现“Database Server Error”错误
|
SQL 缓存 算法
Access Path Selection in a Relational Database Management System
如果说选一篇在优化器框架上,被引用次数最多的文献,应该非这篇论文莫属了,还记得Andy Pavlo在cmu的课程中提到IBM Research的一群大神们,是怎么一人一个模块来负责System R的设计的,而关于Join order enumeration,Selinger可以说是开创了dynamic programing based 的bottom-up的搜索空间算法的先河,直至今日,很多成熟的商业或开源数据库系统仍在沿用这套框架,比如Oracle / DB2 / PostgreSQL ...
933 0
Access Path Selection in a Relational Database Management System

热门文章

最新文章