Date parsed: 19/10/2007 07:00:32
Date: Fri, 19 Oct 2007 14:00:32 -0700

On Oct 19, 3:22 pm, "Russell Fields" <russellfie...@nomail.com> wrote:
> Joanne,
>
> http://technet.microsoft.com/en-us/library/ms366351.aspxsays that the
> password is invalid. So, probably there is nothing wrong with your 'sa'
> account, but someone is pounding away at logging in with the wrong password.
>
> This could be some legitimate (in that your organization approved it) code
> that was written to login as 'sa' but the password it has no longer matches
> the real password. (If this is the case, this application probably needs to
> run under a different account.) Or... It could be a person or process
> trying to break in.
>
> In any case, you need to find out where these failed logins are coming from
> and resolve it. My SQL Server 2005 server at least reports the IP address
> of the failed login attempt. Running SQL Trace from Profiler should also
> let you see where the failures are coming from.
>
> Once you know what is happening then you can decide what to do.
>
> RLF
>
> "Joanne M." <joanne.e.maho...@gmail.com> wrote in message
>
> news:1192819616.670229.15520@e34g2000pro.googlegroups.com...
>
>
>
> > This applies to SQL Server 2005
>
> > I having a problems with error message 18456. I am getting a
> > continious error 18456 severity 14 state 8 with user sa. I can log
> > into the sql server mgt studio as sa. I did see an error earlier today
> > that said that the user 'sa' was locked out. How can that be? I went
> > into Mgt Studio as Network Auth can changed the sa password to what I
> > thought it was already. The event log records this error approx every
> > 4 seconds or so.
>
> > Any help you can provide is appreciated.
>
> > Joanne Mahoney- Hide quoted text -
>
> - Show quoted text -

What should the log on properties be in MSSQL Properties tab in MS SQL
Configuration Manager? "Built in Account" or "This Account"? Perhaps
it is that? It would make sense that it is set up incorrectly ( by
me!)

Joanne