Creating default IIS application pool user in SQL

Revision as of 09:31, 9 October 2019 by NMaudgil (talk | contribs)

If you are using the default application pool user in IIS:

Pic1.png

then you should add a login for that in SQL Server:

Pic2.png

Then set the properties for the user:

Server roles

Pic3.png

User Mapping

Pic4.png

Securables

Pic5.png

Status

Pic6.png