Creating default IIS application pool user in SQL

Revision as of 08:34, 4 July 2023 by Csalter (talk | contribs) (Text replacement - "XLCubed" to "FluenceXL")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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 FluenceXL database created for use within SQL Repository:

Pic7.png
Securables
Pic5.png
Status
Pic6.png