March 3, 2015 at 9:15 am
I am trying to start a maintenance plan on a Server 2008 R2 server and its giving me an access denied message, but I can start a manual backup and it works just fine. Here is the error I'm getting:
"Executing the query "BACKUP DATABASE [RMS_VEGAS] TO DISK = N'\\\\pulizlvnas\\rmsvegas\\\\RMS_VEGAS_backup_201503022300.bak' WITH NOFORMAT, NOINIT, NAME = N'RMS_VEGAS_backup_20150302230002', SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "Cannot open backup device '\\\\pulizlvnas\\rmsvegas\\\\RMS_VEGAS_backup_201503022300.bak'. Operating system error 5(Access is denied.).
BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly."
Any help would be great.
Thank you.
March 3, 2015 at 9:23 am
It's a security issue. The account that the maintenance plan is running under does not have the relevant authority for that drive, but the account you run under does.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
March 3, 2015 at 9:31 am
Hm...that would make sense. I am logged in using the Administrator account. The job runs under the SA account. Where can I change the login info for the job?
March 3, 2015 at 9:38 am
It depends. If the login running the job has sysadmin authority, the job will run as the SQL Server Agent service account. If not, the job will run using the proxy account for that job step.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
March 3, 2015 at 9:42 am
I actually created a secondary connection using the local Admin account and it seems to be running fine now. Thanks for your help!
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply