Deleted AD Accounts

• DrStrangepork

  Mr or Mrs. 500

  Points: 520

  More actions

  July 19, 2010 at 10:22 am

  #237800

  I have errors like this in my SQL Agent log:

  -----

  Date6/29/2010 4:00:00 AM

  LogSQL Agent (Current - 6/29/2010 4:00:00 AM)

  Message

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

  -----

  Yes, the 'charlie' account was deleted recently, but obviously it is still being referenced somewhere within the database. How can I track down was is trying to use the 'charlie' AD account?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734418

  More actions

  July 19, 2010 at 12:35 pm

  #1195069

  Look in these areas:

  - logins

  - agent jobs

  - packages

  - linked servers