How to authenticate user on lan?

I am deploying a website on server(Windows server 2003) developed in ASP.Net using C#. I made a virtual directory on server for that application and set windows authentication mode in IIS and web.config.

There are a lot of users on LAN, a few of them are needed to authenticate for the application. I have windows usernames of those users in my datab开发者_JAVA技巧ase.

When user browse the application, the application only accepts the username and password that are of the server account(as a popup appears). But i need the username of the user that is locally accessing the application so that i confirm him from database as a valid user.

The application is hosted on a server (Windows Server 2003, with SQL Server 2008). What changes can be made in IIS for this?

you may want to try using active directory / LDAP. then you can create a group and assign those users to this group. so you only have to check whether the user belongs to the group.

ASP.NET / Active Directory - Supporting auto login for domain users

you don't even have to implement a login form using a DB..

an example using MVC and ASP.NET: http://www.asp.net/mvc/tutorials/authenticating-users-with-windows-authentication-cs