Hello. I am using SQL Server Management Studio (SQL 2005) and created a daily backup job. Inside the job, i have an "Operating system" step to copy backuped up files onto another directory. However, the job kept on failing with an error "Executed as user ... Access is denied." With this error, how can i change the user used to execute the job? Thanks.
Can you copy-paste the full text and the number for the error that you receive?
Thanks
Laurentiu
Here's the error message:
Executed as user: server\sql2005. Access is denied. Process Exit Code 1. The step failed.
The error occured when it came to the operating system command step. Thanks
This is not a message coming from the server. Looks like it's either coming from management studio or from the job itself. For management studio issues, you should try posting on SQL Server Tools General. You could also take a look at the server log file to see if there is any information there about an error.
Thanks
Laurentiu
