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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics