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

Line 9: Line 9:
 
Then check that the Login properties for the user are set as below:
 
Then check that the Login properties for the user are set as below:
  
====Server roles====
+
=====Server roles=====
 
[[image:pic3.png|centre|500px]]
 
[[image:pic3.png|centre|500px]]
  
====User Mapping====
+
=====User Mapping=====
 
[[image:pic4.png|centre|500px]]
 
[[image:pic4.png|centre|500px]]
  
====Securables====
+
=====Securables=====
 
[[image:pic5.png|centre|500px]]
 
[[image:pic5.png|centre|500px]]
  
====Status====
+
=====Status=====
 
[[image:pic6.png|centre|500px]]
 
[[image:pic6.png|centre|500px]]

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