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

1.6k views Asked by At

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?

1

There are 1 answers

1
CRAFTY DBA On BEST ANSWER

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.