Renamed Administrator account, jobs now failing

• 
  Have you updated the owner of the SQL Server Agent job that performs the backup task?
  
  Thanks.

  petey October 11, 2009 02:48

  - 0 +
• 

  petey wrote:

  Have you updated the owner of the SQL Server Agent job that performs the backup task?
  
  Thanks.

  
  The owner of the job is still MYSERVERNAME\Administrator and if I browse user objects, only the old MYSERVERNAME\Administrator user name is selectable -- the renamed admin user is not in the list.
  
  Restarted SQL Server Agent hoping it might refresh the list, it did not.
  
  Also noticed I am not being notified via email of job failure even though I specified this in the Red Gate GUI.

  paule123 October 11, 2009 10:46

  - 0 +
• 
  Which account is being used to run the SQL Server Agent service?
  
  As regards e-mail notification, SQL Backup only sends e-mail notifications on the backup/restore tasks that it performs. If the SQL Server Agent job itself fails to run, SQL Backup hasn't even had the chance to start, hence there is no e-mail notifications sent by SQL Backup. In these cases, you will need to use the SQL Server alert mechanisms.

  petey October 11, 2009 11:15

  - 0 +
• 
  SQL Server Agent is being run under a separate user account. I tried adding this user to the Administrators group, but the job still fails.

  paule123 October 11, 2009 11:17

  - 0 +
• 
  If you were to create a new SQL Server Agent job, are you able to select the new account as the owner of the job?
  
  Thanks.

  petey October 11, 2009 12:21

  - 0 +
• 
  Not exactly, strange behavior here... when creating a new job, the owner name is filled in with the correct renamed administrator user name. However if I go back in to view the job's properties, the job owner name has reverted back to the standard "Administrator" user name.
  
  Edit: Suggestion from another poster on MS TechNet SQL Server forum was to make the job's owner "sa" ... I did this and now the job is successful.

  paule123 October 11, 2009 14:16

  - 0 +
• 
  Instead of using "sa" to run the job, here is another solution:
  
  ALTER LOGIN [domain\old_administrator_name] WITH NAME = [domain\new_administrator_name]

  paule123 October 12, 2009 12:03

  - 0 +

Add comment

Please sign in to leave a comment.