Authenticate IIS Web Application Using Application Pool Identity with MSSQL Server
A web application can be connected with MS SQL with application pool identity. While Creating a new web site in IIS, Application pool identity will be the default credential for database connection if the application used windows authentication. These steps enable the application pool to authenticate with MS SQL for all database connections. Screen shots are from a Windows server 2016 Standard with SQL Server Express 14.0. Step 1. Creating new application pool with desired name. Step 2. Create a website and select the application for the site. Step 3. Connect Sql Server with sql server management studio. Create a new database. Step 4. Add new sql server user with Application pool name as user name for authentication. The mode of authentication should be Windows Authentication. Select the default database for the user. Step 5. Assign privileges to new user for the database. Step 5. Configure web.conf with windows authentication. Example: <add...