RE: Changing authentication mode...

From: linda deng[MS] (lideng@online.microsoft.com)
Date: 10/31/02 

From: lideng@online.microsoft.com (linda deng[MS])
Date: Thu, 31 Oct 2002 14:03:00 GMT

Hi Brandt,

Instances of SQL Server must verify that the login supplied on each
connection request is authorized to access the instance.

When you use the SQL Server authentication to connect, it requires you
specify a standard account, for example, 'sa' and its password to
authenticate.

When using the Windows Authentication, you don't have to specify a login ID
or password when you connect to SQL Server 2000. Your access the SQL Server
2000 is controlled by your Windows NT account or group, which is
authenticated when you log on to the Windows operating system on the
client. When you connect, the SQL Server 2000 client software requests a
Windows trusted connection to SQL Server 2000. The properties of a trusted
connection include the Windows NT 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.

For more information, please refer to the topic: 'logins' on Microsoft SQL
Server Books Online.

Sincerely,

Linda Deng
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

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: 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 101..
    ... On Windows 2003, SQL Server 2005 can enforce the Windows password complexity ... Windows authentication - SQL Server uses a special protocol to ask ... user is in the list of allowed logins, ...
    (microsoft.public.sqlserver.security)
  • RE: How to create a trusted connection
    ... You need to grant access for the Windows login by referring to the books ... is set to use Windows authentication to be able to do trusted connection. ... There are two modes of authentication in SQL Server: ...
    (microsoft.public.sqlserver.security)