Difference between revisions of "Creating default IIS application pool user in SQL"
m (Text replacement - "XLCubed" to "FluenceXL") |
|||
| (14 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
| − | + | ====Default application pool user==== | |
| + | If you are using the default application pool user in IIS: | ||
| − | + | [[image:pic1.png|centre|900px]] | |
| + | |||
| + | then you should add a login for that in SQL Server: | ||
[[image:pic2.png|centre|350px]] | [[image:pic2.png|centre|350px]] | ||
| − | [[image:pic3.png|centre| | + | Check that the Login properties for the user are set as below: |
| + | |||
| + | =====Server roles===== | ||
| + | [[image:pic3.png|centre|500px]] | ||
| + | |||
| + | =====User Mapping===== | ||
| + | |||
| + | You will need to select the FluenceXL database created for use within SQL Repository: | ||
| − | [[image: | + | [[image:pic7.png|centre|500px]] |
| − | [[image:pic5.png|centre| | + | =====Securables===== |
| + | [[image:pic5.png|centre|500px]] | ||
| − | [[image:pic6.png|centre| | + | =====Status===== |
| + | [[image:pic6.png|centre|500px]] | ||
Latest revision as of 08:34, 4 July 2023
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 FluenceXL database created for use within SQL Repository:
Securables
Status
