Home Forums SQL Server 2014 Administration - SQL Server 2014 SQL back Job is failing RE: SQL back Job is failing

  • May 28, 2016 at 12:11 pm

    #1881927

    ramana3327 (5/27/2016)

    Hi,

    I created a maintenance plan for backup. The job is failing with the error

    The job failed. The owner (TestUser) of job MaintenancePlan.Subplan_1 does not have server access.

    The TestUser has sysadmin but that is domain account.

    After changing the job owner to sa the job ran successfully.

    We already applied the latest service pack SP1.

    Any idea why the job is failing even the user has sysadmin permissions?

    Just because the user has SA permissions, doesn't mean the user has the necessary privs to the disks/folders where the backups are. SA privs have little to do with operating system privs.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)