Post reply

SQL Agent Job Fails when domain user is owner

  • July 30, 2008 at 4:19 pm

    #122782

    I can't execute any jobs with a domain user as the owner. As a work around, I've been using sa as the owner, but for this job it won't work because I have to access some directories on the network and we want to give those permissions to a specific login. Does anyone know what I need to do in order to execute a job with a domain user as the owner?

    Error Message:

    The job failed. Unable to determine if the owner (domain\user.name) of job jobname has server access (reason: Could not obtain information about Windows NT group/user 'domain\user.name', error code 0x5. [SQLSTATE 42000] (Error 15404)).

    Thanks!


    Wendy Schuman

  • July 30, 2008 at 9:33 pm

    #850977

    You can try as follows,

    1. Keep the job owner as sa (sysadmin) and in the job step use xp_cmdshell

    2. Ensure that the Sql Service account has necessary permissions to the folders you wish to access because xp_cmdshell for a sysadmin will run under the context of Sql service account.

    Also please check if this link helps, http://support.microsoft.com/kb/241643/[/url]

    [font="Verdana"]- Deepak[/font]

  • July 31, 2008 at 12:27 pm

    #851466

    Hi Deepak,

    I got it to work as you mentioned by keeping the job owner sa and then giving the necessary permissions to the directories to the SQL Server Agent service account. I didn't need to do anything with xp_cmdshell because the job is actually executing an SSIS package.

    Thanks!


    Wendy Schuman

  • July 7, 2010 at 8:25 am

    #1189645

    The job failed. Unable to determine if the owner (domain\user) of job NAME has server access (reason: Could not obtain information about Windows NT group/user error code 0x54b. [SQLSTATE 42000] (Error 15404)).,00:00:39,0,0,,,,0

    The owner of the job and the step "Run as" accounts were different. Both were admins on the server and had DBO rights to the database. The job consisted of three steps - an OS step, and two SQL queries. It failed to run when the two accounts differed; when they were both the same it worked.

    System is SQL Server 2005 SP3 standard running on Windows Server 2003, with all the latest patches.

  • July 8, 2010 at 5:42 am

    #1190162

    Deepak are you from Cleveland?

  • October 21, 2015 at 12:59 am

    #1834535

    I have the same issue but my job will randomly fail. Fails about 3 times a day and it runs every 30 minutes. What can be the cause of this?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply