Home Forums SQL Server 2012 SQL 2012 - General Force T-SQL Job Step to Run Under Specific SQL Account RE: Force T-SQL Job Step to Run Under Specific SQL Account

  • May 22, 2015 at 10:11 am

    #1800075

    SQLKnowItAll (9/26/2013)

    So... I set this up and now I keep getting an error on the step:

    Executed as user: new_user. The server principal "new_user"

    is not able to access the database "userdatabase1" under the current security context.

    [SQLSTATE 08004] (Error 916). NOTE: The step was retried the requested number of times (3) without succeeding.

    The step failed.

    NOTE: This user is sysadmin. I have also tried adding the user as db_owner to all user databases and still get this error... Any thoughts?

    I had to give user explicit public role to master database even if the user is sysadmin, after this it worked.