Re: 18454 Log message

From: Byron Hynes (bph@byronetta.com)
Date: 10/29/02 

From: Byron Hynes <bph@byronetta.com>
Date: Tue, 29 Oct 2002 10:19:03 -0800

"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

  • Getting to the bottom of MSDE network connection problems ...
    ... but other than that it is MSDE 2000 with sp3a already applied. ... I've finally figured out the connection problems associated with this, ... and it seems the problems are due to Windows XP and not MSDE. ... the enterprise/standard versions of SQL server won't install ...
    (microsoft.public.sqlserver.msde)
  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: asp.net sql trusted connections between machines
    ... > connect to a remote SQL Server instance w/ Read-Write permissions. ... > connection string in the web.config. ... > Windows Authentication setting for access via IIS doesn't seem pass the ... is this impersonation behavior with IIS and Windows Authentication ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Bizzare SQL Network Error
    ... The bizzare thing is that, the same connection string, the same code to ... In a windows APP it works fine, in a Web APP I get ... >>I am trying to connect to a default instance of SQL Server 2000 Enterprise ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Login fails for SQL Server
    ... I am using SQL Server 2005 Express Edition if that matters. ... SQL Server connection." ... the guest account has been disabled by default on Windows ... if you're using Windows authentication you should leave out the User ...
    (microsoft.public.dotnet.languages.csharp)