2

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.

1

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!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.