Post reply

renaming SA account caused SQL Server Agent Jobs to fail

  • June 17, 2010 at 9:49 am

    #139467

    I renamed our SA account (lets just say to SA2 as an example) but now the SQL

    Server Agent jobs fail, even though they show the new name SA2 as the owner.

    The failure message states that "the owner sa does not have server access".

    I don't know why this is happening since the job properties now reflect that

    the owner is SA2.

  • June 17, 2010 at 11:55 pm

    #1181933

    Even though your jobs reflect the new name, did you change the run as account as well?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

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

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