Event 18454 connection non-trusted

[pcnetnet]

Hi All,
i don't know which problem or setting error ? the event log many many
event on this "18454 Login succeeded for user 'Login1'. Connection:
Non-Trusted " in 3 hours display 10000 record for this ?? how to disable
this option !!! HELP

[Russell Fields]

pcnetnet,

Using SQL Server 2000 Enterprise Manager or SQL Server 2005 Management
Studio (depending on your version), right-click on the server name and
choose Properties.

There is a Security tab (the two versions look different, but have the some
basic functionality) and set either Auditing or Login auditing to the level
you want: None, Failed Only, etc.

Of course, if it is always the same login name, you may want to track down
what is going on there since that is about 1 login a second.

RLF

"pcnetnet" <pcne...@yahoo.com.hk> wrote in message
news:OehfM9RL...@TK2MSFTNGP04.phx.gbl...

[Ekrem Önsoy]

It's a user who connected to your SQL Server instance using SQL
Authentication. If you change your SQL Server Instance' s Authentication
mode to Windows Authentication from the Instance' s Server Properties, then
that user will not be able to connect to your Instance whoever he\she is.

However, consider this well because if you have any other use who use SQL
Authentication to connect to the instance then he'll affected by this change
as well.

--
Ekrem Önsoy

"pcnetnet" <pcne...@yahoo.com.hk> wrote in message
news:OehfM9RL...@TK2MSFTNGP04.phx.gbl...