XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Creating default IIS application pool user in SQL"
(8 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| | + | [[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]] | ||
− | + | 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===== |
− | |||
− | ===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 08:50, 9 October 2019
Contents
[hide]Default application pool user
If you are using the default application pool user in IIS:
then you should add a login for that in SQL Server:
Check that the Login properties for the user are set as below:
Server roles
User Mapping
You will need to select the XLCubed database created for use within SQL Repository: