Home Forums SQL Server 2005 SQL Server Express Another Error 18456 RE: Another Error 18456

  • June 8, 2012 at 2:36 am

    #1498560

    govindarajan69 (6/8/2012)

    Hi,

    I am also getting this error Error: 18456, Severity: 14, State: 8. + Login failed for user 'sa'. [CLIENT: 192.168.4.52], but the user is not accessing SQL Server directly. No application is configured with sa credentials.

    is there anyway we can trace his pc and find out what is making connections to SQL Server directly?

    Please suggest.

    Regards

    Govind

    run a profile trace, blank template, then select failed login attempt from the security audit section of the event selections tab, bingo, you get to see whats trying to login