Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sharon911
Starting Member
46 Posts |
 Posted - 2010-07-07 : 14:37:51
|
| Hi,I have encountered a weired issue with the backup setup in sql server, when I tried to run the backup jobs from agent, I got following error:Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account. The step failed.The agent service account does have SYSADMIN role in both database and os domain, and so does the job owner.I have the same jobs running on producion servers with no issues.What could be wrong here?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Sharon911
Starting Member
46 Posts |
Posted - 2010-07-07 : 15:47:19
|
| I got the error when I tried to run it from SSMS agent job list. It will be run tonight from scheduler, see if we get any luck.Thanks for your quick reply. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Sharon911
Starting Member
46 Posts |
Posted - 2010-07-08 : 11:30:55
|
| Still no luch, the same error reported in scheduler(SSMS agent jobs).I am wondering the required SYSADMIN role is from OS level or database level? From database side, I am sure both my login(job owner) and agent service account have been granted SYSADMIN role. From os/domain side, our system administrator verified both accounts have admin role as well..Any advice?Thanks, |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sbglobal
Starting Member
4 Posts |
Posted - 2010-07-18 : 08:49:49
|
| we are also getting same issue. We can not get backup from sql server remotely at local system. |
|
|
|
aravindt77
Posting Yak Master
120 Posts |
Posted - 2010-07-21 : 07:10:15
|
| Check for any folder permission issue where the backup copied to the local system from the remote sql server |
|
|
|
|
|
|
backup run issue