Wednesday, February 15, 2012

Event 18454 connection non-trusted

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 !!! HELPpcnetnet,
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" <pcnetnet@.yahoo.com.hk> wrote in message
news:OehfM9RLIHA.5980@.TK2MSFTNGP04.phx.gbl...
> 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
>|||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" <pcnetnet@.yahoo.com.hk> wrote in message
news:OehfM9RLIHA.5980@.TK2MSFTNGP04.phx.gbl...
> 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
>

No comments:

Post a Comment