February 12, 2009 at 8:58 am
When running a job to restore a database by retrieving a backup file from a different server, the job fails with this error: Cannot open backup device '\\Server\d$\Folder\database.bak'. Operating system error 5(Access is denied.).
The job is owned by my dba profile, which also has full control of the folders both on the source and destination servers.
Our server admin agrees that this is unusual, and has verified that my dba profile should have access to all objects.
Thanks for any suggestions.
February 12, 2009 at 12:30 pm
Even though you are the owner of the job but the process that kicks of the job is SQLAgent service. I think it is not able to access that folder on the server so it is failing. To confirm this is true run a native backup from a query and see if it works
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
February 12, 2009 at 1:08 pm
As mentioned, the Agent account, and the SQL service accounts, are used to often run things from the server. when you submit something from SSMS, it's running under the service accounts, not your account. The "server" does the work.
February 12, 2009 at 2:23 pm
what security context is the agent running under?
local system, domain account, local user, etc
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply