Obviously the users need to have access to the database. You can create a Windows group and place each user in it, then add that group to the SQL server with the appropriate rights. You can also use
Application Roles[
^]. However, the much more common approach in ASP.NET is to create a SQL Server user for this application and use it rather than Windows users.