Login failed for user ''NT

• sqlstar2011

  SSCertifiable

  Points: 6000

  More actions

  April 19, 2006 at 7:34 am

  #152918

  I am getting following error message in the sql server 2000 error logs every 2 minutes.

  Login failed for user 'NT

  AUTHORITY\SYSTEM'

  'NT

  AUTHORITY\SYSTEM'  is not part of sysadmin. but I have read that if I set search service to

  domain account that run sql server problem will be resolved. How do I set search service to domain account that runs sql server?

   

  thanks

• raj-247939

  SSCertifiable

  Points: 5999

  More actions

  April 20, 2006 at 1:50 am

  #633179

  Map use SQL Login to Authority\system Account.

  from

  Killer