Login failed for user


  • I am getting the below error in SQl server error log for every 15 min. I ran profiler to  find out what database it is trying to access, found that it is trying to access master.

    I am getting this error because I removed NT AUTHORITY\SYSTEM from SYSADMIN group because all my SQl server services are running with domain account and i don't want to give SYSADMIN for that account, is there any way that we can eliminate the error.

    Login failed for user 'NT AUTHORITY\SYSTEM'. Reason: Failed to open the explicitly specified database. [CLIENT: xx.xx.xx.xx]

    Error: 18456, Severity: 14, State: 38.

    Thursday, July 17, 2014 4:48 PM


All replies