Re: Authenticating users with Active Directory and SQL Server 2000

From: Michael A. Drawbaugh (mdrawbaugh_at_msn.com)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 09:13:51 -0400

Use Windows Authentication for your web site, which will authorize the user
through AD. Then use integrated security/impersonation to pass the user
credentials to SQL for authorization and connection. Then, you can use the
USER_NAME (or similar technique) to filter the rows returned by any SQL
statement.

Hope this helps you get started...

"Enterprise Andy" <EnterpriseAndy@discussions.microsoft.com> wrote in
message news:CBD3FEF9-ACF1-4979-9A90-4B4AF44B23C9@microsoft.com...
> I've set up a web page on our network that links to an SQL Server database
containing records of staff members. At the moment the web page extracts all
the rows from the table and shows all the staff records.
>
> I want to be able to authenticate staff members using Active Directory, so
when they log onto their PC and access the webpage on our intranet they can
ONLY view their record from the database.
>
> I'm just starting out with SQL Server and Active Directory, so any help
would be appreciated. From what I have read I think that I may need to use
LDAP to retrieve the Active Directory information.
>
> Thanks in advance for your help.

Relevant Pages

  • Re: Limited Admin access
    ... Need a outside, although trusted, vendor remote access to a SQL ... They will authorize all changes with use before they do anything to ... No changing of pwds, no taking ownership of directories, no creating ...
    (microsoft.public.windows.server.sbs)
  • Limited Admin access
    ... Need a outside, although trusted, vendor remote access to a SQL program on ... They will authorize all changes with use before they do anything to the ...
    (microsoft.public.windows.server.sbs)
  • Re: Copy Active directory Users to a SQL DB table - Daily
    ... And then daily scheduled runs of the script updates the SQL table from ... from Active Directory and another to update the SQL Server database table. ... Dim strConnect, adoSQLConnection, adoSQLCommand, adoSQLRecordset ...
    (microsoft.public.windows.server.scripting)
  • Re: Replication across non-trusted domains requires Win2k Application server and not Domain Controll
    ... you can do it by using SQL authentication instead of NT authentication. ... that the SQL Agent account on your subscriber has rights to read it. ... Or is it possible to install SQL server ... > upon a Windows 2K Domain Controller(Server with Active directory ...
    (microsoft.public.sqlserver.connect)
  • Re: Replication across non-trusted domains requires Win2k Application server and not Domain Controll
    ... you can do it by using SQL authentication instead of NT authentication. ... that the SQL Agent account on your subscriber has rights to read it. ... Or is it possible to install SQL server ... > upon a Windows 2K Domain Controller(Server with Active directory ...
    (microsoft.public.sqlserver.setup)