Post reply

Proxy account not being used

  • January 14, 2015 at 8:47 am

    #314557

    Hi

    I have a frustrating problem where I am using the Ola Hallengren jobs to backup to a network share. (This isn't something specific to his scripts).

    For various reasons the SQL Server account can not be granted access to the share so I thought I would use a proxy account which does have access (this has been fully tested). I am using a CmdExec proxy.

    The problem comes now that when I run the job it still thinks access is denied when running the xp_create_subdir command.

    When I recreated this problem locally on my machine, as soon as I add the SQL Server account access to the share the backups work, so why isn't the job using the proxy account?

    Thanks

  • January 14, 2015 at 8:55 am

    #1770153

    If I remember correctly, the job will still run in the context of the SQL Server Agent service account if the job owner is a member of sysadmin. Is that the case here?

    John

Viewing 2 posts - 1 through 1 (of 1 total)

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