Authenticating users with Active Directory and SQL Server 2000

From: Enterprise Andy (EnterpriseAndy_at_discussions.microsoft.com)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 03:28:46 -0700

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.