IIS app does not have permissions to access an SQLite db file

Question

Running a web api project using IIS debug profile does not allow to access, create or delete SQLite db file located in the app directory. Access denied.

The same is when I publish the project to the IIS inetpub folder and copy the db file there. The web service runs in the browser but it can't even read the db.

How to configure IIS to give it full access?

Windows 10, VS2022, IIS 10, Net Core 8.

Answer 1

@MSCollege3000

You only need to assigne the iis_iusrs and iusr permission to the inetpub folder.

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Access denied.

And where is the SQLite db file located?

The IIS service/side proxy account needs read/write access permissions on.

Answer 3

You didn't gave an answer on my question, nor further detailed informations.

Again: IIS needs read/write access permissions on.

Answer 4

Answering my own question.

IIS cannot access a db file in the app folder because neither the folder nor the db file has any IIS-related account associated with any permissions.

To grand IIS access to a desired folder or file:

• Right-click the folder or file, open Properties window, in the Security tab click Edit, then Add,
• Then if you don't know the exact name of the IIS account, click the Advanced button,
• Click Find Now
• In the list of all accounts click IIS_IUSRS and then Ok and Ok, then check all desired permissions for that account and Ok.

This allows IIS web app to create and modify db file in the folder.