Feb 10, 2020 06:44 PM|bruce (sqlwork.com)|LINK
when you create an asp.net virtual directory in IIS you specify an account for the app pool the site runs in. the default is a local account. this account will not have database access. if you are using trusted security, then the app pool account will need
to be a domain account with database access. IIS manager can be used to see the app pools assigned and the accounts.
note: when you run debug with IIS express, the app pool account is your login, so it has all the permission you do.