Hello. I’m trying to understand how the pieces of ASP.NET MVC, IIS, and SQL Server all fit together for both an application using forms authentication and an application using Windows authentication.
We’re developing two ASP.NET MVC 4 applications; one will use forms authentication (an external site with usernames and passwords) and one will use Windows authentication (an internal intranet site). Both will be hosted in IIS 7.5/8 (different sites and different app pools). Both will need access to a SQL Server 2008 R2/2012 database with user-specific access to tables, sprocs, etc. The SQL Server database will be running on the same server as the IIS server.
For the ASP.NET MVC 4 site using forms authentication:
Should the IIS app pool identity be ApplicationPoolIdentity, one of the other options, or some local or domain user?
In the ASP.NET MVC 4 app, how would you configure the connection string? With a username and password? And, if so, what ...
Go to the complete details ...