RE: Login failed for user 'sa'.

From: Babu (Babu_at_discussions.microsoft.com)
Date: 08/23/04 

Date: Sun, 22 Aug 2004 15:09:02 -0700

Its seems some more servies are still using the SA login.. check all the
services & jobs which might use sa account

Babu

"Gordzilla" wrote:

> SQL was running along fine. Changed the service account from local system
> to a Domain user account using Enterprise Manager.
> Everything worked fine and all databases are accessible. However, my event
> log is filling up with the following every 6 seconds:
>
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (4)
> Event ID: 17055
> Date: 8/20/2004
> Time: 10:47:47 PM
> User: N/A
> Computer: XXXX
> Description:
> 18456 :
> Login failed for user 'sa'.
>
> Any ideas?
> SBS2000 box running all service packs including SQL SP3
>
>
>

Relevant Pages

  • Re: [opensuse] Restricting who can login when using AD Authentication
    ... anyone with a domain user account can login ... did you mean to say" anyone with a domain user account ... For a windows client in most cases a temporary account was created on ...
    (SuSE)
  • Re: Why does SQL allow sp_grantdbaccess without login?
    ... But what if the domain user account does not belong to ... any of the domain groups with a login? ... > an individual login. ...
    (microsoft.public.sqlserver.security)
  • Re: Remote Desktop to Vista Client
    ... There is no entry for the DomainName\User account. ... Login with the local account, right click on 'computer | Manage' and select 'Local Users and Groups'. ... It was because it was using the local user account instead of the domain user account. ...
    (microsoft.public.windows.server.sbs)
  • Weakness introduced by denying remote logins on AIX, possibly others
    ... AIX 4.3.3 and AIX 5.1, ... is possible to remotely enumerate the passwords of a known AIX account. ... believed to be in the response from the login program after authentication ... Give accounts that have been restricted from remote logins strong passwords. ...
    (Security-Basics)
  • Re: Please! Doesnt anyone know a better way to do this?
    ... account, they need to automatically be directed to the page to enter data ... session variable on the Account page. ... I assume here that you're checking a database when the user attempts to ... When a new user attempts to login or clicks to register, ...
    (microsoft.public.dotnet.framework.aspnet)