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.
Changing user used to execute scheduled jobs
Hot Topic
- Dataset cannot be generated error
- Clearing cache
- SQL 2000 EM Prob. after 2005 install
- Cannot create a connection to data source
- SSIS Sequence container,data flow task
- PDC CTP
- Problem with Linked Server
- Transaction Log does not truncate and shrink using a SQL Server 2005 Maintenance Plan
- database owners
- SQL DTS
SQL Server
- Restoring DB
- visual studio running too slow
- Report Viewer/Explorer-WebPart missing under SharePoint v3+SQL Server 2005
- DTS package failing with Object required WScript
- Fact table design
- Locating idle sessions using dm_exec_... DMV's
- syscolumns has wrong length for view columns after table is modified
- order by in a view in sqlserver2005
- Am I in the right direction?
- How connect SQL server 2000 with c#.net .....?
Changing user used to execute scheduled jobs
Gogou
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
sk49
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
Dave Corun
Can you copy-paste the full text and the number for the error that you receive
Thanks
Laurentiu