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

 
(9 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
====Default application pool user====
 
If you are using the default application pool user in IIS:
 
If you are using the default application pool user in IIS:
  
[[image:pic1.png|centre|700px]]
+
[[image:pic1.png|centre|900px]]
  
 
then you should add a login for that in SQL Server:
 
then you should add a login for that in SQL Server:
Line 7: Line 8:
 
[[image:pic2.png|centre|350px]]
 
[[image:pic2.png|centre|350px]]
  
Then set the properties for the user:
+
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]]
 
  
==Securables==
+
You will need to select the XLCubed database created for use within SQL Repository:
 +
 
 +
[[image:pic7.png|centre|500px]]
 +
 
 +
=====Securables=====
 
[[image:pic5.png|centre|500px]]
 
[[image:pic5.png|centre|500px]]
  
==Status==
+
=====Status=====
 
[[image:pic6.png|centre|500px]]
 
[[image:pic6.png|centre|500px]]

Latest revision as of 09:50, 9 October 2019

Default application pool user

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

Check that the Login properties for the user are set as below:

Server roles
Pic3.png
User Mapping

You will need to select the XLCubed database created for use within SQL Repository:

Pic7.png
Securables
Pic5.png
Status
Pic6.png