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

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

Show quoteHide quote

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.

Show quoteHide quote

Square Brackets
Last Modified Date of table, queries, views, sprocs
SQLDMO with VB6
SQL Profiler won't allow a developer to login
Import data to sql Server 6.5