Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top
  • I created simple plan

enter image description here

  • with my access to Ms SQL Server 2008 R2

enter image description here

  • but job failed with exception

Date 31. 3. 2013 4:00:01 Log SQL Server Agent (Current - 17. 3. 2013 5:00:00)

Message [298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'Xxx\Xxxx', error code 0x2. [SQLSTATE 42000] (ConnIsLoginSysAdmin)

('Xxx\Xxxx' is domain/DNS_Name)

  • with the same exception for another type of jobs, e.g. BackUp

  • I'm able to execute all a.m. events from Management Studio (for example) without any issue

please is there any issue with my access

share|improve this question
Domain controller could't access to your Sql Agent… – Armstrong63 Apr 2 '13 at 9:45
@Armstrong63 should be an accepted answer, autentification from AD for SQL Aggent changed, good catch, thank you – mKorbel Apr 2 '13 at 10:00

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.