1

Want to find cause of recurring failed SQL Server 2005 login attempts

view story
linux-howto

http://serverfault.com – I've been noticing recurring failed logon attempts onto our SQL server. It happens every minute with the same login. An example from the log file viewer 10/18/2011 13:54:50,Logon,Unknown,Login failed for user 'LOLZOR\lolsqlserver'. [CLIENT: ] 10/18/2011 13:54:50,Logon,Unknown,Error: 18456 Severity: 14 State: 16 State 16 means: Login valid, but not permissioned to use the target database Note that the credentials are also used to start all the SQL Server services Audit Login Failed NTDomainName>LOLZOR Error 18456 HostName EU_LOLWEB1 SPID">71</Column> SessionLoginNa (HowTos)