NT AUTHORITY\ANONYMOUS LOGON

• Sebastian Stemmet

  SSC Veteran

  Points: 226

  More actions

  June 29, 2005 at 12:39 am

  #152449

  Hi,

  We have this loginid that tries to log in every few seconds and fails and then fills up the Sql Server logs. I have a put on a Trace using Sql Profiler and found that it is a certain ClientProcessId that is trying to login. How do I find out what this ClienProcessId is and where it is coming from?

  Thanks,

  Sebastian

   

   

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  June 29, 2005 at 2:00 am

  #569224

  Please do not cross-post, we monitor all boards.

  Continue the discussion in http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=6&messageid=195074

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/

• Mohammad Sufian

  Ten Centuries

  Points: 1292

  More actions

  June 29, 2005 at 2:25 am

  #569232

  Dear ,

  Try using sp_who stored procedure u will get the information about login name and hostname from where it is coming.

  sorry if it doesnt helps.

  sufian