[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [ISSForum] MS-SQL server non-trusted & trusted connection successful



Constantinos,

Please see this reference from Microsoft; the relevant portion is pasted
just below the link:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/archite
c/8_ar_cs_79kj.asp

When you connect, the SQL Server 2000 client software requests a Windows
trusted connection to SQL Server 2000. Windows does not open a trusted
connection unless the client has logged on successfully using a valid
Windows account. The properties of a trusted connection include the
Windows NT and Windows 2000 group and user accounts of the client that
opened the connection. SQL Server 2000 gets the user account information
from the trusted connection properties and matches them against the
Windows accounts defined as valid SQL Server 2000 logins. If SQL Server
2000 finds a match, it accepts the connection. When you connect to SQL
Server 2000 using Windows 2000 Authentication, your identification is
your Windows NT or Windows 2000 group or user account.

The Microsoft Windows Me and Windows 98 operating systems do not support
the server side of the trusted connection API. When SQL Server is
running on Windows Me or Windows 98, it does not support Windows
Authentication. Users must supply a SQL Server login when they connect.
When SQL Server is running on Windows NT or Windows 2000, Windows Me,
Windows 8, and Windows 95 clients can connect to it using Windows 2000
Authentication.

-Mike 

-----Original Message-----
From: issforum-bounces@xxxxxxx [mailto:issforum-bounces@xxxxxxx] On
Behalf Of Constantinos Constantinou
Sent: Thursday, November 03, 2005 2:17 AM
To: issforum@xxxxxxx
Subject: [ISSForum] MS-SQL server non-trusted & trusted connection
successful

Dear all,

 

   I have noticed "Microsoft SQL Server non-trusted connection
successful" and "Microsoft SQL Server trusted connection successful"

Which connections are considered as trusted and which are considered as
non-trusted?

Best Regards,

Constantinos Constantinou
Systems Security Engineer

Odyssey Consultants Ltd

*****************************************************************

1st Floor, Acropolis Avenue & Lefkos Anastasiades 1 (Corner)

2012 Strovolos, Nicosia, Cyprus

*****************************************************************


Phone: +357 22463600, Direct Phone: +357 22441507 Fax: +357 22463563
Email: cconstantinou@xxxxxxxxxxxxxxxxxxxxxx
<mailto:cconstantinou@xxxxxxxxxxxxxxxxxxxxxx>
Web site: www.odysseyconsultants.com
<outbind://87/www.odysseyconsultants.com> 

 

___________________________________________________________________

This e-mail contains proprietary information some or all of which may be
legally privileged.  It is for the intended recipient only.  If an
addressing or transmission error has misdirected this e-mail, please
notify the author by replying to this e-mail.  If you are not the
intended recipient you must not use, disclose, distribute, copy, print
or rely on this e-mail. The content of this email may contain private
views and opinions, which do not constitute formal disclosure or
commitment unless specifically stated.

____________________________________________________________________

 

_______________________________________________
ISSForum mailing list
ISSForum@xxxxxxx

TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to
https://atla-mm1.iss.net/mailman/listinfo/issforum

To contact the ISSForum Moderator, send email to mod-issforum@xxxxxxx

The ISSForum mailing list is hosted and managed by Internet Security
Systems, 6303 Barfield Road, Atlanta, Georgia, USA 30328.

_______________________________________________
ISSForum mailing list
ISSForum@xxxxxxx

TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo/issforum

To contact the ISSForum Moderator, send email to mod-issforum@xxxxxxx

The ISSForum mailing list is hosted and managed by Internet Security Systems, 6303 Barfield Road, Atlanta, Georgia, USA 30328.