Take the 2-minute tour ×
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. It's 100% free, no registration required.
  • 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
2  
Domain controller could't access to your Sql Agent stackoverflow.com/questions/1234570/… –  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

 
discard

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

Browse other questions tagged or ask your own question.