troubleshooting Question

ASP.net windows authentication With SQL Server

Avatar of wilbur88
wilbur88 asked on
Microsoft SQL ServerASP.NETEditors IDEs
5 Comments1 Solution497 ViewsLast Modified:
Hello Experts

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.
ASKER CERTIFIED SOLUTION
slado2

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros