Difference between revisions of "Creating default IIS application pool user in SQL"

Line 7: Line 7:
 
[[image:pic2.png|centre|350px]]
 
[[image:pic2.png|centre|350px]]
  
Then set the properties for the user:
+
Then check that the Login properties for the user are set as below:
  
 
====Server roles====
 
====Server roles====

Revision as of 08:33, 9 October 2019

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 check that the Login properties for the user are set as below:

Server roles

Pic3.png

User Mapping

Pic4.png

Securables

Pic5.png

Status

Pic6.png