SQL Agent won't run under account

Question

I am trying to copy a database, and I can't get SQL Server Agent to run a job. It always errors with 'Unable to determine if the owner ([MYDOMAIN/My Username]) of job [jobname] has server access. (reason: Could not obtain information about Windows NT group/user '[MYDOMAIN/My Username]' error code 0x54b [SQLSTATE 42000] [Error 15404)).' -- I have tried creating a Credential of my domain/username and a proxy that uses that credential. I have tried creating a local computer user with Administrator access, and subsequently a credential and proxy with that account. It always wants to use my domain/username instead. -- All administrators have network access. I am an administrator of my computer. -- I don't understand how my account can't run a SQL Server Agent job when I'm already logged in, and I'm listed as an Administrator to my computer. -- When creating a credential or proxy, if I use the advanced properties to search for a credential, it only shows local accounts to the computer, and never my logged-in domain credentials. However, when I set the proxy to a local account with administrator access, that account is not used to run the job!

Answer 1

Ugh... So the problem is apparently, the Copy Wizard doesn't assign the correct SQL Agent proxy regardless of having set it to use the account you want... After the wizard fails, (if you run immediately), or after you "schedule" the Copy job, go to the Object Browser in SSMS->SQL Agent->Jobs and view the properties of your job, and change the owner to the user you want the job to run under, and then run the job. ... Also, be sure to add your user as a SQL Server Login AND add your login/user to the sysadmin server role.