Im trying to run a sql backup but when i kick off a backup from the sub client i get the error:
Sql backup: failed to impersonate error: Account restrictions are preventing this user from signing in
The troubleshooting steps are to:
- impersonate user
-grant this user a login with sysadmin on sql server
-add this user to the admins group on the slq server windows machine.
I have done that and still get the above error. There are no details in the windows logs or sql logs so i am unsure what to try next. appreciate any help.