Event Viewer Application Log - Error every 10-15 sec.

• datsun

  SSCrazy

  Points: 2397

  More actions

  September 18, 2019 at 10:51 am

  #3681019

  Hello,

  Our new server Windows 2016 with SQL 2016 on it, is showing an error line every 10-15 sec. on the Event Viewer under Application Log.

  Login failed for user 'NT AUTHORITY\SYSTEM'. Reason: Failed to open the explicitly specified database 'OUR_DATABASE'. [CLIENT: <local machine>]

  How can I find which application is trying to log on to our database using NT Authority?

  Thank you,

  Vinay

   

• Alejandro Santana

  SSCommitted

  Points: 1838

  More actions

  September 18, 2019 at 1:23 pm

  #3681077

  I think you could get the information through Extended Event, try Brent Ozar's "What queries are failing" Extended event.

  https://www.brentozar.com/archive/2013/08/what-queries-are-failing-in-my-sql-server/

  If you need more information i think you could modify the extended event to add what you need.

  Regards,