May 4, 2006 at 10:52 am
Hi,
I have SQL 2005/Windows 2003. Scheduled a backup job to run through SQL Agent, an error encountered:Message
Executed as user: xxx\yyyy. Access is denied. Process Exit Code 1. The step failed.
I gave all rights to server roles/user mapping (databases that needs to be backup). Do I miss anything else? Thanks.
Chris
May 4, 2006 at 12:00 pm
I found that i had problems similar to that after my initial install. To correct the problem I installed the SQL Server Integration Services. There was some functions of the backup job I was using which were enabled only after SSIS was installed.
May 4, 2006 at 10:17 pm
Does the user specified by xxx\yyyy have write access to where the backup file is being written to on the file system / network share?
K. Brian Kelley
@kbriankelley
May 5, 2006 at 12:16 pm
What is in the SQL Server errorlog ? Usually there is some information there is it relates to permissions of the fact that there is not enough disk space.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
May 5, 2006 at 12:26 pm
Hi,
Thanks for help from all og you. The exact error message in SQL Agent step 2:
Date 5/3/2006 5:01:43 PM
Log Job History (XXXRunJobFE64F7A3-882B-4989-8D9E-5811762F0D5B)
Step ID 1
Server XXXXXX
Job Name XXXRunJobFE64F7A3-882B-4989-8D9E-5811762F0D5B
Step Name 1
Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: XXXXX\yyyy. Access is denied. Process Exit Code 1. The step failed.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply