Login failed for user 'sa' over and over again

From: d6m7 (d6m7_at_discussions.microsoft.com)
Date: 01/03/05 

Date: Mon, 3 Jan 2005 00:25:04 -0800

I have a SQL Server 2K with ver. 8.00.818 and already installed the fix for
KB 826161. I checked event viewer and trace the activity using the sql
profiler and i received the following logs every 500 milliseconds;

Event ID: 17055 Category: (4) Description: 18456 : Login failed for user 'sa'
Event ID: 17055 Category: (4) Description: 18454 : Login succeeded for user
'sa'. Connection: Non-Trusted.

How can i prevent this and how to determine the source of this connection
where the hostname from the trace file is blank?

Thanks.

Relevant Pages

  • Re: One Web Service updates SQL, another cant?
    ... Columnist, SQL Server Professional ... I guess its because this is my first Web Service and I ... it opens the database connection. ... See what that gives you in the trace. ...
    (microsoft.public.sqlserver.security)
  • Re: Odd connection issue - (yes Im running in mixed mode authentication)
    ... the ASP.NET app is connecting to SQL server. ... Select File -> New -> Trace to create a new trace. ... connection string to see if it works. ... "This posting is provided "AS IS" with no warranties, ...
    (microsoft.public.dotnet.framework.adonet)
  • SQL Profiler beginner
    ... type of connection? ... Authorisation or SQL Server connections then the counter ... for the trace has not been put on. ... Winston Churchill ...
    (microsoft.public.sqlserver.server)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)