Results 1 to 4 of 4

Thread: Login failed for user 'NT AUTHORITY\SYSTEM'

  1. #1
    Join Date
    Sep 2002
    Posts
    159

    Login failed for user 'NT AUTHORITY\SYSTEM'

    Hi ,
    every day I see error in log file
    Login failed for user 'NT
    AUTHORITY\SYSTEM'

    error happen at 02:00 daily

    1. BUILTIN\Administrators Login Is
    Removed from server

    2. SQL server and agent running under
    domain account with local admin
    authrities

    3. full-text population job running every day at
    02:00 ,last 1 second and run
    succesfuly

    I read
    http://support.microsoft.com/default...b;en-us;295034

    Since full-text run succesfuly what could be the problem ?


    Thank
    Alex

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Did you add 'NT AUTHORITY\SYSTEM' into sysadmin? If not, full-text indexing will not work properly since you removed BUILTIN\Administrators from sysadmin.

  3. #3
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Change mssearch service account to a domain account with sa privilege in the server.

  4. #4
    Join Date
    Sep 2002
    Posts
    159
    thank everybody for help

    Both sugestions work perfrectly

    Day 1
    added login AUTHORITY\SYSTEM' and
    made it 'SA'
    full text search run ok , no more
    errors in log file

    Day 2
    Droped login AUTHORITY\SYSTEM'
    set search service to
    domain account that run sql server

    full text search run ok , no more
    errors in log file

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •