I currently have an access project connected to SQL Server 2005 with Windows authentication done via my Domain Controler. Each login in SQL Server is in the form mydomain/user and has a specific role in SQL Server. These roles determine what the user can access in the database. This works just fine SQL server recognizes who make the connection and grants the appropriate permissions according to there role. However we are planning to shift our front end from Access Project to ASP.net pages.
I need step by step instructions how how to mimic this authentication in asp.net. So basicly the user will login to windows like normal and open our asp.net website. They will then automaticly be authenticated into SQL Server via there windows login using the domainname/username login that exists in SQL Server and not using NT Authority/Network Service, So that the Membership Roles in SQL Server for that user will be Preserved.
Thank you for your time and I look forward to your answers.