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

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

Revision as of 08:30, 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 set the properties for the user:

Server roles

Pic3.png

User Mapping

Pic4.png

Securables

Pic5.png

Status

Pic6.png