SQL Server – Maintenance Plan Not Working After Renaming Administrator

maintenance-planssql serverwindows-server

I have renamed the Windows administrator account to TEST using Local Group Policy editor. After that, the SQL Server maintenance plans are not working anymore:

Unable to determine if the owner of job has server access

I have tried methods below but no luck yet:

  1. I have tried to add a login to SQL Server for TEST account, but it says that this login already exists. I can not see the name of TEST in the Login tab, but the administrator exists already

  2. I have deleted the Maintenance plans and created new ones but no change happened

Please let me know if there is another way to connect the Maintenance plans to the new administrator name.

Best Answer

I have solved the problem using SQL Server Management Studio (SSMS):

  1. Expanding Server --> security
  2. Expanding Logins
  3. Right click on administrator account and simply rename it to the new name I have set before in Local Group Policy.
  4. Maintenance plans works fine!
Related Question