Search code examples
sql-serveruser-accountssql-agent-jobsid

SQL Server Agent job step - changing the name of the "run as" account

If I change the name of the AD user account that is setup as the "Run as" account for the step of an SQL Server Agent job, do I need to update the "Run as" property of the step? Or will it still work using the SID of the account?

Solution

  • I usually do not rename accounts, so it is a good question.

    Does the AD account still work as a login for SQL Server?

    Do you still have access to the database as a user?

    What type of job step are you running?

    Answers to these questions will help you/me figure it out.