SQL Server Agent Job - Fails - Owner doesnt have server access
I have created a SQL Server Agent Job to execute a SSIS package which I have deployed in my machine.
When I run the job I get the following error:
Message
The job failed. Unable to determine if the owner (mylogin) of job JobName has server access (reason: Could not obtain information about Windows NT group/user 'mylogin', error code 0x5. [SQLSTATE 42000] (Error 15404)).
SQL Server 2008 R2 was installed recently on my machine. I have included mylogin where ever necessary (Login,Credentials) and given all the rights.
Also pls note that, the job is run using a different proxy created for this purpose. So its like a job runs with different proxy but the owner is me.
Can somebody solve this?
Thanks in Advance.
April 26th, 2011 8:05am
This is because the Active Directory synchronization has not happened yet, or the AD (domain controller) was/is not available.
So to recover I suggest you restart your machine and make sure the accounts are valid and active.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
April 26th, 2011 9:41am