Re: 18454 Log message

From: Hyung W. Rhoe (hrhoe@hotmail.com)
Date: 10/30/02 

From: "Hyung W. Rhoe" <hrhoe@hotmail.com>
Date: Wed, 30 Oct 2002 05:46:17 -0800

Thank you Byron,
So, I don't need to worry about this log messages, i guess.
But still I don't understand why only this server
shows those log messages.
We have 6 other servers for the different clients,
and clients connect server via T1 line and
they use SQL Server logins.
The thing is only this server has these messages.

I'll research other sources more.
Thank you for your advice.

>-----Original Message-----
>"hrhoe" <hrhoe@hotmail.com> wrote (29 Oct 2002):
>
>> Hi,
>> Recently, I've seen a lot of following sql server
>> log messages.
>> -------------------------------------------------------- 

---
>> "Login succeeded for user 'sql_user_name'. 
Connection:Non-
>> Trusted.
>> --------------------------------------------------------
---
>> This messages repeatedly appear multiple times even 
within 
>> a second.
>> Does this mean some non-trusted user successfully 
>> connected to our server?
>
>It means that the connection was not made using Windows-
based security 
>(including the trust relationships from clients to 
servers that Windows 
>Authentication requires).
>
>>From the Books On Line glossary:
>
>trusted connection
>A Windows network connection that can be opened only by 
users who have 
>been authenticated by the network. The users are 
identified by their 
>Windows login ID and do not have to enter a separate SQL 
Server login 
>ID.
>
>See also: Windows Authentication
>
>Windows Authentication
>One of two mechanisms for validating attempts to connect 
to instances of 
>SQL Server. Users are identified by their Windows user or 
group when 
>they connect. Windows Authentication is the most secure 
mechanism for 
>connecting to SQL Server.
>
>See also: SQL Server Authentication, trusted connection
>
>
>
>
>
>
>-- 
>----------------------------------------------------------
-------
>Byron P Hynes
>
>"He who exercises government by means of his virtue may 
be       
>compared to the north polar star, which keeps its place 
and      
>all the stars turn towards it." --
Confucius                      
>----------------------------------------------------------
-------
>.
>

Relevant Pages